Showing posts with label RMAN archival restore. Show all posts
Showing posts with label RMAN archival restore. Show all posts

Saturday, September 18, 2010

How to do RMAN archival restore?

run{
 allocate channel d1 type 'sbt_tape';
 restore archivelog from logseq=13469 until logseq=13479;
 release channel d1;
}
OR

run{
 allocate channel d1 type 'sbt_tape';
 restore archivelog until time "sysdate - 1";
 release channel d1;
}