Error: ORA-16827: Dataguard-->Primary failed-->moved: Failover to Standby-->reinstated failed databa
edited Dec 25, 2012 9:04PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
the following is the current status
>>>>>>>>>>>>>>>DGMGRL> show configuration
>>>>>>>>>>>>>>>Configuration - db11g
>>>>>>>>>>>>>>> Protection Mode: MaxPerformance
>>>>>>>>>>>>>>> Databases:
>>>>>>>>>>>>>>> db11gsby - Primary database
>>>>>>>>>>>>>>> db11g - Physical standby database
Unfortunately my db11gsby database is stopped. so I started the database as follows.
>>>>>>>>>>>>>>>DGMGRL> switchover to db11g
>>>>>>>>>>>>>>>Performing switchover NOW, please wait...
>>>>>>>>>>>>>>>Error: ORA-01034: ORACLE not available
>>>>>>>>>>>>>>>Error: ORA-16625: cannot reach database "db11gsby"
>>>>>>>>>>>>>>>Failed.
>>>>>>>>>>>>>>>Unable to switchover, primary database is still "db11gsby"
so I connected using the db11g database.
>>>>>>>>>>>>>>>DGMGRL> connect sys/oracle@db11g
>>>>>>>>>>>>>>>Connected.
>>>>>>>>>>>>>>>DGMGRL> show configuration
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>Configuration - db11g
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Protection Mode: MaxPerformance
>>>>>>>>>>>>>>> Databases:
>>>>>>>>>>>>>>>DGMGRL> show configuration
>>>>>>>>>>>>>>>Configuration - db11g
>>>>>>>>>>>>>>> Protection Mode: MaxPerformance
>>>>>>>>>>>>>>> Databases:
>>>>>>>>>>>>>>> db11gsby - Primary database
>>>>>>>>>>>>>>> db11g - Physical standby database
Unfortunately my db11gsby database is stopped. so I started the database as follows.
>>>>>>>>>>>>>>>DGMGRL> switchover to db11g
>>>>>>>>>>>>>>>Performing switchover NOW, please wait...
>>>>>>>>>>>>>>>Error: ORA-01034: ORACLE not available
>>>>>>>>>>>>>>>Error: ORA-16625: cannot reach database "db11gsby"
>>>>>>>>>>>>>>>Failed.
>>>>>>>>>>>>>>>Unable to switchover, primary database is still "db11gsby"
so I connected using the db11g database.
>>>>>>>>>>>>>>>DGMGRL> connect sys/oracle@db11g
>>>>>>>>>>>>>>>Connected.
>>>>>>>>>>>>>>>DGMGRL> show configuration
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>Configuration - db11g
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Protection Mode: MaxPerformance
>>>>>>>>>>>>>>> Databases:
0