Which command would you execute to proceed further?

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and
archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has
written everything to disk. Which command would you execute to proceed further?

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and
archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has
written everything to disk. Which command would you execute to proceed further?

A.
RECOVER LOGFILE BLOCK GROUP 2;

B.
ALTER DATABASE DROP LOGFILE GROUP 2;

C.
ALTER DATABASE CLEAR LOGFILE GROUP 2;

D.
ALTER DATABASE RECOVER LOGFILE GROUP 2;

E.
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;



Leave a Reply 2

Your email address will not be published. Required fields are marked *


jean

jean

If the corrupt redo log file has not been archived, use the UNARCHIVED keyword in the statement. ( Redo log blocks are corrupted and archiving has stopped)

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP #;

rosh

rosh

CORRUPTED -> CLEAR UNARCHIVED (bc ARCHIVED is STOPPED)