We are aware of filesperset=1 being better but we opted for faster backups over
compression when we started using DD. We are planning to implement incremental
merge backups for oracle shortly which requires filesperset=1. Our first
backup using this configuration will be a little painful but incrementals
forever after that will greatly speed up our oracle backups.
Sent from my HTC on the Now Network from Sprint!
----- Reply message -----
From: "smpt" <smpt1 AT peppas DOT gr>
Date: Sun, Apr 24, 2011 02:36
Subject: [Veritas-bu] EMC Data Domain OST Vs VTL with NetBackup
To: "'Mark Glazerman'" <Mark.Glazerman AT spartech DOT com>, "VERITAS-BU AT
MAILMAN.ENG.AUBURN DOT EDU" <VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU>
Are you using fileperset=1 at rman script?
Netbackup by default is using fileperset=5 which is not good for deduplication
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Mark
Glazerman
Sent: Sunday, April 24, 2011 7:25 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: Re: [Veritas-bu] EMC Data Domain OST Vs VTL with NetBackup
Sandesh,
I took the following numbers off of our dd670 this evening. Oracle (10g) is
being backed up by RMAN using the oracle client for NBU 7.0. We backup all
filesystems (Data, db, arch and redo) into the same LSU. SQL2008 using the
native SQL backup feature and dumps straight to the data domain via CIFS.
In our Oracle LSU we're getting 14.8x with a retention of 7 days (compression
normally goes up the longer you keep the data). On SQL 2008 direct dumps we're
getting 32.6x with a retention of 1 month.
Someone else mentioned virtual environments. We use Hyper-V and get 25.8x with
a retention of 1 month.
Mark Glazerman
Desk: 314-889-8282
Cell: 618-520-3401
please don't print this e-mail unless you really need to
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of sandesh
Sent: Friday, April 22, 2011 3:10 PM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: [Veritas-bu] EMC Data Domain OST Vs VTL with NetBackup
Thanks rhugga
I also have a quick question to all experts on dedup ratio that you see on
database backup, for e.g. SQL, DB2 & Oracle.
What is the usual ratio you see with database backups using native application
backup utilites or using NetBackup Agents? Does it make any difference do it?
Suppose if DBA's generates 1TB of SQL native database backup flat files for a
given server and if I back up flat files using NetBakcup n keep it for 5 weeks
essentially backing up 30TB of data then how much compression one would see and
what factors does it depend on.?
Thanks.
+----------------------------------------------------------------------
|This was sent by sandesh.nbu AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|