Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN does not delete obsolete Backups

AndrePBOct 30 2017 — edited Nov 8 2017

Hello,

every day we make a full backup, after that we crosscheck and than delete the obsolete backups. The RETENTION POLICY is set to REDUNDANCY=1.

Normally it works fine but when there is a change in database structure for example deleting a tablespace, the backup of that day stays and it doesnt become obsolete.

Now it is the 30th of October we deleted a Tablespace on 26th and the backup isnt marked as obsolete (report obsolete).

Running: report obsolete recovery window of 1 days: shows the backup from the 26th as obsolete.

report obsolete recovery window of 2 days does not show it.

Recovery Manager: Release 12.2.0.1.0

We are using controllfile and not the catalog.

Any hints or suggestions?

Thanks

André

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2017

Added on Oct 30 2017

#performance-availability, #recovery-manager-rman

30 comments

11,688 views