• Arun Kumar

RMAN Backup Compression Types

Oracle introduced RMAN backup compression from 10g version onward. From 11g version, Oracle introduced 4 different types of backup compression methods.



Compression types


Both Oracle 11g and 12c has below 4 types of compression types:

  • BASIC: Its the basic compression method which is default configured in rman parameters.

  • LOW: Lead compression method where DB performance and backup size hold good.

  • MEDIUM: Recommended method as its the best combination of DB performance and compression ratio.

  • HIGH: You get the highest backup compression but DB performance and backup will be very slow.

Note: except BASIC compression, you need an advance compression license to use LOW, MEDIUM and HIGH compression types.

Check compression type


Inside RMAN parameters, we have compression algorithm type which defines the type of compression method to be used. You can check it via below command


Note: default compression set to BASIC does not mean that every backup that you trigger will be compressed.
The backup compression algorithm will only be used when you use BACKUP AS COMPRESSED clause while taking the backups.

Change compression type


If you have the advance compression license, then you can always change to other types of compression methods available.


RMAN> CONFIGURE COMPRESSION ALGORITHMHIGH;
RMAN> backup as compressed backupset database plus archivelog;

You can always change compression algorithm to Low, Medium and High.


Testing backup compression


When you use backup compression, you must know what are the benefits of it and when to use the particular type of backup compression method.


In a test case, we tested backup compression on a small database and below are our findings:

Backup-compression
Note: the backup size and time might differ based on channels, server and other factors.

1,155 views

Recent Posts

See All

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au