Backup Central

I've been using commvault deduplication for a few months now, but I'm usually baffled by it. I can't understand why some things just don't deduplicate well.

My current test is with a 600GB Oracle database. I did the initial backup 10 days ago. No backups since then. I run another full backup, and 350GB of it had to come over the Network. Does that seem like Oracle DB's (or DB's in general) are just not good candidates for using Deduplication?


Bill Willis
Backup Admin
(702) 364-3621
Microsoft: You have questions,
We have a dancing paper clip


************************************************************************
************************************************************************
The information in this electronic mail communication (e-mail) contains confidential information which is the property of the sender and may be protected by the attorney-client privilege and/or attorney work product doctrine. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized by the sender. If you are not the intended recipient, you are hereby notified that any disclosure, copying, or distribution of the contents of this e-mail transmission or the taking or omission of any action in reliance thereon or pursuant thereto, is prohibited, and may be unlawful. If you received this e-mail in error, please notify us immediately of your receipt of this message by e-mail and destroy this communication, any attachments, and all copies thereof.
Southwest Gas Corporation does not guarantee the privacy or security of information transmitted by facsimile (fax) or other unsecure electronic means (including email). By choosing to send or receive information, including confidential or personal identifying information, via fax or unencrypted e-mail, you consent to accept any associated risk.
Thank you for your cooperation.

************************************************************************
************************************************************************
__._,_.___
Reply to sender ([email]Bill.Willis < at > swgas.com?subject=Re%3A%20Deduplication[/email]) | Reply to group ([email]commvault < at > yahoogroups.com?subject=Re%3A%20Deduplication[/email]) | Reply via web post | Start a New Topic
Messages in this topic (2)
Recent Activity:

• New Members 5

Visit Your Group

Commvault Documentation here:
http://documentation.commvault.com/
Text-Only ([email]commvault-traditional < at > yahoogroups.com?subject=Change Delivery Format: Traditional[/email]), Daily Digest ([email]commvault-digest < at > yahoogroups.com?subject=Email Delivery: Digest[/email]) &bull; Unsubscribe ([email]commvault-unsubscribe < at > yahoogroups.com?subject=Unsubscribe[/email]) &bull; Terms of Use




.

[img]http://geo.yahoo.com/serv?s=97359714/grpId=7450851/grpspId=1707277520/msgId=5451/stime=1327510776/nc1=4507179/nc2=5741395/nc3=4025373[/img]
__,_._,___

Try turning off compression.

On Wed, Jan 25, 2012 at 8:59 AM, Bill Willis <bill.willis < at > swgas.com ([email]bill.willis < at > swgas.com[/email])> wrote:
 
I've been using commvault deduplication for a few months now, but I'm usually baffled by it.  I can't understand why some things just don't deduplicate well.
 
My current test is with a 600GB Oracle database.  I did the initial backup 10 days ago.  No backups since then.  I run another full backup, and 350GB of it had to come over the Network.  Does that seem like Oracle DB's (or DB's in general) are just not good candidates for using Deduplication?
 
 
Bill Willis
Backup Admin
[url=tel:%28702%29%20364-3621](702) 364-3621[/url]
Microsoft:  You have questions,
We have a dancing paper clip


************************************************************************
************************************************************************
The information in this electronic mail communication (e-mail) contains confidential information which is the property of the sender and may be protected by the attorney-client privilege and/or attorney work product doctrine. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized by the sender. If you are not the intended recipient, you are hereby notified that any disclosure, copying, or distribution of the contents of this e-mail transmission or the taking or omission of any action in reliance thereon or pursuant thereto, is prohibited, and may be unlawful. If you received this e-mail in error, please notify us immediately of your receipt of this message by e-mail and destroy this communication, any attachments, and all copies thereof.
Southwest Gas Corporation does not guarantee the privacy or security of information transmitted by facsimile (fax) or other unsecure electronic means (including email). By choosing to send or receive information, including confidential or personal identifying information, via fax or unencrypted e-mail, you consent to accept any associated risk.
Thank you for your cooperation.

************************************************************************
************************************************************************








--

Thank You,
 
Larry Gravatt
lgravatt < at > gmail.com ([email]lgravatt < at > gmail.com[/email])
(949)300-3585 - Mobile


 

 


