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.
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.