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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer