Restore Archive log using RMAN
Restore archive log using seqeunce
run {
allocate channel demo_t1 type disk;
restore archivelog from sequence 35347 until sequence 35359;
}
Restore Archive log using time
run {
allocate channel icmt_t1 type disk;
restore archivelog
from time = "to_date('Apr 5 2005 19:20:00','Mon DD YYYY HH24:MI:SS')"
until time = "to_date('Apr 5 2005 20:00:00','Mon DD YYYY HH24:MI:SS')";
}
Restore Archive log using Sequence at alternate location
run {
allocate channel demo_t1 type disk;
set archivelog destination to '/oraarc01/oracle/arch/demo/' ;
restore archivelog from logseq=70241 until logseq=70250 ;
}
Restore Archive log using Sequence at alternate location
run {
allocate channel demo_t3 type disk;
set archivelog destination to '/opt/splexmv/tmparclog/' ;
restore archivelog sequence between 70276 and 70376 ;
}
Hope this help. Regards Rupam
