OCP CBT Question 566

Please solve the following question.

You are a DBA and discover that a critical table, EMPLOYEES, was accidentally dropped 30 minutes ago at 10:00 AM on July 1, 2023. The database is in ARCHIVELOG mode, and you have recent RMAN backups. You want to perform a point-in-time recovery to a state just before the table was dropped. Which set of RMAN commands should you execute to achieve this?

sql-- Current time: July 1, 2023, 10:30 AM-- Table EMPLOYEES was dropped at approximately July 1, 2023, 10:00 AM-- Flashback Database is NOT enabled.-- The database name is ORCL.

sqlRMAN> SHUTDOWN IMMEDIATE;RMAN> STARTUP MOUNT;RMAN> RESTORE DATABASE UNTIL TIME '2023-07-01 10:00:00';RMAN> RECOVER DATABASE UNTIL TIME '2023-07-01 10:00:00';RMAN> ALTER DATABASE OPEN RESETLOGS;

sqlRMAN> FLASHBACK DATABASE TO TIMESTAMP '2023-07-01 10:00:00';RMAN> ALTER DATABASE OPEN RESETLOGS;

sqlRMAN> SQL 'ALTER DATABASE CLOSE';RMAN> RESTORE DATABASE;RMAN> RECOVER DATABASE UNTIL CANCEL;RMAN> CANCEL;RMAN> ALTER DATABASE OPEN RESETLOGS;

sqlRMAN> SHUTDOWN IMMEDIATE;RMAN> STARTUP MOUNT;RMAN> RESTORE DATABASE UNTIL SCN (SELECT CURRENT_SCN FROM V$DATABASE) - 1000;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN RESETLOGS;