zyclove201305 发表于 2015-3-30 13:39:55

rac archive log rman 备份 有点怪异 求解

OS:centos 6.2
DB:oracle 11.2.0.4
RAC：是
存储：ASM

  为了保存归档的日志的安全，我把归档放在 2 个地方，一份放在ASM中，另一份放在本地磁盘中。
  在用 RMAN 备份归档时，出现了一个怪异的问题，本应该同时备份ASM 和 本地磁盘的 归档，然后删除，但它一部份选 择 ASM ，一部份选择 本地磁盘。详情如下：

RMAN> run {
2> allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/#EDC4rfv@ytp2p1;
3> allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/#EDC4rfv@ytp2p2;
4> backup archivelog all delete all input;
5> release channel c1;
6> release channel c2;
7> }

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=1432 instance=ytp2p1 device type=DISK

allocated channel: c2
channel c2: SID=1428 instance=ytp2p2 device type=DISK

Starting backup at 30-MAR-15
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=2 sequence=19 RECID=53 STAMP=875703601
input archived log thread=1 sequence=34 RECID=51 STAMP=875703594
input archived log thread=1 sequence=35 RECID=55 STAMP=875711313

channel c1: starting piece 1 at 30-MAR-15
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=2 sequence=20 RECID=61 STAMP=875711899
channel c2: starting piece 1 at 30-MAR-15
channel c1: finished piece 1 at 30-MAR-15
piece handle=/home/oracle/orabak/databack/arc_20150330_13q34jcn_1_1.bak tag=TAG20150330T131814 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01

channel c1: deleting archived log(s)
archived log file name=+DATA/ytp2p/arch2/2_19_875408516.dbf RECID=53 STAMP=875703601
archived log file name=+DATA/ytp2p/arch1/1_34_875408516.dbf RECID=51 STAMP=875703594
archived log file name=+DATA/ytp2p/arch1/1_35_875408516.dbf RECID=55 STAMP=875711313

channel c1: starting archived log backup set

channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=36 RECID=58 STAMP=875711386
input archived log thread=1 sequence=37 RECID=60 STAMP=875711893

channel c1: starting piece 1 at 30-MAR-15
channel c2: finished piece 1 at 30-MAR-15
piece handle=/home/oracle/orabak/databack/arc_20150330_14q34jct_1_1.bak tag=TAG20150330T131814 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
channel c2: deleting archived log(s)
archived log file name=+DATA/ytp2p/arch2/2_20_875408516.dbf RECID=61 STAMP=875711899
channel c1: finished piece 1 at 30-MAR-15
piece handle=/home/oracle/orabak/databack/arc_20150330_15q34jco_1_1.bak tag=TAG20150330T131814 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01

channel c1: deleting archived log(s)
archived log file name=/u01/app/oracle/arch1/1_36_875408516.dbf RECID=58 STAMP=875711386
archived log file name=/u01/app/oracle/arch1/1_37_875408516.dbf RECID=60 STAMP=875711893

Finished backup at 30-MAR-15

released channel: c1

released channel: c2

Liu Maclean(刘相兵 发表于 2015-3-30 13:44:27

> allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/#EDC4rfv@ytp2p1;
3> allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/#EDC4rfv@ytp2p2;

由于你开了2个channel ,显然oracle "很聪明“  知道 同时用ASM和文件系统上的归档日志来最大化吞吐量

zyclove201305 发表于 2015-3-30 14:12:21

明白，谢了
页: [1]
查看完整版本: rac archive log rman 备份 有点怪异 求解