Usage of Restore Archivelog

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