Control file recovery, from RMAN

[LKBrwn_DBA]

Without catalog, you may need to supply the backup file name -- no SCN necesary (yet), but you need to set the dbid:

SET DBID=<integer>
RUN {
ALLOCATE CHANNEL CH1 TYPE DISK; 
RESTORE CONTROLFILE FROM FILE '<path>/<bkp file>'; 
SQL ‘ALTER DATABASE MOUNT’; 
} 

To restore the DB you may need an SCN or SET UNTIL TIME...


PS: Pls check for correct syntax.