Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

14

主题
1#
发表于 2015-3-30 13:39:55 | 查看: 3176| 回复: 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
3#
发表于 2015-3-30 14:12:21
明白,谢了

回复 只看该作者 道具 举报

2#
发表于 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和文件系统上的归档日志来最大化吞吐量

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 02:20 , Processed in 0.048761 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569