6-11g Release 2 RMAN Backup Compression

Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data,Data Pump exports and RMAN backups as well.
The compression levels are BASIC, LOW, MEDIUM and HIGH and each affords a trade off related to backup througput and the degree of compression afforded.
To use this option, we can run the following RMAN commands
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
followed by ..
RMAN> CONFIGURE COMPRESSION ALGORITHM ĹHIGHĺ;
or
RMAN> CONFIGURE COMPRESSION ALGORITHM ĹMEDIUMĺ;
or
RMAN> CONFIGURE COMPRESSION ALGORITHM ĹLOWĺ;
or
RMAN> CONFIGURE COMPRESSION ALGORITHM ĹBASICĺ;
Tests carried out on a small 1.5 GB database returned compression ratios of about 4.7 at best case.
However, it should be noted that use of LOW, MEDIUM and HIGH requires the Advanced Compression license.
The backupset size and backup durations are shown below.
Compression Level ĹHIGHĺ
backupset size: 226.18M
time: 00:02:21
Compression Level ĹMediumĺ
backupset size: 293.80M
time: 00:00:30
Compression Level ĹLowĺ
backupset size: 352.59M
time: 00:00:20
Compression Level ĹBasicĺ
backupset size: 276.55M
time: 00:00:50
To summarise we can conclude:
LOW ľ corresponds to LZO (11gR2) ľ smallest compression ratio, fastest
MEDIUM ľ corresponds to ZLIB (11gR1) ľ good compression ratio, slower than LOW
HIGH ľ corresponds to unmodified BZIP2 (11gR2) ľ highest compression ratio, slowest
BASIC (which is free) ľ corresponds to BZIP2 (10g style compression) ľ compression ratio in the range of MEDIUM, but slower

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *