Hi MOSC,
Why is this parameter set to "OFF" as it's default settting ?
What is your advice for this settings value?
CONFIGURE BACKUP OPTIMIZATION OFF; # default
From what we understand, the parameter essentially ensures that some backup file targets can be skipped or omitted from the backup run in certain circumstances if an identical copy of the file has already been backed up.
We run typical backup strategy of level 1s weeknights and level 0 on a weekend night, sending to a Data Domain storage area.
Our code is the same for both sans the 1 or 0;
run {
ALLOCATE CHANNEL c1 TYPE DISK MAXOPENFILES=1;
ALLOCATE CHANNEL c2 TYPE DISK MAXOPENFILES=1;
ALLOCATE CHANNEL c3 TYPE DISK MAXOPENFILES=1;
ALLOCATE CHANNEL c4 TYPE DISK MAXOPENFILES=1;
crosscheck archivelog all;
crosscheck backup;
report obsolete;
delete noprompt obsolete device type 'DISK';
delete noprompt expired backup;
backup as backupset incremental level 1 database skip offline filesperset=1 format '/export/ralddom01/nfs01/oracle/PRD11G05/RMAN/DAILY/INCR_%d_%U_DB.bkp';
backup current controlfile format '/export/ralddom01/nfs01/oracle/PRD11G05/RMAN/CONTROL_FILE/PROD_%d_s%s_p%p_%T';
backup archivelog from time 'sysdate-1' format '/export/ralddom01/nfs01/oracle/PRD11G05/RMAN/DAILY/ARCH_%d_%U.bkp';
delete noprompt backup of archivelog until time = 'sysdate-15';
delete noprompt archivelog until time = 'sysdate-15';
delete noprompt expired archivelog all;
crosscheck archivelog all;
report obsolete;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit
Our "show all" rman output;
RMAN> show all;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name PRD11G05 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
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 CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' TRACE 1 PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oda_rman1,BACKUP_HOST=clinddom01-data.clinipace.net,ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1)';
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 '/u01/app/oracle/fast_recovery_area/datastore/PRD11G05/snapcf_PRD11G05.f';
Thank for your help.
Best Regards,
Donald