#Recovers a ARCHIVELOG database from loss of ALL Control Files
#You may have to catalog missing archivelog files
#command is CATALOG ARCHIVELOG 'xxxxxx';
#After Cataloging the missing archivelog files just start
#the recovery process again - no need to repeat the restore operation
startup nomount
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
restore controlfile to '/u1/ORACLE/reco/control01.ctl';
replicate controlfile from '/u1/ORACLE/reco/control01.ctl';
sql 'alter database mount';
restore database;
recover database;
sql 'alter database open resetlogs';
release channel c1;
release channel c2;
}