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

With control files intact, STARTUP NOMOUNT is sufficient (control files exist so MOUNT isn't needed). The sequence is: NOMOUNT → RESTORE → RECOVER → OPEN. RESETLOGS is only required after incomplete recovery or missing logs, which isn't stated here. Option A shows the correct sequence without RESETLOGS.

Keep practicing — related questions