Compress full, incremental backup using rman

Basically Backup compression is the feature of Oracle Database which offer more benefit. We can take the oracle rman backup as normal or in compress mode. Restoration process of compressed backup will same as uncompressed backup.

Full compress RMAN Backup:- 

RUN

{

CROSSCHECK ARCHIVELOG ALL;

sql 'alter system archive log current';

BACKUP AS compressed backupset filesperset 8 DATABASE FORMAT '$destnation/DB_%d_%p_%T_%s.rbkp' TAG DAILY_HOT_BACKUP;

sql 'alter system archive log current';

BACKUP AS compressed backupset ARCHIVELOG ALL NOT BACKED UP 1 TIMES FORMAT '$destnation/ARCBAK_%d_%p_%T_%s.rbkp' TAG ARCHIVE_BKP;

BACKUP AS compressed backupset CURRENT CONTROLFILE FORMAT '$destnation/CNT_%d_%p_%T_%s.rbkp' TAG CONTROL_FILE;

}

INCREMENTAL LEVEL 0 BACKUP:-

RUN {

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0

DEVICE TYPE DISK

TAG = 'DAILY_INC_FULL' FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_DB_%u_%s_%p' database;

#*** DAILY CONTROLFILE BACKUP

BACKUP AS BACKUPSET DEVICE TYPE DISK TAG = 'DAILY_CONTROLFILE' FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_CTL_%u_%s_%p'

CURRENT CONTROLFILE;

#***** DAILY SPFILE BACKUP

BACKUP AS BACKUPSET DEVICE TYPE DISK TAG = 'DAILY SPFILE'

FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_SPFILE_%u_%s_%p'

SPFILE;

#*******ARCHIVELOG BACKUP****

sql 'alter system archive log current';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DEVICE TYPE DISK TAG = 'DAILY_INCR_CUM_ARCHIVEDLOG'

FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_ARC_%u_%s_%p'

ARCHIVELOG ALL;

#*****Remove backuped archivelog before 6 day's******#

DELETE ARCHIVELOG UNTIL TIME 'sysdate-6' BACKED UP 1 TIMES TO DEVICE TYPE DISK;

}

INCREMENTAL LEVEL 1 BACKUP:-

RUN {

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 DEVICE TYPE DISK TAG = 'DAILY_INC_L1_BACKUP' FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_DB_%u_%s_%p' database;

#*** DAILY CONTROLFILE BACKUP 

BACKUP AS BACKUPSET DEVICE TYPE DISK TAG = 'DAILY_CONTROLFILE' FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_CTL_%u_%s_%p' CURRENT CONTROLFILE;

#***** DAILY SPFILE BACKUP

BACKUP AS BACKUPSET DEVICE TYPE DISK TAG = 'DAILY SPFILE' FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_SPFILE_%u_%s_%p' SPFILE;

#*******ARCHIVELOG BACKUP****

sql 'alter system archive log current';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 

DEVICE TYPE DISK TAG = 'DAILY_INCR_L1_ARCHIVEDLOG' FORMAT '/venusBackup/RMAN_HOTBACKUP/PROD_DB/%d_ARC_%u_%s_%p' ARCHIVELOG ALL;

#*****Remove backuped archivelog before 6 day's******#

DELETE ARCHIVELOG UNTIL TIME 'sysdate-6' BACKED UP 1 TIMES TO DEVICE TYPE DISK;

}