Recovery from Complete Loss (No Controlfile)

Recovery from complete loss (no control file and no pfile or spfile)

1. find out DBID of lost database. This can done by checking control file autobackup location.


2. $ export ORACLE_SID=TEST


3. $ sqlplus / as sysdba
   
4. SQL> startup force nomount
   
5. Restore spfile
   $rman
   rman> set dbid=4885937635
   rman> connect catalog rman/rman@dbcatalog
   rman> restore spfile from autobackup;
   rman> shutdown immediate;
   rman> startup nomount
   
6. Restore the control file and mount database from restored control file.
   rman> restore controlfile from autobackup;
   rman> alter database mount;
7. Restore the datafile and perform media recovery.
   rman> restore database;
   rman> recover database;
   rman> alter database open resetlogs;