ORA-16541: database is not enabled
DGMGRL> disable configuration;
Disabled.
DGMGRL> enable configuration;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
DGMGRL> remove configuration;
Error: ORA-16541: database is not enabled
Failed.
DGMGRL> show configuration;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
The configuration was already broken and therefore you need to recreate the configuration
Solution:-
Remove the configuration from partner database eg if remove configuration is failing from primary try remove configuration from standby
DGMGRL> remove configuration
Removed configuration
If you try to create the configuration from standby you will encounter below error therefore please always create the configuration from current primary
DGMGRL> CREATE CONFIGURATION 'ANDY_conf' AS PRIMARY DATABASE IS 'ANDYS1' CONNECT IDENTIFIER IS 'ANDYS1.oracle.com';
Error: ORA-16584: operation cannot be performed on a standby database
DGMGRL> CREATE CONFIGURATION 'ANDY_conf' AS PRIMARY DATABASE IS 'ANDYS1' CONNECT IDENTIFIER IS 'ANDYS1.oracle.com';
Configuration "ANDY_conf" created with primary database "ANDYS1"
DGMGRL>
DGMGRL> ENABLE CONFIGURATION;
Enabled.
DGMGRL> ADD DATABASE ANDYP AS CONNECT IDENTIFIER IS 'ANDYP.oracle.com' MAINTAINED AS PHYSICAL;
Database "ANDYP" added
DGMGRL> show configuration;
Configuration - ANDY_conf
Protection Mode: MaxAvailability
Databases:
ANDYS1 - Primary database
ANDYP - Physical standby database (disabled)
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> ENABLE DATABASE ANDYP
Enabled.
DGMGRL> show configuration;
Configuration - ANDY_conf
Protection Mode: MaxAvailability
Databases:
ANDYS1 - Primary database
ANDYP - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
No comments:
Post a Comment