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

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 backups
Cause: 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/

 

 472 views last month,  10 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply