Shulou(Shulou.com)06/01 Report--

This article shows you how the syntax of RMAN backup and recovery archive log is. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

one。 Back up all archive log files

RMAN > backup archivelog all delete input

Two: various options for restore archivelog

1. Recover all archive log files

RMAN > restore archivelog all

two。 Restore only the four archive log files from 5 to 8

RMAN > restore archivelog from logseq 5 until logseq 8

3. Recovery starts from the fifth archive log

RMAN > restore archivelog from logseq 5

4. Restore archived logs within 7 days

RMAN > restore archivelog from time 'sysdate-7'

5. Sequence between writing method

RMAN > restore archivelog sequence between 1 and 3

6. Which log file to restore to?

RMAN > restore archivelog until logseq 3

7. Restore from the fifth log

RMAN > restore archivelog low logseq 5

8. To the fifth log.

RMAN > restore archivelog high logseq 5

Three: if you want to change and restore to another path, you can 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 >}

The above is what the syntax of RMAN backup and recovery archive logs is. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.