Usage of Restore Archivelog

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.