setup
during switchover it didn’t show any error
DGMGRL> switchover to 'TROY_DR'
Performing switchover NOW, please wait...
New primary database "TROY_DR" is opening...
Operation requires shutdown of instance "TROY1" on database "TROY"
Shutting down instance "TROY1"...
ORACLE instance shut down.
Operation requires startup of instance "TROY1" on database "TROY"
Starting instance "TROY1"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "TROY_DR"but when i checked configuration again it shows below error
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
TROY - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
when i checked new standby database i found that one instance on standby was not started
[oracle@ol6-112-rac2 trace]$ /u01/app/11.2.0.3/grid/bin/crsctl stat res -t
.............
ora.troy.db
1 ONLINE ONLINE ol6-112-rac1 Open,Readonly
2 OFFLINE OFFLINE Instance Shutdown
so started it manually
[oracle@ol6-112-rac2 trace]$ srvctl start instance -d troy -i TROY2
[oracle@ol6-112-rac2 trace]$ /u01/app/11.2.0.3/grid/bin/crsctl stat res -t
.......
ora.troy.db
1 ONLINE ONLINE ol6-112-rac1 Open,Readonly
2 ONLINE ONLINE ol6-112-rac2 Open,Readonlybut after that issue still persist
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
But atleast now i can see it is working from standby side
[oracle@ol6-112-rac1 trace]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@TROY
Connected.
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESSdrcSID.log shows
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration broker_config Warning ORA-16607
Primary Database TROY_DR Success ORA-00000
Physical Standby Database TROY Error ORA-16664
so stop and start standby database (mrp starts automatically)
[oracle@ol6-112-rac1 trace]$ srvctl stop database -d TROY -o immediate
[oracle@ol6-112-rac1 trace]$ srvctl start database -d TROY
[oracle@ol6-112-rac1 trace]$ ps -ef|grep mrp
oracle 31112 1 0 20:58 ? 00:00:00 ora_mrp0_TROY1
oracle 31188 19562 0 20:58 pts/0 00:00:00 grep mrp
now its working fine from both sides
[oracle@ol6-112-dr-rac1 admin]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@TROY_DR
Connected.
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
[oracle@ol6-112-rac1 trace]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@TROY
Connected.
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DBATracker 