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
Maybe a mistake in the question, as the given answer can’t be correct. “Shutdown immediate” cannot be followed with “restore database”?
D. You would shut down the database with the shutdown immediate command before the
recovery. You would then issue the restore database command followed by the recover
database command. After you have recovered the database, you will want to open it with the startup command. Validated the answer from OCP Oracle 11g Admin Cert Study Guide Chapter 6 question 2.
BTW the comment is what the writer of the book wrote as the explanation.
That doesn’t make any sense!
E is wrong because you cant issue alter database open after you have startup you instance. When you issue startup, oracle will read the parameter file to build up the instance then it will read the control file to mount the database. Smon will also check if the database was shutdown normally or abnormally during the last shutdown to see whether it needs to perform recovery. After this process, oracle will then check all the database datafile for consistentcy i.e if they have the same system change number before it can now open the database. D is correct to my knowledge.
this question is just wrong, better to just work out the best answer and move on to the next question.