Oracle Database 12c: Advanced Administration — Question 79

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

Answer options

• A. by using the RMAN switch command to set the new location for the data files
• B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
• C. by using the RMAN duplicate command with dbid and set newname for tablespace to recover the database to the new host
• D. by creating a new database in the new host, and then using the RMAN recover command

Correct answer: D

Explanation

The correct answer is D because creating a new database on the new host and then using the RMAN recover command allows you to properly configure the database in its new environment while maintaining a connection to the recovery catalog. Options A, B, and C are incorrect as they do not provide a complete solution for duplicating the database while keeping the production database open or do not utilize the recovery catalog effectively in the context of a new host.