We are using rman for our hot backups .I need a particular archivelog which was backed up and deleted by rman 3 days back.
I want to restore only the archive logs only .
How Will I be able to do that
Printable View
We are using rman for our hot backups .I need a particular archivelog which was backed up and deleted by rman 3 days back.
I want to restore only the archive logs only .
How Will I be able to do that
Refere your alert_SID.log for the logseq for the start and end seq# to be retrived from the backup.Code:run {
allocate channel t1 type 'sbt_tape';
# Set the destination if you want it to be recovered into
# different location. By default it would be restored to
# the default location
set archivelog destination to '/disk1/oracle/temp_restore';
restore archivelog from logseq 1 until logseq 10;
release channel t1;
}
Sam
If I want to restore 59593 alone then is this format correct ..
run {
allocate channel t1 type 'sbt_tape';
set archivelog destination to '/disk1/oracle/temp_restore';
restore archivelog logseq 59593 ;
release channel t1;
}
I haven't tried this option nor could find a doc on this. So my suggestion would be to put a try. IF it works good. Other wise, just restore two log seq using from and until and then you can then copy or move the file that you want, to the appropriate place....
Sam
restore archivelog from logseq = 701 until logseq = 701;
I have tried this rman command before and it works, best of luck.
FDD
eh, after 6 years