RMAN Does Not Delete The Obsolete Archivelog Due To Incomplete Full Backup
(Doc ID 2448376.1)
Last updated on OCTOBER 29, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [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