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

RMAN> delete archivelog all;

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

archived log file name=/holding/testdb2/archive_logs/1_691_941163822.dbf thread=1 sequence=691

.

.

.

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

archived log file name=/holding/testdb2/archive_logs/1_694_941163822.dbf thread=1 sequence=694

 

Solution:

Archive log deletion failing because archive log deletion policy set must be backed up 1 times and there was no backup performed. To delete archive log without backup I have change the deletion policy.

RMAN> show ARCHIVELOG DELETION POLICY;

 

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name TESTDB2 are:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;

 

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;

new RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

new RMAN configuration parameters are successfully stored

 

RMAN> delete archivelog all;

Comments