My Oracle Support Banner

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

Last updated on MARCH 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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 original role, both services worked again.

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

> srvctl status database -d <primary_db_name>
Instance <primary_db_name>1 is running on node <node one name>
Instance <primary_db_name>2 is running on node <node two name>
[oraogg@vaoedv01 ~]$ srvctl status service -d <primary_db_name>
Service DG_PRIMARY is not running.
Service <standby_db_name> is not running.


> srvctl start service -d <primary_db_name> -s <standby_db_name>
PRCD-1084 : Failed to start service <standby_db_name>
PRCR-1079 : Failed to start resource ora.<primary_db_name>.<standby_db_name>.svc
CRS-5017: The resource action "ora.<primary_db_name>.<standby_db_name>.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 "(:xxxx:)" in "/<path>/<agent>.log".

CRS-2674: Start of 'ora.<primary_db_name>.<standby_db_name>.svc' on '<node one name>' failed
CRS-5017: The resource action "ora.<primary_db_name>.<standby_db_name>.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 "(:xxxx:)" in "/<path>/<agent>.log".

CRS-2674: Start of 'ora.<primary_db_name>.<standby_db_name>.svc' on '<node two name>' failed
CRS-2632: There are no more servers to try to place resource 'ora.<primary_db_name>.<standby_db_name>.svc' on that would satisfy its placement policy

  

Changes

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

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.