IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “RMAN-08138: WARNING: archived log not deleted – must create more backups ” error.
Details of error are as follows.
RMAN-08138: WARNING: archived log not deleted - must create more backupsCause: An archived log that should have been deleted was not as it it did not meet the user specified
archive log deletion policy of number of backups required before deleting the logs.
Action: This is an informational message. The archived log can be deleted after more backups are
created to satify archivelog deletion policy.
RMAN> delete archivelog from sequence 13086 until sequence 13088 thread 1 backed up 1 times to disk; RMAN-08138: WARNING: archived log not deleted - must create more backups RMAN-08515: archived log file name=+DATA/ARCHIVELOG/2020_04_29/thread_1_seq_13086.4370.963609939 thread=1 sequence=13086 RMAN-08138: WARNING: archived log not deleted - must create more backups RMAN-08515: archived log file name=+DATA/ARCHIVELOG/2020_04_29/thread_1_seq_13087.4374.963610313 thread=1 sequence=13087 RMAN-08138: WARNING: archived log not deleted - must create more backups RMAN-08515: archived log file name=++DATA/ARCHIVELOG/2020_04_29/thread_1_seq_13088.4378.963610679 thread=1 sequence=13088
This error is related with the backup archivelog keep parameter.
Because Archivelog backup script is as follows.
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 database plus archivelog TAG daily_level_1 keep until time 'sysdate+15';
If you want to delete the RMAN backups, you should use the RMAN change command to change or remove the ‘keep’ parameter in backup script.
For example, specify RMAN> CHANGE … NOKEEP to remove the KEEP attributes for a backup
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
