OCP CBT Question 572

Please solve the following question.

Your Oracle database is operating in `NOARCHIVELOG` mode. The primary disk containing all data files, temp files, and redo logs has completely failed, resulting in the loss of the entire database. You have an RMAN full backup taken yesterday. What is the most appropriate recovery strategy?

sql-- Database is in NOARCHIVELOG mode.-- No online redo logs or archived redo logs are available.-- Latest full backup was taken yesterday.-- All data files are lost.

sqlRMAN> STARTUP NOMOUNT;RMAN> RESTORE DATABASE;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN RESETLOGS;

sqlRMAN> RESTORE DATABASE;RMAN> RECOVER DATABASE UNTIL SCN (SELECT MAX(CHECKPOINT_CHANGE#) FROM V$DATAFILE);RMAN> ALTER DATABASE OPEN;

sqlRMAN> RESTORE DATABASE;RMAN> ALTER DATABASE OPEN;

sqlRMAN> SHUTDOWN IMMEDIATE;RMAN> STARTUP MOUNT;RMAN> FLASHBACK DATABASE TO LATEST_BACKUP;RMAN> ALTER DATABASE OPEN;