Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    May 2006
    Posts
    191
    Thanks
    3
    Thanked 6 Times in 5 Posts

    Default Oracle backups to Data Domain

    I am investigating some compression ratios on Data Domain and see some wide ranges in the reported data reduction. In looking over the Data Domain best practices guide for Oracle I see a reference to setting FILESPERSET to 1 in rman. I understand what this does, but does this have a substantial impact on compression? I would like to investigate this further, but to get some cooperation from our DBAs I will need to be able to make some statement of benefit for looking into this.

    Thanks,
    -Rowl

    Note: When I state compression I am saying this in Data Domain terms where this includes both deduplication and lz compression.

  2. #2
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    DataDomain deduplicates, then compresses that deduplicated data. That being said, logic would have it that it wouldn't make any difference how many files per set.

    I say that from research and talking with DD techs when I was giving DD a hard look, but I don't have DD in my environment.
    Last edited by GregE; 09-27-2011 at 10:25 AM.

  3. #3
    Member
    Join Date
    Dec 2007
    Location
    Germany
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    we have the same "issue" that our tsm server which stores oracle and sql backups has the lowest compression ratio compared to all others (ndmp,exchange,aix, etc). the recommendation from EMC is definitely to set filesperset to "1". but we have this since we implemented the DD and we cannot see any increase in the compression ratio.

  4. #4
    Member
    Join Date
    May 2006
    Posts
    191
    Thanks
    3
    Thanked 6 Times in 5 Posts

    Default

    There is a good document on best practices for Oracle backups to DD. Filesperset=1 and no rman compression are the big ones from what I have seen. Getting the DBAs to make the filesperset=1 and double check no compression in rman raised our compression from 2.4:1 up to 4.9:1 overall and they only changed a small number of backups over. If I use the filesys show compression <file> I see some files reporting well over 20:1 compression. It will take weeks to get our entire environment switched over but so far this looks promising.

Similar Threads

  1. Which compression to use for Data Domain?
    By rowl in forum Tape / Media Library
    Replies: 1
    Last Post: 05-21-2013, 01:59 PM
  2. Data Domain and TSM
    By mangle in forum TSM Server
    Replies: 13
    Last Post: 08-18-2010, 05:37 PM
  3. how to query backups from domain xyz taking longer than nn
    By dwcasey in forum Backup / Archive Discussion
    Replies: 6
    Last Post: 06-11-2010, 10:51 AM
  4. Rebinding Backups to a new Policy Domain
    By Trevoris in forum Backup / Archive Discussion
    Replies: 5
    Last Post: 11-18-2009, 10:03 PM
  5. Mounting Data Domain
    By mangle in forum Others
    Replies: 1
    Last Post: 05-30-2007, 05:38 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •