Exam 1z0-063 topic 1 question 6 discussion

Actual exam question from Oracle's 1z0-063

Question #: 6
Topic #: 1

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.

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

Show Suggested Answer

Suggested Answer: B 🗳️
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689

by sherifelia at Feb. 2, 2020, 1:48 p.m.

Comments

Submit Cancel

noureldin

2 years, 9 months ago

Correct Answer: B

upvoted 1 times

...

charan94

3 years, 9 months ago

No need to mention particularly the backup of the table . We can directory use Table PITR command to recover the table before the corruption.. Here ,option B is near to the correct answer..

upvoted 1 times

...

dba_duda

4 years, 2 months ago

its D? Doku says: Determines which backup contains the tables or table partitions that need to be recovered, Creates an auxiliary database on the target host and recovers the specified tables or table partitions, until the specified point in time, into this auxiliary database, Creates a Data Pump export dump file that contains the recovered tables or table partitions,Imports the Data Pump export dump file into the target instance

upvoted 4 times