Snapshot Standby database reports ORA-16541 when converting back to Physical Standby (Doc ID 1969548.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

 When converting a Snapshot Standby database back to Physical Standby, the following errors are reported:
     ORA-16541: database is not enabled

 

Example:

DGMGRL>
Configuration - trazap_tasadg

 Protection Mode: MaxPerformance
 Databases:
   TRAZAP   - Primary database
   trazadg  - Physical standby database
   trazadgp - Snapshot standby database                          >> snapshot db

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS


DGMGRL> Converting database "trazadgp" to a Physical Standby database, please wait...
Operation requires shutdown of instance "TRAZADGP" on database "trazadgp"
Shutting down instance "TRAZADGP"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "TRAZADGP" on database "trazadgp"
Starting instance "TRAZADGP"...
ORACLE instance started.
Database mounted.
Continuing to convert database "trazadgp" ...
Error: ORA-16541: database is not enabled

Failed.
Failed to convert database "trazadgp"

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