Which statement regarding the above command is correct?

You executed the following command:

RMAN> RECOVER COPY OF DATAFILE ‘/U01/app/oracle/oradata/orcl/users01.dbf’;

Which statement regarding the above command is correct?

You executed the following command:

RMAN> RECOVER COPY OF DATAFILE ‘/U01/app/oracle/oradata/orcl/users01.dbf’;

Which statement regarding the above command is correct?

A.
The ‘/u01/app/oracle/ordata/orcl/users01.dbf’ data file is recovered from the image copy.

B.
The ‘/u01/app/oracle/ordata/orcl/users01.dbf’ data file is recovered from the last incremental backup.

C.
Image copies of the ‘/u01/app/oracle/ordata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.

D.
Image copies of the ‘/u01/app/oracle/ordata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

Explanation:
In Oracle10g, you can now recover datafile copies by applying changed blocks from a change tracking file to the datafile image copy. This is an important feature as it will significantly speed up datafile recovery times. It is done in 2 stages:
1. Use an RMAN command to update the datafile image copy with changed blocks:
RMAN> recover copy of datafile <old_datafile_name>;
2. Apply any archived redo logs to fine-tune the datafile to the exact point-in-time or SCN.
REF.: Oracle(r) Database 10g : New Features for Oracle 8i DBAs, 18-19



Leave a Reply 0

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