Rman Cold , Hot Backup & Recover :

Cold Backup :

Rman target /

Rman > spool log to ‘/mnt/sas/SVRQAT/cold_backup.log’;

run {
allocate channel t1 type disk;
allocate channel t2 type disk;
allocate channel t3 type disk;
allocate channel t4 type disk;
allocate channel t5 type disk;
allocate channel t6 type disk;
backup as compressed backupset format='/nfs/db_rman_bkp/SVRQAT/%U' database;
backup format='/nfs/db_rman_bkp/SVRQAT/Tp_cntl_%Y%M%D_%d_%s_%p.ctl' current controlfile;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
release channel t6;
}


Recovery :
1.Restore the old controlfile from rman , mount the database with old controlfile
and run following script.

Solution A:

run {
      startup mount;
      set until time "to_date('16-JUN-2014 22:08:00','DD-MON-YYYY HH24:MIS')";
      restore database;
      recover database;
      alter database open resetlogs;
}

Solution B:

RMAN> run {
restore database;
recover database noredo;
alter database open resetlogs;
}