rman備份歸檔日志的方法

210次閱讀

共計 7378 個字符，預計需要花費 19 分鐘才能閱讀完成。

這篇文章主要介紹“rman 備份歸檔日志的方法”，在日常操作中，相信很多人在 rman 備份歸檔日志的方法問題上存在疑惑，丸趣 TV 小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”rman 備份歸檔日志的方法”的疑惑有所幫助！接下來，請跟著丸趣 TV 小編一起來學習吧！

數據庫的恢復需要利用數據庫的備份并使用歸檔日志去追回 scn 和在備份點以后點更改數據。如果歸檔日志發生丟失，數據庫可以恢復，但還是會發生備份點后的數據丟失的情況，所以備份歸檔日志也是很重要的。
展示歸檔
RMAN list archivelog all;
List of Archived Log Copies for database with db_unique_name TEST
=====================================================================

Key Thrd Seq S Low Time
——- —- ——- – ——————-
5 1 62 X 2017-07-23 22:09:22
Name: /home/oracle/1_62_947085344.dbf

6 1 63 X 2017-07-25 14:19:26
Name: /home/oracle/1_63_947085344.dbf
….

60 1 108 A 2017-07-29 17:27:50
Name: /home/oracle/1_108_947085344.dbf

61 1 109 A 2017-07-29 17:27:56
Name: /home/oracle/1_109_947085344.dbf

直接備份歸檔日志
RMAN backup archivelog all format /home/oracle/archbak/rman_arch_%T_%u

Starting backup at 2017-07-30 11:01:48
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=100 RECID=43 STAMP=950632615
input archived log thread=1 sequence=101 RECID=44 STAMP=950633981
input archived log thread=1 sequence=102 RECID=45 STAMP=950634100
input archived log thread=1 sequence=103 RECID=46 STAMP=950634284
input archived log thread=1 sequence=104 RECID=47 STAMP=950634446
input archived log thread=1 sequence=105 RECID=48 STAMP=950635334
input archived log thread=1 sequence=106 RECID=49 STAMP=950635622
input archived log thread=1 sequence=107 RECID=57 STAMP=950635670
input archived log thread=1 sequence=108 RECID=60 STAMP=950635676
input archived log thread=1 sequence=109 RECID=61 STAMP=950697941
input archived log thread=1 sequence=110 RECID=62 STAMP=950698908
channel ORA_DISK_1: starting piece 1 at 2017-07-30 11:01:48
channel ORA_DISK_1: finished piece 1 at 2017-07-30 11:01:49
piece handle=/home/oracle/archbak/rman_arch_20170730_0vsal0ss tag=TAG20170730T110148 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-07-30 11:01:49

指定 sequence
備份從 108 到最久的 seq 的歸檔
RMAN backup archivelog from sequence 108 format /home/oracle/archbak/rman_arch_seq5_%T_%u
Starting backup at 2017-07-30 11:04:38
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=108 RECID=60 STAMP=950635676
input archived log thread=1 sequence=109 RECID=61 STAMP=950697941
input archived log thread=1 sequence=110 RECID=62 STAMP=950698908
input archived log thread=1 sequence=111 RECID=63 STAMP=950699078
channel ORA_DISK_1: starting piece 1 at 2017-07-30 11:04:38
channel ORA_DISK_1: finished piece 1 at 2017-07-30 11:04:39
piece handle=/home/oracle/archbak/rman_arch_seq5_20170730_10sal126 tag=TAG20170730T110438 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-07-30 11:04:39
指定 time
如備份最近 3 天的歸檔
RMAN backup archivelog from time sysdate-3 format /home/oracle/archbak/rman_arch_seq5_%T_%u

