1. Back up all archived log files
rman> Backup Archivelog all delete input;
Second: Various options for restore Archivelog
0. According to the RAC thread, restore Archivelog from Logseq 6160 thread 2;
1.restore Archivelog All restores all archived log files
rman> restore Archivelog all;
2. Recover only 5 to 8 of these four archived log files
rman> restore Archivelog from Logseq 5 untillogseq 8;
3. Restore from the 5th archive log
rman> restore Archivelog from LOGSEQ 5;
4. Recover archived logs within 7 days
rman> restore Archivelog from time ' sysdate-7 ';
5. Sequence between notation
rman> restore Archivelog sequence between 1 and3;
6. Which log file to restore to
rman> restore Archivelog until Logseq 3;
6. Start recovery from the fifth log
rman> Restore Archivelog low logseq 5;
7. Until the 5th log
rman> Restore Archivelog high logseq 5;
If you want to change the recovery to another path, use the following statement
Set Archivelog destination to ' d:\backup ';
Rman> Run
2> {Allocate channel CI type disk;
3> set Archivelog destination to ' d:\backup ';
4> restore Archivelog all;
5> release channel CI;
6>}
8. View the required backup sets based on time:
[Email Protected]/orabak>rman target/
Rman> list Backup of archivelog time between "to_date (' 2009-06-24 08:00:00 ', ' yyyy-mm-dd hh24:mi:ss ')" and "To_date (' 2009-06-24 13:00 ', ' yyyy-mm-dd hh24:mi:ss ');
Restore a specified time period
Rman> Run {
2> set Archivelog destination to '/orabak/testarch ';
3> SQL ' ALTER SESSION setnls_date_format= "Yyyy-mm-dd:hh24:mi:ss";
4> restore Archivelog time between ' 2009-06-2409:00:00 ' and ' 2009-06-24 12:10:00 ';
5>}
This article is from "Xu Sanjin those years of mixed it" blog, please be sure to keep this source http://xu3jin.blog.51cto.com/2261216/1828555
Usage of Restore Archivelog