Oracle Database full restore using RMAN
Each and every dba someday will or will not face this situation. But anyway I had to face this scenario. So I decided to blog the steps I followed thinking this might be helpful to some other newbie like me..... 1) Create all the mountpoint as identical to the source 2) Copy all the RMAN backup files to the RMAN source directory 3) Put the DB in to the nomount state startup nomount 4) set the environment using . oraenv(if linux) 5) connect to RMAN RMAN taget / 6) Restore the control file RMAN> restore controlfile from '/BACKUP/RMAN_BACKUP/DB1/c-974303543-20120319-00'; 7) Mount the database RMAN> Alter database mount 8) select the max sequence using SQL> select max(sequence#) from v$log; 9) Connect back to the RMAN and execute RMAN> run { set until sequence $number; restore database; } P.S $number is the number found executing the statement...