Given the following RMAN commands, choose the option that reflects the order required to restore
your currently operational ARCHIVELOG-mode database.
a. restore database;
b. recover database;
c. shutdown immediate
d. startup
e. restore archivelog all;
f. alter database open
A.
a, b, c, d, e, f
B.
c, b, a, d, e, f
C.
c, b, a, d, f
D.
c, a, b, d
E.
c, a, e, b, d, f
About E: ‘alter database open’ is done after ‘startup’. Something is wrong there….
D. You would shut down the database with the command before the recovery. You would then issue the command followed by the command. After you have recovered the database, you will want to open it with the command.
From 1Z0-053 OCP Study Guide (Robert G. Freeman, Charles A. Pack, Doug Stuns, Tim Buterbaugh)
D. You are not required to explicitly restore the archives.
D. I don’t see how D is correct. How can you recover when the DB was shutdown. Needed to have been started, ‘mount’…
‘E’ also doesn’t make sense, why startup followed immediately by alter database open. Startup opens the database anyway. Even if d. startup is changed to ‘startup mount’, having f after d still is a useless exercise.
So, I don’t think the right answer is listed.
This question doesn’t make any sense!