1z0-067 Exam QuestionsBrowse all questions from this exam

1z0-067 Exam - Question 4


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.

Show Answer
Correct Answer: D

To recover a table from an RMAN backup to a specified point in time due to logical corruption, you need to determine the backup containing the table, issue the recover table RMAN command with the appropriate parameters, and then create a Data Pump export dump file for the recovered table. Step 1 is necessary to identify the correct backup, step 2 involves using the RMAN recover table command with the auxiliary destination and specified recovery time, and step 4 allows for the creation of the dump file on the target database. Importing the Data Pump export dump file into the auxiliary instance (step 3) is not required in this process. Hence, the correct sequence is 1, 2, 4.

Discussion

3 comments
Sign in to comment
haithamheshamOption: B
Nov 13, 2020

I think B is the correct answer

VIKY786Option: C
Oct 17, 2020

C is the correct answer

ulazmxOption: A
Feb 28, 2021

I think, the correct answer is A