broker switchover from single ins to 2nodesRAC problem
hello,
i installed and configured 11Gr2 2 node rac primary. and single instance grid + single instance database 11gr2 standby side.
but there is a problem. primary database name is the same for all rac nodes of me (kkrac). there are 2 instances; kkrac1 and kkrac2.
when i tried to switchover to 'kkrac' back from standby side(kkguard).. broker is looking for dr1kkrac.dat and dr2kkrac.dat files. but they dont exist. and they are wrong file names. it should be instance names; like dr1kkrac1.dat dr2kkrac2.dat.
and so i copied and renamed .dat files from guard to primary nodes (node1, node2); but it didnt work:)
DRCX: DRC Unique ID mismatch...
question)
i want to swichover "from single instance" db TO "2 nodes RAC db" with broker;
if i use the same db name for rac nodes (kkrac), it fails because, brooker dr1kkrac.dat dr2kkrac.dat files dont exist.
how can i do it correctly?
best regards;
CREATE CONFIGURATION 'KKGUARDCONF' AS PRIMARY DATABASE IS 'kkrac' CONNECT IDENTIFIER IS 'kkrac';
ADD DATABASE 'kkguard' AS CONNECT IDENTIFIER IS 'kkguard';
DGMGRL> show configuration
Configuration - KKGUARDCONF
Protection Mode: MaxPerformance
Databases:
kkrac - Primary database
kkguard - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to 'kkguard'
Performing switchover NOW, please wait...
New primary database "kkguard" is opening...
Operation requires shutdown of instance "kkrac1" on database "kkrac"
Shutting down instance "kkrac1"...
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
shut down instance "kkrac1" of database "kkrac"
start up instance "kkrac1" of database "kkrac"
DGMGRL> show configuration
Error:
ORA-03114: not connected to ORACLE
Configuration details cannot be determined by DGMGRL
DGMGRL> connect /
Connected.
DGMGRL> show configuration
Configuration - KKGUARDCONF
Protection Mode: MaxPerformance
Databases:
kkguard - Primary database
kkrac - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Edited by: donniedarko on 23-Dec-2010 07:01