Can I register a database say MYDB in datacenter1 with two different catalogs i.e., I have one rman catalog a datacenter1 location and another rman catalog in datacenter2 location. So, can I register MYDB to rman catalogs at datacenter1 and datacenter2. If, so how can we keep rman catalogs at datacenter1 and datacenter2 in sync. For MYDB rman backups I just want to use local rman catalog which is datacenter1. But I just want to keep a redundant copy of the rman catalog. Please let me know.
Seems like you could use Data Guard for the catalog and then you could avoid not "Register a database with two catalogs", and have a much easier setup to maintain.
Otherwise trying to keep track of everything would be a nightmare.
With Data Guard you would have instant DR for you Catalog database along with one set of information for each database at both locations.
Yes, that is fine but my manager has a different idea as he wanted to use the second catalog for performing DEV and QA incrimental backups and also sync PROD databases too in caase we failover or switch over prod database across datacenters. so just wanted to know even if it is possible to register a database with two different catalogs. Please let me know.
Yes, it is possible.
You could have more than one recovery catalog, they don't have to know about each other, only the databases registered with them.
I hope that manager knows that a recovery catalog does not care what type of database it stores backup information on. To the catalog its a name, an ID and a collection of backup information.
Maybe show the view RC_DATABASE and RC_CONTROLFILE_COPY from the catalog would help explain why one catalog is better.
Edited by: mseberg on Dec 13, 2012 1:29 PM
Thanks for the info that was very helpful. One last question is there any quick way to sync both catalogs because at a point in time we will be using just one catalog while performing RMAN backup. Please let me know.
What I would do if is use two different schemas. So catalog A would be one user and catalog B a different user.
To keep it simple I might only use
and then the same password. That way you could use Data Pump to sync them and scripts, logons etc would be a simple as possible.
So Data Pump the schema and replace as needed.
I have another doubt. If we register a database with two different catalogs does the controlfile of the database store information about both databases or Does even the controlfile store any information about which catalog it has been registered to?