oracle rman备份慢,RMAN 备份很慢.有没有什么办法解决.

There are two backup servers for two oracle8i database servers. The oracle version is oracle8i Enterprise Edition Release 8.1.7.4.0

RMAN is using target database controlfile instead of recovery catalog. Both usually spend 4 hours doing 4 GB oracle8i online backup.

One is named baksrv2, the other is named baksrv4. Now there is something wrongs with the baksrv4.

It takes 10 hours to back up 4 GB data. I compare the baksrv2 log of the oracle online backup with the baksrv4's

I find there are following differences:

For baksrv4,

It takes about 90 second to complete backup set.

It takes about 90 second between "RMAN-08502" and "[Normal] From: starting backup".

For baksrv2,

It takes about 30 second to complete backup set.

It takes about 12 second between "RMAN-08502" and "[Normal] From: starting backup".

The detailed logs are shown in the following:

For baksrv4

---------------------------------clip------------------------------------

RMAN-08013: channel dev_0: piece 1 created

RMAN-08503: piece handle=bak_oracle_online<570370187:1>.dbf comment=API Version 2.0,MMS Version 65.4.10.176570370187:1>

RMAN-08525: backup set complete, elapsed time: 00:01:57

RMAN-08071: channel dev_0: deleting archivelog(s)

RMAN-08514: archivelog filename=/d/db01/app/oracle/admin/arc/arch1_54255.dbf recid=54239 stamp=570289124

RMAN-08009: channel dev_0: starting archivelog backupset

RMAN-08502: set_count=136514 set_stamp=570370304 creation_time=09/30/2005 [12:11:44]

RMAN-08014: channel dev_0: specifying archivelog(s) in backup set

RMAN-08504: input archivelog thread=1 sequence=54256 recid=54240 stamp=570290469

[Normal] From: OB2BAR@baksrv4.r04.test.com "test"  Time: 09/30/05 12:13:16

Starting OB2BAR Backup: 05 baksrv4:bak_oracle_online<570370304:1>.dbf // Oracle8570370304:1>

[Normal] From: OB2BAR@baksrv4.r04.test.com "test"  Time: 09/30/05 12:13:32

Completed OB2BAR Backup: 05 baksrv4:bak_oracle_online<570370304:1>.dbf // Oracle8570370304:1>

......

---------------------------------clip------------------------------------

For baksrv2

---------------------------------clip------------------------------------

RMAN-08013: channel dev_0: piece 1 created

RMAN-08503: piece handle=oracle_online_bak<570367381:1>.dbf comment=API Version 2.0,MMS Version 65.4.10.176570367381:1>

RMAN-08525: backup set complete, elapsed time: 00:00:36

RMAN-08071: channel dev_0: deleting archivelog(s)

RMAN-08514: archivelog filename=/d/db01/app/oracle/admin/arc/arch1_44414.dbf recid=44264 stamp=570355689

RMAN-08009: channel dev_0: starting archivelog backupset

RMAN-08502: set_count=108656 set_stamp=570367417 creation_time=09/30/2005 [11:23:37]

RMAN-08014: channel dev_0: specifying archivelog(s) in backup set

RMAN-08504: input archivelog thread=1 sequence=44415 recid=44265 stamp=570356688

[Normal] From: OB2BAR@baksrv2 "test"  Time: 09/30/05 11:23:52

Starting OB2BAR Backup: 05 baksrv2

5b24fae4cde99750994428c024162093.gifracle_online_bak<570367417:1>.dbf // Oracle8570367417:1>

[Normal] From: OB2BAR@baksrv2 "test"  Time: 09/30/05 11:24:09

Completed OB2BAR Backup: 05 baksrv2

5b24fae4cde99750994428c024162093.gifracle_online_bak<570367417:1>.dbf // Oracle8570367417:1>

......

---------------------------------clip------------------------------------

I'm looking for any suggestion to improve the performance of the baksrv4. Thank you in advance.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值