Header Ads Widget

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

when i tried to delete archivelog older than 7 days. i faced below error. because i didnt took any backup of archive logs.  to avoid this type of such issue, it is better you take full backup.

RMAN> delete archivelog until time 'sysdate - 7';

archived log file name=/Archive/archive_log/1_2406_854400440.dbf thread=1 sequence=2406
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/Archive/archive_log/1_2407_854400440.dbf thread=1 sequence=2407
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/Archive/archive_log/1_2408_854400440.dbf thread=1 sequence=2408
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/Archive/archive_log/1_2409_854400440.dbf thread=1 sequence=2409
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/Archive/archive_log/1_2410_854400440.dbf thread=1 sequence=2410
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/Archive/archive_log/1_2411_854400440.dbf thread=1 sequence=2411
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/Archive/archive_log/1_2412_854400440.dbf thread=1 sequence=2412


Solution:

to resolve this issue, we have to force delete all archivelog using below command.


RMAN> delete noprompt force archivelog until time 'sysdate - 7';


all archivelog files older than 7 days get deleted.