Which action must you take for recovery?

You are administering a database that supports a data warehousing workload and is
running in no archivelog mode. You use RMAN to perform a level 0 backup on Sundays and
level 1 incremental backups on all the other days of the week. One of the data files is
corrupted and the current online redo log file is lost because of a media failure. Which action
must you take for recovery?

You are administering a database that supports a data warehousing workload and is
running in no archivelog mode. You use RMAN to perform a level 0 backup on Sundays and
level 1 incremental backups on all the other days of the week. One of the data files is
corrupted and the current online redo log file is lost because of a media failure. Which action
must you take for recovery?

A.
Restore the data file, recover it by using the recover datafilenoredo command, and use
the resetlogs option to open the database.

B.
Restore the control file and all the data files, recover them by using the recover database
noredo command, and use the resetlogs option to open the database.

C.
Restore all the data files, recover them by using the recover database command, and
open the database.

D.
Restore all the data files, recover them by using the recover database noredo command,
and use the resetlogs option to open the database.



Leave a Reply 1

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