Hi there,
After 3 times rebuilding my configuration, I bounce back to the same problem. I've read all threads on the subject but can't find a solution. If anyone has an idea :
I have 2 instances acting as primary presently : "ORCL1" (on server ServerS1) and "ORCL2" (on server ServerS2) on a RAC database "ORCLS" (cluster racS)
I have 2 instances acting as dataguard presently : "ORCL1" (on server ServerP1) and "ORCL2" (on server ServerP2) on a RAC database "ORCL" (cluster racP)
( a failover has occured recently, I just rebuilt dataguards, archivelog are applied normally )
Before attempting to build, I do the following :
DGMGRL> connect sys@ORCLS
DGMGRL> disable configuration
DGMGRL> remove configuration
sqlplus / as sysdba on ORCL1/ServerS1 > ALTER SYSTEM SET DG_BROKER_START=FALSE;
sqlplus / as sysdba on ORCL1/ServerP1 > ALTER SYSTEM SET DG_BROKER_START=FALSE;
asmcmd on ServerS1 > rm +DATA/ORCLS/DGCONFIG/dgb_config01.ora
asmcmd on ServerS1 > rm +RECOVERY/ORCLS/DGCONFIG/dgb_config02.ora
asmcmd on ServerP1 > rm +DATA/ORCL/DGCONFIG/dgb_config01.ora
asmcmd on ServerP1 > rm +RECOVERY/ORCL/DGCONFIG/dgb_config02.ora
Then, I try to rebuild my configuration :
sqlplus / as sysdba on ORCL1/ServerS1 > ALTER SYSTEM SET DG_BROKER_START=TRUE;
sqlplus / as sysdba on ORCL1/ServerS1 > show parameter broker
------------------------------------ ----------- ------------------------------
| dg_broker_config_file1 | string | +DATA/ORCLS/dgconfig/dgb_config01.ora |
| dg_broker_config_file2 | string | +RECOVERY/ORCLS/dgconfig/dgb_config02.ora |
| dg_broker_start | boolean | TRUE |
sqlplus / as sysdba on ORCL1/ServerP1 > ALTER SYSTEM SET DG_BROKER_START=TRUE;
sqlplus / as sysdba on ORCL1/ServerP1 > show parameter broker
------------------------------------ ----------- ------------------------------
| dg_broker_config_file1 | string | +DATA/ORCL/dgconfig/dgb_config01.ora | | |
| dg_broker_config_file2 | string | +RECOVERY/ORCL/dgconfig/dgb_config02.ora | | | |
| dg_broker_start | boolean | TRUE |
DGMGRL> connect sys@ORCLS
DGMGRL> create configuration 'DG_ORCL' as primary database is 'ORCLS' connect identifier is 'ORCLS';
Configuration "DG_ORCL" created with primary database "ORCLS"
DGMGRL> add database 'ORCL' as connect identifier is 'ORCL';
Database "ORCL" added
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - DG_ORCL
Protection Mode: MaxPerformance
Databases:
ORCLS - Primary database
ORCL - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-16610: command "ENABLE DATABASE ORCL" in progress
DGM-17017: unable to determine configuration status
Additionnaly, when I try to run :
DGMGRL> show database ORCL
Database - ORCL
Role: PHYSICAL STANDBY
Intended State: APPLY-ON <-- from this point, it goes extremely slow, and then ... :
Transport Lag: (unknown)
Apply Lag: (unknown)
Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
ORCL1
ORCL2
Database Status:
DGM-17016: failed to retrieve status for database "ORCL"
ORA-16532: Data Guard broker configuration does not exist
ORA-16625: cannot reach database "ORCL"
Precisions :
- all databases are using pfiles
- tnsping access ORCL databases easily from ServerS1 or ServerS2
- it was working properly before the failover, when databases had opposite roles !
I'm lost, if anyone can tell me where to drive my search, it would be very helpfull.
Best regards.
Eric