Organizational Research By

Surprising Reserch Topic

boostr.in questions - Question:A loss of data files was experienced in a database. The control files however, were not lost. RMAN was being used to restore and recover the database. Currently, the instance is shut down. Which sequence of commands is correct to restore and recover the database?


a.        RMAN> STARTUP NOMOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;
b.        RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN
c.        RMAN> STARTUP NOMOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
d.        RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
11 views



Related Hot Questions



Government Jobs Opening


...