OCP CBT Question 575

Please solve the following question.

A logical corruption has occurred on a specific table named `AUDIT_LOG` within the `TOOLS` tablespace at 11:00 AM. You need to recover this table to its state at 10:55 AM, and all other tables in the `TOOLS` tablespace and other tablespaces must remain at the current point in time. The database is in ARCHIVELOG mode and Flashback Database is enabled. What is the most efficient and least disruptive method to achieve this specific recovery?

sql-- Database is currently open and active.-- Logical corruption on table AUDIT_LOG in TOOLS tablespace at 2023-07-01 11:00:00.-- Recovery desired to 2023-07-01 10:55:00.-- Flashback Database is enabled.-- ARCHIVELOG mode.

sqlFLASHBACK TABLE AUDIT_LOG TO TIMESTAMP '2023-07-01 10:55:00';

sqlRMAN> RECOVER TABLESPACE TOOLS UNTIL TIME '2023-07-01 10:55:00' AUXILIARY DESTINATION '/u02/aux_recovery';

sqlSHUTDOWN IMMEDIATE;STARTUP MOUNT;FLASHBACK DATABASE TO TIMESTAMP '2023-07-01 10:55:00';ALTER DATABASE OPEN RESETLOGS;

sqlSQL> CREATE TABLE AUDIT_LOG_OLD AS SELECT * FROM AUDIT_LOG AS OF TIMESTAMP '2023-07-01 10:55:00';SQL> TRUNCATE TABLE AUDIT_LOG;SQL> INSERT INTO AUDIT_LOG SELECT * FROM AUDIT_LOG_OLD;SQL> DROP TABLE AUDIT_LOG_OLD;