RMAN Does Not Delete The Obsolete Archivelog Due To Incomplete Full Backup
(Doc ID 2448376.1)
Last updated on JULY 06, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
1. The database takes a daily full backup and archivelog backup. The retention policy is set to "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;"
2. It's observed that RMAN "delete noprompt obsolete;" would delete the database backup beyond the retention policy (older than 7 days). But NO archivelog was deleted.
3. From the RMAN debug trace of "report obsolete;", we can find that lbRlKeepSCN is set to 8 when the datafile 1 was created.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document