David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to
help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day.
They are using a recovery catalog for this database.
What steps did Bill perform to recover the database and in what order?
a. Restored the control file with the RMAN restore controlfile command.
b. Mounted the DSL instance with the alter database mount command.
c. Restored the datafiles for the DSL database with the RMAN restore command.
d. Opened the DSL database with the alter database open resetlogs command.
e. Recovered the datafiles for the DSL database with the RMAN recover command.
f. Started the DSL instance.
g. Connected to the recovery catalog with RMAN.
A.
a, b, c, d, e, f, g
B.
b, c, d, g, f, e, a
C.
g, f, a, b, c, e, d
D.
c, a, d, b, f, e, g
E.
g, f, a, b, e, c, d
Explanation:
About Recovery with a Backup Control File
If all copies of the current control file are lost or damaged, then you must restore and mount a backup control
file. You must then run the RECOVER command, even if no data files have been restored, and open the
database with the RESETLOGS option. If some copies of the current control file are usable, however, then you
can follow the procedure in “Responding to the Loss of a Subset of the Current Control Files” and avoid the
recovery and RESETLOGS operation.
When RMAN is connected to a recovery catalog, the recovery procedure with a backup control file is identical
to recovery with a current control file. The RMAN metadata missing from the backup control file is available
from the recovery catalog. The only exception is if the database name is not unique in the catalog, in which
case you must use SET DBID command before restoring the control file.
1. Start RMAN and connect to a target database.
2. Start the target instance without mounting the database. RMAN>STARTUP NOMOUNT;
3. Restore the control file
RMAN> SET DBID 320066378; # (Optional) If the database name is not unique, you
need to specify the DBID
RMAN> RUN
{
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘autobackup_format’;
RESTORE CONTROLFILE FROM AUTOBACKUP;
}
4. Start the target instance with mounting the database. RMAN>STARTUP MOUNT;
5. Restore the data files; RMAN>RESTORE DATABASE;
6. Recover the database; RMAN>RECOVER DATABASE;
7. Open the database with RESETLOGS option; RMAN> ALTER DATABASE OPEN RESETLOGS;