Database Backup and Recovery (MOSC)

MOSC Banner

Backups not being deleted in oracle database 12.1.0.2.0

Dear Experts,

Our backups are getting deleted and we really need your advice here.below are our L0 and L1 BACKUP scripts for your review.L0 runs every sunday and L1 runs every day.


L0

#### Rman backup ##

######CONFIGURE SNAPSHOT CONTROLFILE NAME TO '${BACKUPDIR}/snapcf_${ORACLE_SID}.f';####

##########################


exec >> ${LOGFILE} 2>&1

${ORACLE_HOME}/bin/rman target / nocatalog <<EOF!

configure retention policy to recovery window of 7 DAYS; # default 1

CONFIGURE BACKUP OPTIMIZATION OFF; # default OFF

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON; # default OFF

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

#CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center