Which two are prerequisites for performing this operation?

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation?

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation?

A.
You must configure a block change tracking file.

B.
You must use an incremental level-1 backup to restore blocks.

C.
You must ensure that the database is mounted or open.

D.
You must have full or level-0 backups to restore blocks.

E.
You must take the tools01.dbf data file offline.

Explanation:
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be proxy copies or incremental backups.
References: Oracle Database, Backup and Recovery User’s Guide, 12 Release 2 (January 2017), page 19-4



Leave a Reply 0

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