Switchover with Broker fails with ORA-01081 (Doc ID 1367263.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 31-MAY-2013***

Symptoms

Environment:
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

DGMGRL> show configuration

Configuration - TZ01SYST_DRCONFIG

Protection Mode: MaxAvailability
Databases:
tz01ssys - Primary database
tz01dsys - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

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"

DGMGRL> exit


The drc*.logs shows fallowing errors:

Primary:

drcTZ01SSYS.log

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

-> ORA-16570

alert_TZ01SSYS.log

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


Changes

Switchover never worked.

Cause

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