博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle DG 之-- Remove DG Broker
阅读量:6281 次
发布时间:2019-06-22

本文共 2148 字,大约阅读时间需要 7 分钟。

PURPOSE

How to safely remove a Data Guard Broker configuration.
SCOPE & APPLICATION

This applies to all DBAs who wish to remove and deactive a
Data Guard Broker configuration.
Removing the Configuration

1) Remove the Data Guard Broker Configuration

a) Using the Commandline DGMGRL:

  • Connect to the Primary Database
    DGMGRL> connect sys/<Password>@<Primary Database>
  • Remove the Data Guard Broker Configuration
    DGMGRL> remove configuration;
    b) Using Data Guard Manager or Grid Control:
    Follow the Wizard as mentioned in the Chapter
    'Scenarios Using Oracle Enterprise Manager'
    of the Data Guard Broker Guide of each Database Version.
    2) On the primary database set dg_broker_start=false:
    SQL> show parameter dg_broker
    NAME TYPE VALUE

    dg_broker_config_file1 string ?/dbs/dr1@.dat

    dg_broker_config_file2 string ?/dbs/dr2@.dat
    dg_broker_start boolean TRUE
    SQL>
    SQL> alter system set dg_broker_start=false scope=both;
    System altered.
    SQL> show parameter dg_broker
    NAME TYPE VALUE


    dg_broker_config_file1 string ?/dbs/dr1@.dat
    dg_broker_config_file2 string ?/dbs/dr2@.dat
    dg_broker_start boolean FALSE
    SQL>
    3) On the primary disable any archive destinations that are archiving to the standby:
    SQL> select dest_id,destination,status
    2 from v$archive_dest
    3 where target='STANDBY';
    DEST_ID

    DESTINATION

    STATUS

    2

    (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=bjsrv)(PORT=1521)))(CONNECT_DATA=(SID=TestDB12)(ORACLE_HOME=/u01/app/oracle/11.2.0/dbhome_1)(SERVER=DEDICATED)))

    VALID
    SQL> alter system set log_archive_dest_state_2=defer scope=both;
    System altered.
    SQL>
    4) on the standby set the dg_broker_start parameter to false:
    SQL> show parameter dg_broker
    NAME TYPE VALUE


    dg_broker_config_file1 string ?/dbs/dr1@.dat
    dg_broker_config_file2 string ?/dbs/dr2@.dat
    dg_broker_start boolean TRUE
    SQL> alter system set dg_broker_start=false scope=both;
    System altered.
    SQL>
    5) On both system rename the metadata files (if they exist):
    oracle@bjsrv:/u03/oracle/9.2.0/dbs> mv dr1DG920.dat dr1bjdb.bak
    oracle@bjsrv:/u03/oracle/9.2.0/dbs> mv dr2DG920.dat dr2bjdb.back
    RELATED DOCUMENTS

    Oracle Data Guard Broker Guide

转自:

转载于:https://blog.51cto.com/lyzbg/2090691

你可能感兴趣的文章
密码协议(二)仲裁协议
查看>>
bitcoinj开发环境搭建
查看>>
MarkDown转Html在线转换(支持代码高亮,可复制到公众号、今日头条)
查看>>
程序员总数3W+,阿里巴巴首次公开2018代码数据报告
查看>>
mybatis.generator
查看>>
学习Python,你应该明确的学习方向以及开发工具的选择
查看>>
10.19 iptables规则备份和恢复 ,firewalld的9个zone,service的操作
查看>>
认识LINUX--安装centOS7虚拟机
查看>>
互联网分布式微服务云平台规划分析--系统管理平台
查看>>
[武汉峰会]IT人必看!2018年上半年云栖大会300份干货免费开放!— 武汉峰会
查看>>
设置虚拟机桥接模式以及解决桥接模式上不了网以及ping不通主机的问题
查看>>
基于CCI周期性区间交易策略
查看>>
Spring Cloud构建微服务架构:分布式配置中心
查看>>
Java开发中Session和Cookie都有哪些区别?
查看>>
003.聊聊系统设计:有状态、无状态
查看>>
对spring和springmvc的初步了解
查看>>
2019年BAT面试通关宝典:数据结构+JVM+并发编程+分布式...
查看>>
分享下我的VSCODE插件
查看>>
druid连接池
查看>>
android 禁用home键
查看>>