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
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
According to this reference, I think D is correct, at least more reasonable.
Except D doesn’t include the Import step, step number 3. C, for now, seems the most likely.
D
B
Siegried you can explain why B?
D, no one said that you are to import the table back, just recover it.
Steps Performed By RMAN to Recover Tables and Table Partitions
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 and recovers the specified tables or table partitions, until the specified point in time, into this auxiliary database.
3. Creates a Data Pump export dump file that contains 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.
I think its B. You create the export on the auxiliary database, not on target…
I think it’s B too.
Coorect B.
Reference:
http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV686
B
B if you think Logical
D (as Greg mentioned) if you adhere to the Oracle PDFs
D
It’s B. Rman table Point in Time recovery does export and import automatically
B
B
A -incorrect
As Vonpire said: No point in exporting corrupted table from target db.
B -correct
As OCA said – export/import is done automagically
https://oracle-base.com/articles/12c/rman-table-point-in-time-recovery-12cr1
C -incorrect
Same as A
D-incorrect
Same as A
B