Oracle Database 12c: Advanced Administration — Question 3

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?

Answer options

• A. Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.
• B. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.
• C. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.
• D. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.

Correct answer: A

Explanation

The correct answer is A because restoring the control file with the CATALOG option ensures that RMAN is aware of the backups, allowing for the correct restoration of data files. Options B and C do not utilize the recovery catalog correctly, and option D incorrectly suggests using the SWITCH command, which isn't necessary when using the CATALOG option for the control file restoration.