1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Oracle backups to Data Domain

Discussion in 'EMC Data Domain' started by rowl, Sep 16, 2011.

  1. rowl

    rowl Member

    Joined:
    May 18, 2006
    Messages:
    207
    Likes Received:
    8
    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.  
  3. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    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: Sep 27, 2011
  4. johansen

    johansen New Member

    Joined:
    Dec 13, 2007
    Messages:
    123
    Likes Received:
    2
    Location:
    Germany
    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.
     
  5. rowl

    rowl Member

    Joined:
    May 18, 2006
    Messages:
    207
    Likes Received:
    8
    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.
     

Share This Page