Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the method of restoring archived logs by ORACLE RMAN". In the daily operation, I believe that many people have doubts about the method of restoring archived logs by ORACLE RMAN. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what is the method of restoring archived logs by ORACLE RMAN?" Next, please follow the editor to study!

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. Start with 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 >}

Four: only recover the four archived log files from 5 to 8 in rac environment

RMAN > restore archivelog from logseq 5 until logseq 8 thread 1

Example:

RMAN > restore archivelog from time 'sysdate-0.2'

Launch restore on 04-March-14

Starting resync for all recovery directories

Complete all resync

Use channel ORA_DISK_1

The archive log of thread 1 sequence 28 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_28_9KC5CGNQ_.ARC

The archive log of thread 1 sequence 29 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_29_9KC5CGO6_.ARC

The archive log of thread 1 sequence 30 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_30_9KC5CGO6_.ARC

The archive log of thread 1 sequence 31 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_31_9KC5CGO6_.ARC

The archive log of thread 1 sequence 32 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_32_9KC5LBFN_.ARC\ log

The archive log of thread 1 sequence 33 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_33_9KC5LSR3_.ARC

The archive log of thread 1 sequence 34 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_34_9KC5MHQH_.ARC\ log

The archive log of thread 1 sequence 35 has been stored on disk as a file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_35_9KC5NHG2_.ARC

The archived log of thread 1 sequence 36 has been stored on disk as file D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ SZSM\ ARCHIVELOG\ 2014 03 O1_MF_1_36_9KC5NV65_.ARC\ log

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 2

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 3

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 4

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_29P2BD3I_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_29P2BD3I_1_1 tag = TAX_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 5

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2AP2BD3I_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2AP2BD3I_1_1 tag = TAX_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:03

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 6

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 7

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2BP2BD3M_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2BP2BD3M_1_1 tag = TAX_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 8

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 9

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 10

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2JP2BE66_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2JP2BE66_1_1 tag = TAX_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:04

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 11

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 12

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2KP2BE67_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_2KP2BE67_1_1 tag = TAX_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 13

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_32P2BF6K_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_32P2BF6K_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 14

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 15

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 16

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 17

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_33P2BF6K_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_33P2BF6K_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 18

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 19

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_34P2BF6L_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_34P2BF6L_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 20

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_36P2BGGI_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_36P2BGGI_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 21

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 22

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_37P2BGGI_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_37P2BGGI_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 23

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_38P2BGGJ_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_38P2BGGJ_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

Channel ORA_DISK_1: restore completed. Time: 00:00:01

Channel ORA_DISK_1: starting to restore archive logs to the default destination

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 24

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 25

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 26

Channel ORA_DISK_1: restoring archive logs

Archive log thread = 1 sequence = 27

Channel ORA_DISK_1: reading backup fragment D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_3JP2BIIJ_1_1

Channel ORA_DISK_1: segment handle = D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ ARC_SZSM_20140304_3JP2BIIJ_1_1 tag = SZSM_ARCHIVE_BACKUP

Channel ORA_DISK_1: backup fragment 1 restored

At this point, the study on "what is the method of ORACLE RMAN to restore archived logs" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.