- 最后登录
- 2017-8-31
- 在线时间
- 22 小时
- 威望
- 0
- 金钱
- 138
- 注册时间
- 2014-2-8
- 阅读权限
- 10
- 帖子
- 34
- 精华
- 0
- 积分
- 0
- UID
- 1661
|
1#
发表于 2015-3-30 13:39:55
|
查看: 3175 |
回复: 2
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 |
|