Once while configuring the dataguard broker, i faced the ORA-16625 and ORA-16501 . This error occurs beacuse the broker rejects an operation requested by the client when the database required to execute that operation was not reachable from the database where the request was made. If the request modifies the configuration, the request must be processed by the copy of the broker running on an instance of the primary database.
Few days ago i configured the standby database "RED" and broker, later drop it . Next time while configuring the data broker the error occurs as
DGMGRL> create configuration 'dgnoida'
> as primary database is 'noida'
> connect identifier is 'noida';
Error: ORA-16501: the Data Guard broker operation failed
Error: ORA-16625: cannot reach database "red"
Failed.
To solve this issue, I have remove the data guard broker configuration and then created the dataguard broker. The steps to drop the configuration are as follows :
Step 1 : Stop the standby data guard broker process
( On Standby )
SQL>show parameter dg_broker
NAME TYPE VALUE
------------------------ ----------- ----------------------------------------------
dg_broker_config_file1 string C:\APP\NEERAJS\PRODUCT\11.2.0\
DBHOME_1\DATABASE\DR1NOIDA.DAT
dg_broker_config_file2 string C:\APP\NEERAJS\PRODUCT\11.2.0\
DBHOME_1\DATABASE\DR2NOIDA.DAT
dg_broker_start boolean True
SQL> alter system set dg_broker_start=false;
System altered.
Step 2 : Diable the archive log state
(On Primary )
SQL> select dest_id,destination,status from v$archive_dest where target='STANDBY';
DEST_ID DESTINATION STATUS
-------- --------------- ----------
2 delhi VALID
SQL> alter system set log_archive_dest_state_2=defer ;
System altered.
SQL> select dest_id,destination,status from v$archive_dest where target='STANDBY';
DEST_ID DESTINATION STATUS
-------- --------------- ----------
2 delhi DEFERRED
Step 3 : On both system rename or drop the metadata files
SQL> show parameter dg_broker
NAME TYPE VALUE
------------------------ ----------- ----------------------------------------------
dg_broker_config_file1 string C:\APP\NEERAJS\PRODUCT\11.2.0\
DBHOME_1\DATABASE\DR1NOIDA.DAT
dg_broker_config_file2 string C:\APP\NEERAJS\PRODUCT\11.2.0\
DBHOME_1\DATABASE\DR2NOIDA.DAT
dg_broker_start boolean False
Delete or rename the file DR1NOIDA.DAT and DR@NOIDA.DAT .
Enjoy :-)
1 comment:
Time is gold. We should treasure every second of it so that in time we will not regret anything because we only live ones.I have read your article and i was glad and inspired. Thanks for it, Cheers!
Visit my site if you have time, Enjoy.
n8fan.net
www.n8fan.net
Post a Comment