Monday, April 11, 2011

Recover archive logs from RMAN backup

1. run {
allocate channel c1 device type disk;
restore archivelog sequence 1017;
restore archivelog sequence 1018;
restore archivelog sequence 1019;
}

OR

2. run {
         allocate channel c1 device type disk;
         # 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 'c:\syed\archlogs';
         restore archivelog from logseq 1017 until logseq 1019;
         release channel c1;
}