E vinstance shows information about oracle instance

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ation about Oracle instance itself, not redo log groups. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 325-327 Chapter 7: Managing the Physical Database Structure QUESTION 87: All members of the current online redo log group are not available. Which action does Oracle take? A. The instance crashes. B. The instance writes to the next online redo log group. C. The instance hangs until the DBA switches the redo log file. D. The instance hangs until the DBA restart the archive process. Actualtests.com - The Power of Knowing 1Z0-023 Answer: A Explanation: Answer A is correct. The instance will crash if all members of the current online redo log group are not available. To avoid this situation Oracle recommends to use multiplexing of redo log files. If the redo log file has only one member, or if multiple online redo log members are not multiplexed and not available, LGWR will not be able to write redo log entries, and the Oracle instance will fail. Incorrect Answers: B: LGWR w...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online