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
All members of the current online redo log group are not available. Which action does
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 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.
B: LGWR w...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide