Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RMAN question - deleting expired backups

Status
Not open for further replies.

TheKidd

IS-IT--Management
May 17, 2000
167
US
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.
 
Looks like changing the RMAN channel name from "channel 1" to channel may have done the trick. Here's the command:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 10 G;
It had been
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 10 G;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top