Upgrade Oracle DBA 11g to Oracle Database 12c — Question 9

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1.Determine which backup contains the table that needs to be recovered.
2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3.Import the Data Pump export dump file into the auxiliary instance.
4.Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.

Answer options

• A. 1, 4, 3
• B. 1, 2
• C. 1, 4, 3, 2
• D. 1, 2, 4

Correct answer: D

Explanation

The correct steps begin with identifying the backup containing the corrupted table (step 1), followed by executing the recover table RMAN command (step 2) to restore the table to the specified point in time. Steps 3 and 4, which involve importing and exporting the data, occur after the recovery, making option D the correct sequence.