Dear Exports,
we take incremental level 0 backup every week on sunday.Below is the script we are using.we would like to know:
1)Based on what,the autobackup of controlfile gets deleted?
exec >> ${LOGFILE} 2>&1
${ORACLE_HOME}/bin/rman target / nocatalog <<EOF!
configure retention policy to redundancy 6; # default 1
CONFIGURE BACKUP OPTIMIZATION OFF; # default OFF
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default OFF
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${BACKUPDIR}/ora_cf%F'; # default '%F'
CONFIGURE DEVICE TYPE DISK PARALLELISM 4; # default 1
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '${BACKUPDIR}/ora_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATADG/PRODDB/CONTROLFILE/snapcf_PRODDB.f';
SHOW ALL;
sql "alter system archive log current";
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL=0 spfile format '${BACKUPDIR}/spfile_%d_%s_%T.bak' DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG;
crosscheck backup;
crosscheck archivelog all;
REPORT OBSOLETE;
DELETE FORCE NOPROMPT OBSOLETE;
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 3 TIMES to disk;
LIST BACKUP OF DATABASE;
LIST BACKUP OF ARCHIVELOG ALL;
LIST BACKUP;
EOF!