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

_____________________________________________________________________________________________________________________

A visitor from Quezon city viewed 'How to Force Oracle RMAN to Delete All Archive log' 44 mins ago
A visitor from Saint paul viewed 'How to Check What is Getting / Being Audited in Or' 1 hr 54 mins ago
A visitor from Boca raton viewed 'How to Check Active Transaction in Oracle Database' 2 hrs 21 mins ago
A visitor from Campbelltown viewed 'How to Get SQLPLUS Query Output to a Shell Script ' 2 hrs 33 mins ago
A visitor from Riviere du rempart viewed 'Data Pump Impdp TRANSFORM option SEGMENT_ATTRIBUTE' 2 hrs 59 mins ago

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-25 All Rights Reserved | Site Map | Contact | Disclaimer