Forum Stats

  • 3,851,952 Users
  • 2,264,054 Discussions
  • 7,904,914 Comments

Discussions

Incremental RMAN backup and compression

user11188564
user11188564 Member Posts: 124
edited Nov 16, 2010 1:32PM in Advanced Compression
Does RMAN compress the data for the incremental Level 0 and Level 1 backups. More specifically - Can I use Advanced compression if olny use incremental backups ?
Ashwin19

Best Answer

  • mrmessin
    mrmessin Member Posts: 287
    Answer ✓
    Welcome.

    When In the forums try and respond to responses with Helpful and Correct this helps us and well as others that view the forums later when responses are maked as having value in relation to the the question.

Answers

  • mrmessin
    mrmessin Member Posts: 287
    No you can use advanced compress independant of you backup method. You can compress objects within the database and that has no dependancy or affect on you backup method.

    For advanced compression for the backup itself the new zlib compression is the compression type that requires the advanced compression license. This compression type can be used for full, incremental and archivelog backups.
  • user11188564
    user11188564 Member Posts: 124
    So , If I use the configure command to use ZLIB as the compression algorithm - is that the only thing that I need to do to use compression with the incremental backup - or is there some other option that has to be specifed in the policy.

    Thanks.
  • mrmessin
    mrmessin Member Posts: 287
    you would use the comfigure command to use zlib which is does not compress as well as bzip2 which does not require the advanced compression option, but zlib does not consume as much cpu as bzip2.

    now for the backup you have 2 options. you can configure backupsets to compress
    CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET ;
    or it using table
    CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COMPRESSED BACKUPSET ;

    Then do you backups as backup sets

    database
    backup as backupset incremental level 1 tag hot_1_${DTE} DATABASE NOT BACKED UP SINCE TIME 'SYSDATE - .6';

    archivelogs
    backup as compressed backupset format '${INST_LOWER}_Archive_%d_%s_%p_%t' archivelog all not backed up 1 times ;
    Ashwin19
  • mrmessin
    mrmessin Member Posts: 287
    Answer ✓
    Welcome.

    When In the forums try and respond to responses with Helpful and Correct this helps us and well as others that view the forums later when responses are maked as having value in relation to the the question.
This discussion has been closed.