Step By Step How to Recreate Data guard Broker Configuration

 Parameters used

dg_broker_start

dg_broker_config_file1

dg_broker_config_file2


ALTER SYSTEM SET DG_BROKER_START=FALSE scope=both;


[ortnbtyi@shsebs121db01 dbs]$ rm -rf dr2TANSID_P1.dat dr1TANSID_P1.dat

[root@shsebs121db01 bin]# su - ororgrid

Last login: Sat Feb 18 07:44:16 IST 2023

[ororgrid@shsebs121db01 ~]$ asmcmd

ASMCMD> ls

ARCH/

CRS/

FRA/

REDO/

TNBSID_DATA1/



Type  Redund  Striped  Time  Sys  Name

                             Y    TANSID/

                             Y    TANSID_P1/

ASMCMD> cd TANSID_P1/


ASMCMD> pwd

+ARCH/TANSID_P1

ASMCMD> mkdir DGCONFIG

ASMCMD> cd DGCONFIG



ASMCMD> pwd

+ARCH/TANSID_P1/DGCONFIG

ASMCMD> exit

[ororgrid@shsebs121db01 ~]$ exit

logout

[root@shsebs121db01 bin]# su - ortnbtyi

Last login: Fri Feb 17 19:21:14 IST 2023 on pts/0

[ortnbtyi@shsebs121db01 ~]$ sqlplus "/as sysdba"


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 18 07:54:15 2023

Version 19.14.0.0.0


Copyright (c) 1982, 2021, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.14.0.0.0


SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='+ARCH/TANSID_P1/DGCONFIG/dr1TANSID_P1.dat' SCOPE=BOTH sid='*';


System altered.


SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2='+ARCH/TANSID_P1/DGCONFIG/dr2TANSID_P1.dat' SCOPE=BOTH sid='*';


System altered.


SQL> ALTER SYSTEM SET dg_broker_start=true scope=both sid='*';


System altered.


===================

Standby Side



[ortnbtyi@shsdbdr01 dbs]$ pwd

/tnbtyi/oracle/product/19.3.0/dbs

[ortnbtyi@shsdbdr01 dbs]$ exit

logout

You have new mail in /var/spool/mail/root

[root@shsdbdr01 ~]# su - ororgrid

Last login: Sat Feb 18 07:51:56 IST 2023

[ororgrid@shsdbdr01 ~]$ asmcmd

ASMCMD> ls

ARCH/

CRS/

DATA/

ASMCMD> cd ARCH/

ASMCMD> ls

TANSID_P2/

ASMCMD> cd TANSID_P2/

ASMCMD> ls

ARCHIVELOG/

ASMCMD> mkdir DGCONFIG

ASMCMD> cd DGCONFIG

ASMCMD> pwd

+ARCH/TANSID_P2/DGCONFIG


[ororgrid@shsdbdr01 ~]$ exit

logout

[root@shsdbdr01 ~]# su - ortnbtyi

Last login: Fri Feb 17 19:29:24 IST 2023 on pts/1

[ortnbtyi@shsdbdr01 ~]$ sqlplus "/as sysdba"


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 18 08:06:15 2023

Version 19.14.0.0.0


Copyright (c) 1982, 2021, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.14.0.0.0


SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='+ARCH/TANSID_P2/DGCONFIG/dr1tansid_p2.dat' SCOPE=BOTH sid='*';


System altered.


SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='+ARCH/TANSID_P2/DGCONFIG/dr2tansid_p2.dat' SCOPE=BOTH sid='*';


System altered.


SQL> ALTER SYSTEM SET dg_broker_start=true scope=both sid='*';


System altered.


Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

How to set up the Oracle Wallets in Oracle Database 19C

PRVG-11250 : The check "RPM Package Manager database" was not performed because

ORA-00257:archiver error, connect internal only until freed

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

How to write to a CSV file using Oracle SQL*Plus

Change Password in an Oracle Database