Recovering with the backup control file using RMAN

Try recovering with the current control file.

Continue with the backup control files only if the attempt to use the current control file fails.

To exit from rman, at the command prompt, type exit.

Before using the backup control files, try using one of the three current control files.

1. /dbase/system/control01.ctl (Solaris) or E:\data\dbase\system\control01.ctl (Windows)

2. /dbase/index2/control02.ctl (Solaris) or E:\data\dbase\index2\control02.ctl (Windows)

3. /dbase/data2/control03.ctl (Solaris) or E:\data\dbase\data2\control03.ctl (Windows)

All these files should be identical.

If a problem occurs with any of the current control files, copy one of the others over the problem file, then try again to recover using the current control file.

For example, if control01.ctl exists, but control02.ctl is missing, you can create a copy of control01.ctl by typing

cp /dbase/system/control01.ctl /dbase/index2/control02.ctl (Solaris)

copy E:\data\dbase\system\control01.ctl E:\data\dbase\system\control02.ctl (Windows)

If all control files have been lost, try to recover using RMAN. At a command prompt, type

rman target /

To restore the control file, type

startup nomount;

restore controlfile from autobackup;

shutdown abort;

startup mount;

To start the recovery of the database, type

rman target /

restore database;

recover database;

If you see the message Media recovery complete, type

alter database open resetlogs;

Type exit.

Manually back up the database.

You must do the backup immediately.