• 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> 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:


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

Recent Posts

See All

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

How to check database backups

Checking Database backups are one of the main focus areas of a DBA. Time to time, DBA needs to check database backup status and see if its completed, failed, running etc. Also, DBA must be able to get

Automate RMAN Backups using Shell Scripts

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

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis