Restore Database

Startup nomount

run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/_tdpo.opt)';
set until time "TO_DATE('04/OCT/2011 11:10:00 ','DD/MON/YYYY HH24:MI:SS')";
restore controlfile;
release channel t1;
}

alter database mount;


$date

run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/_tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/_tdpo.opt)';
set until time "TO_DATE('04/OCT/2011 11:10:00 ','DD/MON/YYYY HH24:MI:SS')";
restore database;
recover database;
release channel t1;
release channel t2;
}


alter database open resetlogs;