OCP CBT Question 519

Please solve the following question.

A critical alert informs you that one of your database instances has lost a member of an active redo log group. You examine the `V$LOGFILE` view and see the following:

sqlSELECT GROUP#, MEMBER, STATUS FROM V$LOGFILE;GROUP# MEMBER STATUS------ -------------------------------------------- -------- 1 /u01/app/oracle/oradata/mydb/redo01a.log STALE 1 /u01/app/oracle/oradata/mydb/redo01b.log STALE 2 /u01/app/oracle/oradata/mydb/redo02a.log STALE 2 /u01/app/oracle/oradata/mydb/redo02b.log STALE 3 /u01/app/oracle/oradata/mydb/redo03a.log CURRENT 3 /u01/app/oracle/oradata/mydb/redo03b.log STALE 4 /u01/app/oracle/oradata/mydb/redo04a.log INACTIVE 4 /u01/app/oracle/oradata/mydb/redo04b.log INACTIVE

The database will immediately crash because a CURRENT log member is STALE.

The database is still operational but has lost redundancy for the current redo log group.

You must perform a full database restore and point-in-time recovery immediately.

The database automatically recovers the STALE member using another member in the same group.