1Z0-060 · Question #176
You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN: RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION `+RECO'; Which five steps are performed by…
The correct answer is C. flashing back the original database to the desired point in time D. recovering the auxiliary database to the desired point in time E. creating an auxiliary instance F. importing the SCOTT.EMP table into the original database G. restoring the tablespaces required for point-in-time recovery. RMAN RECOVER TABLE performs table-level point-in-time recovery by automatically creating an auxiliary instance, restoring and recovering it to the target time, then importing the recovered table back into the production database.
Question
You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION `+RECO'; Which five steps are performed by RMAN?
Options
- Atruncating the SCOTT.EMP table in the original database
- Bexporting the SCOTT.EMP table from the auxiliary database
- Cflashing back the original database to the desired point in time
- Drecovering the auxiliary database to the desired point in time
- Ecreating an auxiliary instance
- Fimporting the SCOTT.EMP table into the original database
- Grestoring the tablespaces required for point-in-time recovery
- Hdropping the SCOTT.EMP table in the original database
How the community answered
(25 responses)- A4% (1)
- B12% (3)
- C60% (15)
- H24% (6)
Why each option
RMAN RECOVER TABLE performs table-level point-in-time recovery by automatically creating an auxiliary instance, restoring and recovering it to the target time, then importing the recovered table back into the production database.
RMAN does not truncate SCOTT.EMP in the original database as part of the RECOVER TABLE process - the Data Pump import handles replacing the table's data without a prerequisite truncate.
The export from the auxiliary database is an internal step managed automatically by RMAN's Data Pump integration and is not listed as a discrete user-visible step in the RECOVER TABLE workflow.
RMAN aligns recovery to the desired point in time (SYSDATE-2) by orchestrating the auxiliary instance recovery to that SCN, ensuring the table's historical state is captured without altering the original database's current datafiles.
The auxiliary database is recovered to the specified point in time (SYSDATE-2), making the historical version of SCOTT.EMP available for subsequent extraction and import back into the production database.
RMAN automatically creates a temporary auxiliary instance to host the restored tablespaces and perform point-in-time recovery without affecting the production database at all.
After recovery on the auxiliary instance, RMAN uses an internal Data Pump process to import the recovered SCOTT.EMP table into the original production database.
RMAN restores the tablespaces that contain SCOTT.EMP and any dependent objects to the auxiliary instance so that recovery to the target time can proceed correctly.
RMAN does not drop SCOTT.EMP in the original database during RECOVER TABLE - the import step overwrites or merges the recovered data without requiring the original table to be dropped first.
Concept tested: RMAN table-level point-in-time recovery workflow steps
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-table-partitions.html
Topics
Community Discussion
No community discussion yet for this question.