Which action should you perform immediately after using this command?

The database is running in the ARCHIVELOG mode. It has three redo log groups with one
member each. One of the redo log groups has become corrupted. You have issued the
following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

The database is running in the ARCHIVELOG mode. It has three redo log groups with one
member each. One of the redo log groups has become corrupted. You have issued the
following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

A.
You should perform a log switch

B.
You should make a backup of the database

C.
You should switch the database to the NOARCHIVELOG mode

D.
You should shut down the database instance and perform a complete database recovery



Leave a Reply 1

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


ola

ola

I think B is the correct answer because anytime you use alter database clear unachived logfile command, the next thing is to backup your database.