__._,_.___
Reply to sender ([email]lgravatt < at > gmail.com?subject=Re%3A%20%5Bcommvault%5D%20Deduplication[/email]) | Reply to group ([email]commvault < at > yahoogroups.com?subject=Re%3A%20%5Bcommvault%5D%20Deduplication[/email]) | Reply via web post | Start a New Topic
Messages in this topic (3)
Recent Activity:

• New Members 5

Visit Your Group

Commvault Documentation here:
http://documentation.commvault.com/
Text-Only ([email]commvault-traditional < at > yahoogroups.com?subject=Change Delivery Format: Traditional[/email]), Daily Digest ([email]commvault-digest < at > yahoogroups.com?subject=Email Delivery: Digest[/email]) &bull; Unsubscribe ([email]commvault-unsubscribe < at > yahoogroups.com?subject=Unsubscribe[/email]) &bull; Terms of Use




.

[img]http://geo.yahoo.com/serv?s=97359714/grpId=7450851/grpspId=1707277520/msgId=5452/stime=1327522155/nc1=4507179/nc2=4025373/nc3=5898817[/img]
__,_._,___

Really depends on the database change rate. How many INSERT, UPDATEs and DELETEs are happening over time and what Oracle database blocks are being changed as a result. Oracle has the potential to allocate and update database blocks through out the database. It depends on the application 'signature' as to where blocks are being changed. Each database application is different.

REDO and Archived REDO logs by definition will not deduplicate. Oracle writes "change vectors" in REDO for committed transactions. Say a transaction changes an integer value from 6 to 99, following a commit the REDO log reflects this change, in the order that transactions that are committing. Best practice would be to define/use a storage policy that is not dedup'ed.


- Mark




On Jan 25, 2012, at 11:59 AM, Bill Willis wrote:

I've been using commvault deduplication for a few months now, but I'm usually baffled by it. I can't understand why some things just don't deduplicate well.

My current test is with a 600GB Oracle database. I did the initial backup 10 days ago. No backups since then. I run another full backup, and 350GB of it had to come over the Network. Does that seem like Oracle DB's (or DB's in general) are just not good candidates for using Deduplication?


Bill Willis
Backup Admin
(702) 364-3621
Microsoft: You have questions,
We have a dancing paper clip


************************************************************************
************************************************************************
The information in this electronic mail communication (e-mail) contains confidential information which is the property of the sender and may be protected by the attorney-client privilege and/or attorney work product doctrine. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized by the sender. If you are not the intended recipient, you are hereby notified that any disclosure, copying, or distribution of the contents of this e-mail transmission or the taking or omission of any action in reliance thereon or pursuant thereto, is prohibited, and may be unlawful. If you received this e-mail in error, please notify us immediately of your receipt of this message by e-mail and destroy this communication, any attachments, and all copies thereof.
Southwest Gas Corporation does not guarantee the privacy or security of information transmitted by facsimile (fax) or other unsecure electronic means (including email). By choosing to send or receive information, including confidential or personal identifying information, via fax or unencrypted e-mail, you consent to accept any associated risk.
Thank you for your cooperation.

************************************************************************
************************************************************************




Mark Riley
onefastskater < at > me.com ([email]onefastskater < at > me.com[/email])
oh: 678.701.3350
c: 678.234.9772







__._,_.___
Reply to sender ([email]onefastskater < at > me.com?subject=Re%3A%20%5Bcommvault%5D%20Deduplication[/email]) | Reply to group ([email]commvault < at > yahoogroups.com?subject=Re%3A%20%5Bcommvault%5D%20Deduplication[/email]) | Reply via web post | Start a New Topic
Messages in this topic (4)
Recent Activity:

• New Members 5

Visit Your Group

Commvault Documentation here:
http://documentation.commvault.com/
Text-Only ([email]commvault-traditional < at > yahoogroups.com?subject=Change Delivery Format: Traditional[/email]), Daily Digest ([email]commvault-digest < at > yahoogroups.com?subject=Email Delivery: Digest[/email]) &bull; Unsubscribe ([email]commvault-unsubscribe < at > yahoogroups.com?subject=Unsubscribe[/email]) &bull; Terms of Use




.

[img]http://geo.yahoo.com/serv?s=97359714/grpId=7450851/grpspId=1707277520/msgId=5453/stime=1327522833/nc1=4025373/nc2=5898816/nc3=4507179[/img]
__,_._,___