Hi
I configured data guard broker in one of my databases and I am practising switchover operations. Oracle db 11.2.0.4.0
Primary database 2-node RAC.
Standby database single instance.
So I logged in from primary database node1 (etmaster1) and performed switchover.
DGMGRL> switchover to etmaster_stdby
Performing switchover NOW, please wait...
Operation requires a connection to instance "etmaster_stdby" on database "etmaster_stdby"
Connecting to instance "etmaster_stdby"...
Connected.
New primary database "etmaster_stdby" is opening...
Operation requires startup of instance "etmaster2" on database "etmaster"
Starting instance "etmaster2"... <-- It won't start instance 1, why is that..?
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "etmaster_stdby"
So I have to start instance on node1 separately.
srvctl start instance -d etmaster -i etmaster1 -o MOUNT
Shouldn't both rac nodes start in mount state after switchover..?
Config is a s follows
DGMGRL> show configuration verbose;
Configuration - etmaster_etmaster_stdby_config
Protection Mode: MaxPerformance
Databases:
etmaster - Primary database
etmaster_stdby - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Everything should be configured correctly.
Also when I do switchover back from old standby database (new primary) to current standby database(old primary) then everything goes smoothly. I connect to standby database via dgmgrl and both RAC instances are mounted.
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> switchover to etmaster;
Performing switchover NOW, please wait...
Operation requires a connection to instance "etmaster2" on database "etmaster"
Connecting to instance "etmaster2"...
Connected.
New primary database "etmaster" is opening...
Operation requires startup of instance "etmaster_stdby" on database "etmaster_stdby"
Starting instance "etmaster_stdby"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "etmaster"
Regards
Raul