5 Replies Latest reply: Jan 30, 2013 8:47 PM by MKinnal RSS

    RMAN Compression

    MKinnal
      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
          Hello,

          Plese check below MOS doc.

          A Complete Understanding of RMAN Compression [ID 563427.1]

          Thanks,
          Amit Golia
          • 2. Re: RMAN Compression
            Niket Kumar
            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
              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
                Hi,
                I changed from BASIC to MEDIUM. but, still the beckupsets are not compressing.
                Kindly suggest.

                /Manjunath
                • 5. Re: RMAN Compression
                  MKinnal
                  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