Rman backup: compression

From Robs_Wiki
Revision as of 12:00, 28 January 2020 by Qadmin wiki (talk | contribs) (Created page with "__TOC__ == Introduction == There are 4 levels of compression for rman: BASIC, LOW, MEDIUM and HIGH. BASIC is free and the others require the "Advanced Compression" license. =...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

There are 4 levels of compression for rman: BASIC, LOW, MEDIUM and HIGH. BASIC is free and the others require the "Advanced Compression" license.

How to configure backup compression

You can find out the current setting with the statement below:

RMAN> show compression algorithm;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PRDDB are:
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

You can change this configuration as follows:

RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW';

old RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

new RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

new RMAN configuration parameters are successfully stored

How to perform a compressed backup

You use the same statement for any of the 4 backup settings. The statement simply applies the type of compression that is configured:

RMAN> backup as compressed backupset database plus archivelogs delete input;