Saturday, September 18, 2010

How to do RMAN DB restore?

rman target / nocatalog

set dbid <dbid>

run
{
 allocate channel d1 type 'sbt_tape';
 restore controlfile from autobackup;
}

startup nomount;

run
{
 allocate channel d1 type 'sbt_tape';
 restore controlfile from autobackup;
 alter database mount;
 restore database;
 recover database;
 release channel d1;
}

alter database open resetlogs;

exit;

No comments:

Post a Comment