troubleshooting Question

purging the rman catalog

Avatar of dedean01
dedean01Flag for United States of America asked on
Oracle Database
11 Comments1 Solution4433 ViewsLast Modified:
Oracle 9i,
When I view the rc_backup_piece table via SQLPLUS, my backupsets goes as far back as Jan 2002. My retention policy is set to 366 days. When I issue the delete obsolete command in Rman it works but does not remove the backups created in 2002- 2004.  I assume that the old backups are not known to Oracle Rman. Is there a way to cleanup the catalog by removing these backupset through SQLPLUS?  I thought maybe I can change the Status to "Delete" and then run the prgrmanc.sql script. (But which table would I change).
Also this catalog contains backupsets from 28 different instances/database.

Any thoughts???????????????
Technical Support Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros