RE: Rman Full Backup with DataDomain

  • From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
  • To: 'Martin Brown' <martinfbrown@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 25 Oct 2010 11:02:57 -0400

have you tried the noac option? That's what helped us.

Just as a sanity check - do you know if your nic are set up with full duplex 
and auto-negotiation on? That also was one thing that got us... turning 
auto-negotiation on on the nic...we found that we never had the full nic speed 
without that being turned on.

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106



________________________________
From: Martin Brown [mailto:martinfbrown@xxxxxxxxxxx]
Sent: Monday, October 25, 2010 10:48 AM
To: Amaral, Rui; oracle-l@xxxxxxxxxxxxx
Subject: RE: Rman Full Backup with DataDomain

mounted as so:

xx.xx.xx.x:/backup              /mnt/dd510      nfs     
nolock,hard,intr,nfsvers=3,tcp,rsize=32768,wsize=32768,bg       0 0


This was set up as per the DataDomain best practices also.

________________________________
From: Rui.Amaral@xxxxxxxxxxxxxxxx
To: martinfbrown@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Date: Mon, 25 Oct 2010 10:10:45 -0400
Subject: RE: Rman Full Backup with DataDomain

Hi Martin,

what's you nfs mount options? I had something similar and it was tied to that.

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106



________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Martin Brown
Sent: Monday, October 25, 2010 10:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Rman Full Backup with DataDomain

I have an interesting problem. I am running full backup cycles of the database 
twice a week and we have re-directed the backuppieces to a DataDomain device. 
THe problem is the performance has tanked. Normal backups to a NAS take 
approximately 5 hours. The *new and improved* DataDomain option takes just 
under 16 hours.

I have modified the rman script to conform to DataDomain's Best Practice docs 
(i.e...filesperset=1, uncompressed, yada...yada...) but I still am unable to 
achieve acceptable performance.

The database configuration follows Oracle's MAA whitepaper on High 
Availability. I use a local standby to run the full backup to offload the CPU 
and memory burden from the production environment. I run semi-annual tests on 
the backups to verify they are indeed good and I've never hade any issues. We 
run nightly incrementals on the primary using block change tracking and image 
copies of the datafiles. Again, never have had any issues.

Can anyone offer any suggestions?

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, go to www.td.com/legal for 
instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, allez 
au www.td.com/francais/avis_juridique pour des instructions.

Other related posts: