Oracle Database 12c: Advanced Administration — Question 53

You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

Answer options

• A. Execute catproc.sql to recompile invalid PL/SQL modules.
• B. Open the database with the resetlogs option.
• C. Set a new database identifier (DBID) for the newly restored database.
• D. Use the RMAN set newname and switch commands to switch to new files.

Correct answer: A

Explanation

The correct answer is A because executing catproc.sql helps to recompile any invalid PL/SQL modules that may have been affected during the restoration process. Options B and C are not necessary at this stage, as opening the database with resetlogs and setting a new DBID are actions that would typically follow further configurations. Option D is also not required immediately after restoring the database.