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 fix Oracle SQL Developer connection issue "Got minus one from a read call"

Few Important steps of Oracle Database Clone

How to autopopulate user_guid in fnd_user table ( EBS Blank Page)