Oracle Database 12c: Advanced Administration — Question 93

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: B

Explanation

The correct sequence starts with identifying the appropriate backup that contains the corrupted table (Step 1), followed by executing the recover table RMAN command (Step 2). Steps 3 and 4, which involve importing and exporting dump files, are not required immediately after recovering the table, making option B the only correct choice.