Multiple choice

A loss of data files was experienced in a database. The control files however, were not lost. RMAN was being used to restore and recover the database. Currently, the instance is shut down. Which sequence of commands is correct to restore and recover the database?

  1. RMAN> STARTUP NOMOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN;

  2. RMAN> STARTUP MOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN

  3. RMAN> STARTUP NOMOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN RESETLOGS;

  4. RMAN> STARTUP MOUNT; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN RESETLOGS;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When data files are lost but control files are intact, the database starts in NOMOUNT state to read control files, then RESTORE DATABASE recovers the data files from backup, RECOVER DATABASE applies archived and online redo logs, and ALTER DATABASE OPEN opens normally without RESETLOGS since no control file creation occurred. Option B is incorrect because NOMOUNT is required when instance is down. Option C and D incorrectly use RESETLOGS unnecessarily.

Keep practicing — related questions