How to Compress RMAN Backupset

  • by
You can enable the compression feature of RMAN by the following 2 ways:

One time setting

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
...
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
...
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
...

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;

new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters are successfully stored

You don't have to add compressed syntax for each RMAN script like the statement introduced below.

Run-time setting

RMAN> backup as compressed backupset incremental level 0 database plus archivelog;
Note: The incremental level 1 backupset takes very little to no advantages of the compressed feature. But full backup (or level 0) can make 5:1 compression ratio in one of my databases.

Another topic related to compression is about backup encryption, I talked about it in this post: How to Backup and Restore Under Encryption and Compression

Leave a Reply

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