Rman Compression ratio
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Rman Compression ratio

  1. #1
    Join Date
    Jan 2008
    Posts
    6

    Rman Compression ratio

    Hi Gurus,
    I am in the process of implementing backup startegy using rman.Does rman by default compress the backupsets ?if so what would be the compression ratio?if i compress with "backup as compressed backupset" it would be CPU instensive by what means?does this do addition compression on the already compressed backupset which rman does ?Please your Repps will be invaluable.

    Regards

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    might help if you put your version on

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    No RMAN by default doesnt compress backup sets you need to tell it explicitly using the
    Code:
    configure command or using backup up as compressed
    Compression ratio varies you need to test it in your specific case
    (in my case the compression was 63% to 80% of the original size in some cases but without parallelism ) (it was also 5 times slower in 10gr2 hehe)

    Compression would be CPU intensive because the compression algorithm would come into play and has to execute it to make your backups smaller

    It would not do additional compression .

    RMAN in 11i i have heard is better when it comes to compression .

    regards
    Hrishy

Posting Permissions

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


Click Here to Expand Forum to Full Width