If controlfile has been dropped and we are running in archivelog mode, what options do we have to restore controlfile.
1. RMAN> startup nomount
2. RMAN> restore controlfile from autobackup;
3. RMAN> alter database mount;
4. RMAN> recover database;
5. RMAN> alter database open resetlogs;
Procedure is same if any archivelog is missing
1. RMAN> startup nomount
2. RMAN> restore controlfile from autobackup;
3. RMAN> alter database mount;
4. RMAN> recover database;
5. RMAN> alter database open resetlogs;
Procedure is same if any archivelog is missing
No comments:
Post a Comment
Please write your comments here.