Question 2) Oracle Database 10g Administration

Single Answer Multiple Choice

The online redo log group configuration for your database is as follows:

What will happen if the online redo log file ‘ora02/oradata/redo02b.log’ is corrupted while working on the database?

A. The database will hang.
B. The database will crash.
C. The database will shut down.
D. The LGWR process writes redo log entries to the other redo log member of the Group2 group.

Answer:
D. The LGWR process writes redo log entries to the other redo log member of the Group2 group.

Tutorial:
In this scenario, the online redo log groups are multiplexed. While multiplexing the online redo log files, it is preferable to keep the members of a group on different disks to ensure that one disk failure does not affect the ongoing operation of the database. If the LGWR process can write the redo log entries to at least one member of the group, the database operation proceeds as normal. An entry is written to the alert.log file.

The other options stating that the database will hang or crash, or shut down due to the failure of a redo log member are incorrect.

Reference:
Oracle Database 10g: Administration Workshop II
Chapter 13: Monitoring and Managing Storage

Oracle Database Administrator’s Guide
10g Release 1 (10.1)
Part Number B10739-01
Chapter: 6 Managing the Redo Log
Topic: Multiplexing Redo Log Files
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/onlineredo.htm#sthref809

These questions are derived from the Self Test Software Practice Test for Oracle exam #IZ0-043: Oracle Database 10g: Administration II.