I have a question regarding RMAN on Oracle 9. I have a script in place that works fine on Oracle 10g, but not on 9i. The script is not deleting old backups, it's only deleting old control file backups. Here's a snippet of the script:
echo "Starting backup at ${HOY}" >> ${LOGf}
su - oracle -c "rman target / log=${LOGf}" <<EOF
startup force dba;
shutdown immediate;
startup mount;
crosscheck backupset;
delete noprompt expired backup;
delete noprompt obsolete;
backup incremental level=0 TAG = 'Weekly_Full' database;
list backup summary;
shutdown immediate;
exit
EOF
I have Retention set to 5 days and control_file_record_keep_time set to 7 days. Thanks in advance for the help.
echo "Starting backup at ${HOY}" >> ${LOGf}
su - oracle -c "rman target / log=${LOGf}" <<EOF
startup force dba;
shutdown immediate;
startup mount;
crosscheck backupset;
delete noprompt expired backup;
delete noprompt obsolete;
backup incremental level=0 TAG = 'Weekly_Full' database;
list backup summary;
shutdown immediate;
exit
EOF
I have Retention set to 5 days and control_file_record_keep_time set to 7 days. Thanks in advance for the help.