Oracle Data Guard 11g - How to safely remove a Data Guard Broker configuration?


When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps…

You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration.

Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and installed Oracle Database 11g Release 2 (11.2.0.3).

DG – is my breoker-managed Data Guard configuration. admdb is primary database, stldb – is standby database.

DGMGRL> show configuration
Configuration - dg

  Protection Mode: MaxPerformance
  Databases:
    admdb - Primary database
    stldb - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

Archive log destinations like as

SQL> show parameter log_archive_dest_

NAME                 TYPE       VALUE
-------------------- ----------- -------------
log_archive_dest_1  string     location=USE_DB_RECOVERY_FILE_
                               DEST, valid_for=(ALL_LOGFILES,
                               ALL_ROLES)
...
log_archive_dest_2  string     service="stldb", LGWR ASYNC NO
                               AFFIRM delay=0 optional compre
                               ssion=disable max_failure=0 ma
                               x_connections=1 reopen=300 db_
                               unique_name="stldb" net_timeou
                               t=30, valid_for=(all_logfiles,
                               primary_role)
...


Safely remove data guard configuration steps :

1. Remove data guard configuration with Data Guard Manager Command Line - DGMGRL use remove configuration .

Connect to Primary database with DGMGRL with SYS user and use command

DGMGRL> remove configuration
Removed configuration

DGMGRL> show configuration 
ORA-16532: Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL

2. On the primary database set dg_broker_start parameter FALSE;

SQL> select name , value from v$parameter  
  2  where name like '%dg_broker%';

NAME                       VALUE
-----------------------------------------------------------------
dg_broker_start            TRUE

dg_broker_config_file1     /u01/app/oracle/product/11.2.0/dbhome/dbs/dr1admdb.dat

dg_broker_config_file2     /u01/app/oracle/product/11.2.0/dbhome/dbs/dr2admdb.dat

Connect to primary database with SQL*Plus and use command

SQL> alter system set dg_broker_start=FALSE;

System altered.

SQL> select name , value from v$parameter 
2 where name like '%dg_broker%';
NAME                       VALUE
-----------------------------------------------------------------
dg_broker_start          FALSE
dg_broker_config_file1  /u01/app/oracle/product/11.2.0/dbhome/dbs/dr1admdb.dat
dg_broker_config_file2  /u01/app/oracle/product/11.2.0/dbhome/dbs/dr2admdb.dat

3. When we are remove configuration on DGMGRL, then archive destination for service cleared automatically.

SQL> show parameter log_archive_dest

NAME                 TYPE       VALUE
-------------------- ----------- -------------
log_archive_dest_1  string     location=USE_DB_RECOVERY_FILE_
                               DEST, valid_for=(ALL_LOGFILES,
                               ALL_ROLES)
...
log_archive_dest_2  string     
...

4. On standby disable data guard broker

SQL>alter system set dg_broker_start=FALSE;

System altered.

SQL> select name , value from v$parameter 
   2  where name like '%dg_broker%';

NAME                       VALUE
-----------------------------------------------------------------
dg_broker_start            FALSE

dg_broker_config_file1     /u01/app/oracle/product/11.2.0/dbhome/dbs/dr1stbdb.dat
dg_broker_config_file2     /u01/app/oracle/product/11.2.0/dbhome/dbs/dr2stbdb.dat

5. On primary and standby database move broker configuration files.

[oracle@oel62-x64 dbs]$ ls -l dr*.dat
-rw-r----- 1 oracle oinstall 16384 Jul 16 18:00 dr1admdb.dat
-rw-r----- 1 oracle oinstall 16384 Jul 16 17:59 dr2admdb.dat

[oracle@oel62-x64 dbs]$ mv dr1admdb.dat dr1admdb.dat.bak
[oracle@oel62-x64 dbs]$ mv dr2admdb.dat dr2admdb.dat.bak

and

[oracle@oel62-x64-stb dbs]$ ls -l dr*.dat
-rw-r----- 1 oracle oinstall 16384 Jul 16 18:00 dr1stldb.dat
-rw-r----- 1 oracle oinstall 16384 Jul 16 17:59 dr2stldb.dat
[oracle@oel62-x64-stb dbs]$ mv dr1stldb.dat dr1stldb.dat.bak
[oracle@oel62-x64-stb dbs]$ mv dr2stldb.dat dr2stldb.dat.bak 

We are removed data guard configuration safely.

Note : After remove data guard configuration you can use old standby database(s) for developer test after switchover to primary and opened read/write mode.

Regards
Mahir M. Quluzade




Comments

  1. thanks for your details it's very useful and amazing.your article is very nice and excellentweb design company in velachery

    ReplyDelete
  2. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. south africa brokerage firms

    ReplyDelete
  3. thanks for your information really good and very nice web design company in velachery

    ReplyDelete
  4. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete
  5. Auto bitcoin bot Celeste Barber is an actor, standup comedian, and TV presenter known for her role in the famous Australian TV series, All Saints. She is estimated to be worth nearly half a billion dollars. There are rumours that Celeste Barber has invested in several bitcoin robots to grow her wealth.

    ReplyDelete
  6. The sector is big. According to CB Insights, there are "41 VC-backed fintech unicorns worth a mixed $154.1 B." One driving element is that lots of conventional financial institutions are supporters and also adopters of the technology, actively investing in, partnering or obtaining with fintech start-ups since it is simpler to offer digitally-minded customers what they want, while additionally relocating the industry onward and also staying pertinent. Bruc Bond endeavor to lead the financial sector with sustainability, customizable product offering, and open communication. At Bruc Bond we aim to make 21st century banking straightforward, simple, and transparent.

    ReplyDelete
  7. Individuals who have Marfan syndrome are advised to avoid Make contact with and aggressive sports and isometric exercise like excess Aortic valve-sparing surgery in Marfan syndrome. Dr. Eyal Nachum is a senior cardiologist working in Heart Transplantation Unit, Sheba Medical Center, Ramat Gan, Israel.

    ReplyDelete
  8. Every year, the Maryland Mortgage Broker Association gives out about a thousand licenses, and these licenses are issued on a first come, first serve basis. If you are curious to know more about mortgage broker, here you can get Maine Mortgage Rates about it.

    ReplyDelete

Post a Comment

Popular posts from this blog

Which device is mapped Oracle ASM disk?

OTN Article: Oracle Database 12c In-Memory (Part I, II - Spanish / Portuguese)

Oracle Database 18c - Install On-Premises for Linux