Starting backup at 2017-07-30 11:08:45
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=100 RECID=43 STAMP=950632615
input archived log thread=1 sequence=101 RECID=44 STAMP=950633981
input archived log thread=1 sequence=102 RECID=45 STAMP=950634100
input archived log thread=1 sequence=103 RECID=46 STAMP=950634284
input archived log thread=1 sequence=104 RECID=47 STAMP=950634446
input archived log thread=1 sequence=105 RECID=48 STAMP=950635334
input archived log thread=1 sequence=106 RECID=49 STAMP=950635622
input archived log thread=1 sequence=107 RECID=57 STAMP=950635670
input archived log thread=1 sequence=108 RECID=60 STAMP=950635676
input archived log thread=1 sequence=109 RECID=61 STAMP=950697941
input archived log thread=1 sequence=110 RECID=62 STAMP=950698908
input archived log thread=1 sequence=111 RECID=63 STAMP=950699078
input archived log thread=1 sequence=112 RECID=64 STAMP=950699325
channel ORA_DISK_1: starting piece 1 at 2017-07-30 11:08:45
channel ORA_DISK_1: finished piece 1 at 2017-07-30 11:08:46
piece handle=/home/oracle/archbak/rman_arch_seq5_20170730_11sal19t tag=TAG20170730T110845 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-07-30 11:08:46

在備份數據庫的時候添加 plus archvielog 備份歸檔日志
RMAN @/home/oracle/backup_full_arch.sql

RMAN run{
2 allocate channel c1 type disk;
3 allocate channel c2 type disk;
4 backup database format /home/oracle/rman_full_%T_%u
5 plus archivelog format /home/oracle/rman_arch_%T_%u
6 release channel c1;
7 release channel c2;
8 }
released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=30 device type=DISK
allocated channel: c2
channel c2: SID=36 device type=DISK

Starting backup at 2017-07-30 11:30:50
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=100 RECID=43 STAMP=950632615
…
channel c2: starting piece 1 at 2017-07-30 11:31:08
including current control file in backup set
channel c1: starting piece 1 at 2017-07-30 11:31:09
channel c2: finished piece 1 at 2017-07-30 11:31:09
piece handle=/home/oracle/rman_full_20170730_18sal2js tag=TAG20170730T113053 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
channel c1: finished piece 1 at 2017-07-30 11:31:10
piece handle=/home/oracle/rman_full_20170730_17sal2js tag=TAG20170730T113053 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-07-30 11:31:10
Starting backup at 2017-07-30 11:31:10
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=114 RECID=66 STAMP=950700670
channel c1: starting piece 1 at 2017-07-30 11:31:10
channel c1: finished piece 1 at 2017-07-30 11:31:11
piece handle=/home/oracle/rman_arch_20170730_19sal2ju tag=TAG20170730T113110 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-07-30 11:31:11
released channel: c1
released channel: c2

RMAN **end-of-file**

恢復歸檔日志
set archivelog destination to‘/home/oracle/arch 指定恢復的目錄
restore archivelog all 恢復所有歸檔，跟 backup archivelog 類似，也可以指定 sequence，scn，time

RMAN @/home/oracle/restore_arch.sql

RMAN run{
2 set archivelog destination to /home/oracle/arch
3 restore archivelog all;
4 }
executing command: SET ARCHIVELOG DESTINATION
using target database control file instead of recovery catalog
Starting restore at 2017-07-30 11:24:43
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK
archived log for thread 1 with sequence 100 is already on disk as file /home/oracle/1_100_947085344.dbf
archived log for thread 1 with sequence 101 is already on disk as file /home/oracle/1_101_947085344.dbf
archived log for thread 1 with sequence 102 is already on disk as file /home/oracle/1_102_947085344.dbf
archived log for thread 1 with sequence 103 is already on disk as file /home/oracle/1_103_947085344.dbf
archived log for thread 1 with sequence 104 is already on disk as file /home/oracle/1_104_947085344.dbf
archived log for thread 1 with sequence 105 is already on disk as file /home/oracle/1_105_947085344.dbf
archived log for thread 1 with sequence 106 is already on disk as file /home/oracle/1_106_947085344.dbf
archived log for thread 1 with sequence 107 is already on disk as file /home/oracle/1_107_947085344.dbf
archived log for thread 1 with sequence 108 is already on disk as file /home/oracle/1_108_947085344.dbf
archived log for thread 1 with sequence 109 is already on disk as file /home/oracle/1_109_947085344.dbf
archived log for thread 1 with sequence 110 is already on disk as file /home/oracle/1_110_947085344.dbf
archived log for thread 1 with sequence 111 is already on disk as file /home/oracle/1_111_947085344.dbf
archived log for thread 1 with sequence 112 is already on disk as file /home/oracle/1_112_947085344.dbf