Fix RMAN-08138: WARNING: archived log not deleted - must create more backups

Error description: RMAN delete archivelog all command is failing with RMAN-08138 warning.

Solution Description:
The archive log files which you are trying to delete is still needed for recovery.
If your archivelog destination is getting filled quickly means you have to look for modifying the retention policy for the archivelog backups in regular intervals and delete the archive logs after the successful backup.

backup archivelog all not backed up;
CROSSCHECK BACKUP DEVICE TYPE DISK;
DELETE NOPROMPT ARCHIVELOG ALL;

Or

DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-14 All Rights Reserved | Site Map | Contact | Disclaimer | Google