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.
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.
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.
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?