Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to remove dg broker and create 2nd physical standby?

liaison1Jul 31 2012 — edited Aug 1 2012
We have a dg broker setup 2 years ago for our production DB for DG standby. But we never used it. It kept down since then. However, we still have the configuration in the database like this:

Primary:
log_archive_config string DG_CONFIG=(dxp1p, DXP1P_STD)
log_archive_dest_1 string location="/u04/dxp1p/archive", valid_for=(ONLINE_LOGFILE,ALL_ROLES)
log_archive_dest_2 string SERVICE=DXP1P_VA MAX_CONNECTIONS=3 REOPEN=60 db_unique_name=DXP1P_STD
dg_broker_config_file1 string /u01/dxp1p/data/dgconf1.dat
dg_broker_config_file2 string /oracle/product/10g/dbs/dr2dxp1p.dat
dg_broker_start boolean FALSE

1st Standby:
log_archive_config string DG_CONFIG=(dxp1p, DXP1P_STD)
log_archive_dest_1 string location="/u02/dxp1p/archive/" , valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=DXP1P_STD
dg_broker_config_file1 string /oracle/product/10g/dbs/dr1dxp1pdr.dat
dg_broker_config_file2 string /oracle/product/10g/dbs/dr2dxp1pdr.dat
dg_broker_start boolean FALSE


When I tried to logon to dgmgrl, got this message:
ORA-16525: the Data Guard broker is not yet available


I would like to remove the dg broker and let the current standby continuing running normal. Plus I would like to add another standby database to the primary at different location. I tried to change:

log_archive_config to 'read, receive, nodg_config'
log_archive_dest_2 to 'SERVICE=DXP1P_VA LGWR ASYNC=20480'

It seems breaking the archive send, and got the message from alter log:
=================================================
Errors in file /oracle/admin/dxp1p/bdump/dxp1p_lns1_29074.trc:
ORA-16057: DGID from server not in Data Guard configuration
LNS: Failed to archive log 4 thread 1 sequence 168101 (16057)
Mon Jul 30 17:47:27 2012
Errors in file /oracle/admin/dxp1p/bdump/dxp1p_arc0_5962.trc:
ORA-16057: DGID from server not in Data Guard configuration
Mon Jul 30 17:47:27 2012
FAL[server, ARC0]: Error 16057 creating remote archivelog file 'DXP1P_VA'
FAL[server, ARC0]: FAL archive failed, see trace file.
Mon Jul 30 17:47:27 2012
Errors in file /oracle/admin/dxp1p/bdump/dxp1p_arc0_5962.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Mon Jul 30 17:47:27 2012
ORACLE Instance dxp1p - Archival Error. Archiver continuing.
Mon Jul 30 17:47:57 2012
Thread 1 cannot allocate new log, sequence 168102
Private strand flush not complete
Current log# 4 seq# 168101 mem# 0: /u02/dxp1p/redolog/redo04a.log
Current log# 4 seq# 168101 mem# 1: /u03/dxp1p/redolog/redo04b.log
Beginning log switch checkpoint up to RBA [0x290a6.2.10], SCN: 12200747321258
Mon Jul 30 17:47:57 2012
Thread 1 advanced to log sequence 168102 (LGWR switch)
Current log# 5 seq# 168102 mem# 0: /u02/dxp1p/redolog/redo05a.log
Current log# 5 seq# 168102 mem# 1: /u03/dxp1p/redolog/redo05b.log
Mon Jul 30 17:47:58 2012
ARC1: Archivelog destination LOG_ARCHIVE_DEST_2 disabled: destination Data Guard configuration error
=================================================================

I changed back right away since this is critical production DB. Maybe it works, but I may not wait enough long time for the archive send resume? I will also need to create 2nd standby. My plan is to remove the dg broker, since this is not used for long time anyway. To add 2nd standby by changing the primary DB parameter log_archive_dest_3.

Please advice. Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2012
Added on Jul 31 2012
7 comments
1,142 views