This discussion is archived
5 Replies Latest reply: Jan 30, 2013 6:47 PM by MKinnal RSS

RMAN Compression

MKinnal Newbie
Currently Being Moderated
Hi,

I have enabled the compression in RMAN settings find below, but backupsets are not getting comprressed.

setup:
DB: Enterprise Edition Release 11.2.0.3.0 - 64bit
OS: IBM AIX 6.1

RMAN settings.

RMAN> SHOW ALL;

RMAN configuration parameters for database with db_unique_name HARYSCB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/orahome/dbs/snapcf_haryscb.f'; # default

Please help me to get it done.

/Manjunath
  • 1. Re: RMAN Compression
    AmitGolia Newbie
    Currently Being Moderated
    Hello,

    Plese check below MOS doc.

    A Complete Understanding of RMAN Compression [ID 563427.1]

    Thanks,
    Amit Golia
  • 2. Re: RMAN Compression
    Niket Kumar Pro
    Currently Being Moderated
    check this and compare with your compression....
    http://blog.ronnyegner-consulting.de/2009/11/04/oracle-11g-release-2-rman-compression-comparison/
  • 3. Re: RMAN Compression
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

    1. There is seede RMAN forum site
    2. If you change below parameter than you start to advance compress which you need to pay extra license
    3. You need to change below parameter:
    CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
    4. Please review:
    http://blog.ronnyegner-consulting.de/2009/11/04/oracle-11g-release-2-rman-compression-comparison/

    Regard
    Helios
  • 4. Re: RMAN Compression
    MKinnal Newbie
    Currently Being Moderated
    Hi,
    I changed from BASIC to MEDIUM. but, still the beckupsets are not compressing.
    Kindly suggest.

    /Manjunath
  • 5. Re: RMAN Compression
    MKinnal Newbie
    Currently Being Moderated
    I have changed in backup script too like

    BACKUP
    $BACKUP_TYPE
    SKIP INACCESSIBLE
    TAG hot_db_bk_level0
    FILESPERSET 20
    # recommended format
    FORMAT 'bk_%s_%p_%t'
    AS COMPRESSED BACKUPSET DATABASE;

    and RMAN configuration is

    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

    now the backup sets compressing.

    Thanks all to responding my query.

    /Manjunath

    Edited by: MKinnal on Jan 31, 2013 8:16 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points