a collection of scripts to ease the day-to-day work of an Oracle DBA
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

7 lines
283 B

# $Id$
# This deletes expired backups (i.e. those where the files are not found
# during the last crosscheck) from the catalog/controlfile
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED COPY;
DELETE NOPROMPT EXPIRED DATAFILECOPY ALL;