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
racle_online_bak<570367417:1>.dbf // Oracle8570367417:1>
[Normal] From: OB2BAR@baksrv2 "test" Time: 09/30/05 11:24:09
Completed OB2BAR Backup: 05 baksrv2
racle_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.