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
Explanation:
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
Ans D
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
1. Determines which backup contains the tables or table partitions that need to be recovered, based on the point in time specified for the recovery.
2. 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.
You can specify the location on the target host to which the recovered data files are stored in the auxiliary database.
3. Creates a Data Pump export dump file that contains the recovered tables or table partitions.
You can specify the name and the location of the export dump file used to store the metadata of the recovered tables or table partitions.
4. (Optional) Imports the Data Pump export dump file into the target instance.
5. (Optional) Renames the recovered tables or table partitions in the target database.
B, because RMAN perform these steps for u