Because of logical corruption of data in a table, you want to recover the tablefrom 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
B
D
Steps Performed By RMAN to Recover Tables and Table Partitions
RMAN performs the following steps while automating the process of recovering tables or table partitions from an RMAN backup:
Determines which backup contains the tables or table partitions that need to be recovered, based on the point in time specified for the recovery.
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.
(Optional) Imports the Data Pump export dump file into the target instance.
You can choose not to import the export dump file that contains the recovered tables or table partitions into the target database. If you do not import the export dump file as part of the recovery process, you must manually import it later using the Data Pump Import utility.
(Optional) Renames the recovered tables or table partitions in the target database.
B is correct.
Recover Table …. everything handles behind the scene
Both options are right, i guess ! B and D
It depends of interpretation. I think this is a question poorly formulated.
B