Wednesday, March 15, 2006

recover controlfile from rman autobackup

- startup database nomount
sql> startup nomount;
ORACLE instance started

- recover control file
rman target /
rman> set dbid 2332622722
executing command: SET DBID
rman> restore controlfile from autobackup;
rman> alter database mount;
rman> recover database;
rman> alter database open resetlogs;
database opened

No comments: