Unable To Start Standby Service On The Standby Database After Data Guard Switchover (Doc ID 1907814.1)

Last updated on JULY 18, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Unable to start standby service on the standby database after Data Guard switchover

Configured primary service and standby service by following <<Note 1429223.1>> and <<Note 1129143.1>>. both worked fine.

But after switchover, primary service worked on the new primary database, but standby service couldn't be started on the new standby database. However, when I switched back to their orignial role, both services worked again.

We see the following errors when tring to start the read only service on the new standby after switchover:

[oraogg@vaoedv01 ~]$ srvctl status database -d DGPRIM
Instance DGPRIM1 is running on node vaoedv01
Instance DGPRIM2 is running on node vaoedv02
[oraogg@vaoedv01 ~]$ srvctl status service -d DGPRIM
Service DG_PRIMARY is not running.
Service DG_STANDBY is not running.
[oraogg@vaoedv01 ~]$

[oraogg@vaoedv01 ~]$ srvctl start service -d DGPRIM -s DG_STANDBY
PRCD-1084 : Failed to start service DG_STANDBY
PRCR-1079 : Failed to start resource ora.dgprim.dg_standby.svc
CRS-5017: The resource action "ora.dgprim.dg_standby.svc start" encountered the following error:
ORA-16000: database open for read-only access
ORA-06512: at "SYS.DBMS_SERVICE", line 433
ORA-06512: at "SYS.DBMS_SERVICE", line 304
ORA-06512: at line 1
. For details refer to "(:CLSN00107:)" in "/u01/app/12.1.0.1/grid/log/vaoedv01/agent/crsd/oraagent_oraogg/oraagent_oraogg.log".

CRS-2674: Start of 'ora.dgprim.dg_standby.svc' on 'vaoedv01' failed
CRS-5017: The resource action "ora.dgprim.dg_standby.svc start" encountered the following error:
ORA-16000: database open for read-only access
ORA-06512: at "SYS.DBMS_SERVICE", line 433
ORA-06512: at "SYS.DBMS_SERVICE", line 304
ORA-06512: at line 1
. For details refer to "(:CLSN00107:)" in "/u01/app/12.1.0.1/grid/log/vaoedv02/agent/crsd/oraagent_oraogg/oraagent_oraogg.log".

CRS-2674: Start of 'ora.dgprim.dg_standby.svc' on 'vaoedv02' failed
CRS-2632: There are no more servers to try to place resource 'ora.dgprim.dg_standby.svc' on that would satisfy its placement policy

  

This is also seen in the oraagent log:  /u01/app/12.1.0.1/grid/log/vaoedv01/agent/crsd/oraagent_oraogg/oraagent_oraogg.log

Changes

 Using 12.1.0.1.1 GI ORACLE_HOME to manage 11.2.0.4 databases.  No other changes.

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