RMAN Does Not Delete The Obsolete Archivelog Due To Incomplete Full Backup
(Doc ID 2448376.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform.
Symptoms
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |