Last updated on JULY 04, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 184.108.40.206 [Release 10.2 to 11.2]
Information in this document applies to any platform.
DGMGRL> connect sys/xxxxxx@cdev
[W000 06/17 11:47:41.26] Connecting to database using cdev.
[W000 06/17 11:47:41.33] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 06/17 11:47:41.34] Broker version is '220.127.116.11.0'
DGMGRL> show configuration
Configuration - PROD
Protection Mode: MaxAvailability
CDEVP - Primary database
CDEV2 - (*) Physical standby database
Fast-Start Failover: ENABLED
DGMGRL> switchover to 'CDEV2';
Performing switchover NOW, please wait...
New primary database "CDEV2" is opening...
Operation requires shutdown of instance "cdev" on database "CDEVP"
Shutting down instance "cdev"...
[W000 06/16 18:28:32.03] Connecting to database using (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=
ORACLE instance shut down.
Operation requires startup of instance "cdev" on database "CDEVP"
Starting instance "cdev"...
[W000 06/16 18:28:33.41] Connecting to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
start up and mount instance "cdev" of database "CDEVP"
Broker is unable to restart the New Standby DB after Switchover and is failing with the Error ORA-1031 even after starting the Broker using tns alias
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms