Switchover with Broker fails with ORA-01081
Last updated on JANUARY 27, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 31-MAY-2013***
RAC primary 2 nodes: tz01ssys
RAC standby 2 nodes: tz01dsys
managed via broker
All works fine, apart from switchover with broker (dgmgrl) which fails with ORA-01081
Configuration - TZ01SYST_DRCONFIG
Protection Mode: MaxAvailability
tz01ssys - Primary database
tz01dsys - Physical standby database
Fast-Start Failover: DISABLED
DGMGRL> switchover to tz01dsys
Performing switchover NOW, please wait...
New primary database "tz01dsys" is opening...
Operation requires shutdown of instance "TZ01SSYS" on database "tz01ssys"
Shutting down instance "TZ01SSYS"...
ORACLE instance shut down.
Operation requires startup of instance "TZ01SSYS" on database "tz01ssys"
Starting instance "TZ01SSYS"...
ORA-01081: cannot start already-running ORACLE - shut it down first
Please complete the following steps to finish switchover:
start up and mount instance "TZ01SSYS" of database "tz01ssys"
The drc*.logs shows fallowing errors:
2011-09-16 09:29:51.206 SQL [ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN] Executed successfully
2011-09-16 09:29:51.206 RSM: clearing IncarnationTable internal property of site 0x01010000
2011-09-16 09:29:51.206 02001000 1623489973 DMON: Broker determines that instance restart is required: Operation = SWITCHOVER status = ORA-16570
2011-09-16 09:29:51.207 02001000 1623489973 Resource: tz01ssys (01011001) State: PHYSICAL-APPLY-ON
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
Fri Sep 16 09:30:00 2011
Performing implicit shutdown abort due to switchover to physical standby
Shutting down instance (abort)
License high water mark = 5
USER (ospid: 19273): terminating the instance
Instance terminated by USER, pid = 19273
Fri Sep 16 09:30:02 2011
Instance shutdown complete
ORA-1092 : opitsk aborting process
Fri Sep 16 09:31:23 2011
Starting ORACLE instance (normal)
STANDBY: drcTZ01DSYS.log/alert_TZ01DSYS.log -> no errors at all
Switchover never worked.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms