1Z0-067 · Question #113
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…
The correct answer is B. 1, 2. Because according to oracle PDFs if you run restore table ... auxiliary a impede and rename can be included. So there is no reason to make the import manually if it can be already included in https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
Question
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.
Options
- A1, 4, 3
- B1, 2
- C1, 4, 3, 2
- D1, 2, 4
How the community answered
(46 responses)- A9% (4)
- B83% (38)
- C2% (1)
- D7% (3)
Explanation
Because according to oracle PDFs if you run restore table ... auxiliary a impede and rename can be included. So there is no reason to make the import manually if it can be already included in https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
Topics
Community Discussion
No community discussion yet for this question.