Saturday 31 August 2013

Point in Time Recovery cross restore RMAN

Steps:


1) restore Controlfile

rman target / catalog /@CATALOG
set dbid=xxxxxxxxxxxxxxxxxx
set 

 run
{
allocate channel dev1 type tape PARMS='...';
set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore controlfile from autobackup;
}

SQL> alter database mount;

Recover database
run
{
allocate channel dev1 type tape PARMS='...';
set newname for datafile 1 to '';
.
.
.
set newname for datafile 99 to '';

set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";

restore tablespace system, sysaux, undotbs, users;
recover database;
}

SQL> alter database open resetlogs;



Can explore more Crash recovery option at http://www.akadia.com/services/ora_crash_recovery.html

No comments:

Post a Comment