My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.