Archivelog all delete input doesn't delete what we hope for !
510685Nov 20 2009 — edited Nov 24 2009Hi,
I'm seeing a strange behaviour with RMAN on a 10.2.0.4 DB . The archive log files are not getting deleted with DELETE INPUT command, given along with the backup scripts ! I have to manually login once every month (when DISK space alarms), perform research to find out the recent logs that are enough for recovery & delete the rest :-( . Today, I find August, 2009 logs lying in the ARCH destination & have to manually delete them. Here are some parameters & script excerpts that a researcher might be interested in :
1) RMAN retention policy is set to recovery window of 5 days
2) RMAN is run locally, using the controlfile as catalog.
3) The backups go to locally mounted disk.
4) The backup script's main portion contains
"backup as compressed backupset
filesperset 10
format '${DIRECTORY}/arc_%d_%T_%U_arc_%s'
(archivelog all delete all input);
delete noprompt backup of archivelog until time 'sysdate-7';
"
5) I suppose the above should remove the archivelogs from their ARCH location that have been backed up , then older backups of archive logs too.
6) The directory for ARCH location from "archive log list", is /archive . The dir. for RMAN backup destination is /dbbackup2
7) Although I know the difference in recovery win. of 5 days & deletion of arch-backups older than 7 days, yet the residual 2-day logs must get deleted eventually on the 7th day.
8) The DB has a remote standby also.
Would someone be able to throw some light on this & help me if there's something wrong happening here ?
Edited by: user507682 on Nov 20, 2009 12:41 PM
Edited by: user507682 on Nov 20, 2009 12:42 PM
Edited by: user507682 on Nov 20, 2009 12:52 PM
Edited by: user507682 on Nov 20, 2009 4:02 PM