1Z0-060 Question #221: Real Exam Question with Answer & Explanation

Question

Options

• AExecute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571
• BExecute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN
• CPerform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a
• DPerform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on

Explanation

To undo a FLASHBACK TABLE operation, issuing another FLASHBACK TABLE statement targeting the original SCN is the fastest method because it is an online, in-place operation requiring no downtime.

Common mistakes.

• A. RMAN RECOVER BLOCK is a block media recovery command designed to repair physically corrupt data blocks using archived logs, not a mechanism to reverse a logical FLASHBACK TABLE operation.
• C. Table point-in-time recovery (DBPITR) requires taking the affected tablespace offline, restoring from backup, and applying redo - a multi-step offline process far slower than a simple FLASHBACK TABLE command.
• D. Tablespace point-in-time recovery is even more disruptive than table PITR, requiring the entire tablespace to be taken offline and recovered, making it the least efficient option for reversing a flashback operation.

Concept tested. Reversing Flashback Table using SCN-based flashback

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-oracle-flashback-technology.html

No community discussion yet for this question.