Data Guard - Keeping same SID/Instance Name across both sites
Hello,
We are working on a project to move the databases from legacy to new servers. The migration plan is to use Data Guard option for our migration strategy. We would like to know followings.
1) Is it possible to build stand by databases with same instance name of legacy primary instances? If so, how it could be?
2) If not, we can build stand by database with different instance name (DB_UNIQUE_NAME). Do the switch over and cut off the replication with legacy primary database. Once done, What other alternative do we have to change the instance name same like legacy database instances?
The ultimate goal is to retain same DB name and instance name in new server with minimum downtime.
Database - 11.2.0.3.0
Database Type - Oracle restart and RAC
O.S. - RHEL 6.3
The requirement is have same DB name and instance name across sites.
Primary site - X node
Primary DB - EODSS
Primary DB instances - EODSS1, EODSS1
Standby Site - Y node
StandBy DB - EODS
StandBy instances - EODSS1, EODSS1
Thanks,
Pankaj
Edited by: user12025125 on Feb 22, 2013 12:33 PM