I have several 11gR2 RAC databases that use one RMAN catalog. All other databases work correctly with rman catalog except one database that keeps writing backup metadata to controlfile. My RMAN setup for this database is exactly the same like the other ones. I have triple checked my RMAN connections to both database and catalog and they look just like other databases. My backup to this database always returns successfully without errors, but backup metadata doesn't save in catalog. I also created another catalog for just this database so I could test it out, but the result is still the same. Any ideas??
Edited by: feverlove on Jan 30, 2013 7:57 PM
Edited by: feverlove on Jan 30, 2013 8:05 PM
Edited by: feverlove on Jan 30, 2013 8:09 PM
The only possibility is that the RMAN script is not connecting to the Catalog.
Note that the controlfile will always be updated, even for databases where the RMAN Backup uses a Catalog.
Hemant K Chitale
Yes, I resync'ed catalog yesterday, but the result was the same. Today, I performed a backup using control file only, registered database again with catalog, resynced catalog and voila !! it works. Anyway, I am not sure what is going on here but it works now.
Thank you everyone for your suggestions and ideas.