what order?

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?

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.
a, b, c, d, e, f, g

B.
Mounted the DSL instance with the alter database mount command.
b, c, d, g, f, e, a

C.
Restored the datafiles for the DSL database with the RMAN restore command.
g, f, a, b, c, e, d

D.
Opened the DSL database with the alter database open resetlogs command.
c, a, d, b, f, e, g

E.
Recovered the datafiles for the DSL database with the RMAN recover command.
g, f, a, b, e, c, d

F.
Started the DSL instance.

G.
Connected to the recovery catalog with RMAN.

A.
Restored the control file with the RMAN restore controlfile command.
a, b, c, d, e, f, g

B.
Mounted the DSL instance with the alter database mount command.
b, c, d, g, f, e, a

C.
Restored the datafiles for the DSL database with the RMAN restore command.
g, f, a, b, c, e, d

D.
Opened the DSL database with the alter database open resetlogs command.
c, a, d, b, f, e, g

E.
Recovered the datafiles for the DSL database with the RMAN recover command.
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;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Magwai

Magwai

The answer is C, but the question should look as follows:
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 with the startup nomount command.
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