In your production database, you:
Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup
operation at regular intervals
Set the control file autobackup to “on”
Are maintaining image copies of the database files
You have lost the server parameter file (SPFILE) and the control file.
Which option must you consider before restoring the SPFILE and the control file by using the
control file autobackup?
A.
Setting DBID for the database
B.
Using the RMAN SWITCH command
C.
Using the RMAN SET NEWNAME command
D.
Starting up the database instance in the NOMOUNT state
i thought it was answer b
In case you`ve lost spfile and controlfile, you must first
rman> set dbid …
then
rman> startup force nomount
and only after this you`ll be able to restore control file, spfile and everything else.
rman> set dbid … — this is used before restoring the control file if not using an RC (above it says “with a recovery catalog”)
rman> set dbid … — could also be used if the database name is not unique in the RC
i.e. A is wrong.
Answer D is correct as you must start up the database instance in the NOMOUNT state, i.e. just do a
rman> startup force nomount
he’s right. You cannot mount if there’s no PFILE or Controlfile.