9iR2 2 node RAC and a stand alone Physical Standby - Role Reversal
edited Jun 14, 2009 10:29PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi,
We have a 2 node 9.2.0.7 RAC system on Windows 2003 and we are in the process of creating a stand alone single instance physical standby database for DR purpose
#1. Assuming we have the above configuration in place and working as expected, we perform a graceful switch over from RAC database to the standby database at 10:00 AM on Monday
#2. At 10:05 AM, the stand alone physical standby assumed the role of primary database and the RAC databases becomes physical standby database
#3. At 10:30 AM, we want to perform the role reversal again (using graceful switch over) so that the stand alone database once again becomes the physical standby and the RAC system becomes the primary database
We have a 2 node 9.2.0.7 RAC system on Windows 2003 and we are in the process of creating a stand alone single instance physical standby database for DR purpose
#1. Assuming we have the above configuration in place and working as expected, we perform a graceful switch over from RAC database to the standby database at 10:00 AM on Monday
#2. At 10:05 AM, the stand alone physical standby assumed the role of primary database and the RAC databases becomes physical standby database
#3. At 10:30 AM, we want to perform the role reversal again (using graceful switch over) so that the stand alone database once again becomes the physical standby and the RAC system becomes the primary database
0