91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

DG broker的配置和使用

發布時間:2020-08-08 06:18:03 來源:ITPUB博客 閱讀:244 作者:wg0411 欄目:關系型數據庫
配置方法
1、主備都在靜態監聽里新增DG broker的配置
主庫為
(SID_DESC=
      (GLOBAL_DBNAME=PROD_DGMGRL)
      (ORACLE_HOME=/db/oracle/product/11.2.0/db_1/)
      (SID_NAME=PROD)
    )

備庫為
(SID_DESC=
      (GLOBAL_DBNAME=PROD_STD_DGMGRL)
      (ORACLE_HOME=/mnt/sdb1/u01/app/oracle/product/11.2.0.4/db)
      (SID_NAME=PROD_STD)
    )

2、主備都設置參數
SQL> alter system set dg_broker_start=true;


使用方法
主備都可以執行
dgmgrl
DGMGRL> connect sys/123456
DGMGRL> connect sys/123456@tnsname
DGMGRL> help

DGMGRL> help show
Displays information about a configuration, database, or instance
Syntax:
  SHOW CONFIGURATION [VERBOSE];
  SHOW DATABASE [VERBOSE] <database name> [<property name>];
  SHOW INSTANCE [VERBOSE] <instance name> [<property name>]
    [ON DATABASE <database name>];
  SHOW FAST_START FAILOVER;

DGMGRL> help create
Creates a broker configuration
Syntax:
  CREATE CONFIGURATION <configuration name> AS
    PRIMARY DATABASE IS <database name>
    CONNECT IDENTIFIER IS <connect identifier>;

DGMGRL> help add
Adds a standby database to the broker configuration
Syntax:
  ADD DATABASE <database name>
    [AS CONNECT IDENTIFIER IS <connect identifier>]
    [MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> help switchover
Switches roles between a primary and standby database
Syntax:
  SWITCHOVER TO <standby database name>;

以上database name其實為db_unique_name,connect identifier表示tnsname


DGMGRL> SHOW CONFIGURATION;
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL

DGMGRL> CREATE CONFIGURATION DG1 AS  PRIMARY DATABASE IS PROD2 CONNECT IDENTIFIER IS PROD2;
Configuration "dg1" created with primary database "prod2"

DGMGRL> ADD DATABASE PROD2_STD AS CONNECT IDENTIFIER IS PROD2_STD MAINTAINED AS PHYSICAL;
Database "prod2_std" added

DGMGRL> SHOW CONFIGURATION;
Configuration - dg1
  Protection Mode: MaxPerformance
  Databases:
    prod2     - Primary database
    prod2_std - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED

DGMGRL> enable CONFIGURATION;
Enabled.
一旦enable configuration,那么主庫的log_archive_dest_2就有值了




DGMGRL> show CONFIGURATION VERBOSE;
Configuration - dg1
  Protection Mode: MaxPerformance
  Databases:
    prod2     - Primary database
    prod2_std - Physical standby database
  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

鸡泽县| 南平市| 衡水市| 南康市| 怀来县| 合作市| 辽源市| 离岛区| 九江县| 云南省| 台北市| 阿克苏市| 张家港市| 梁平县| 中方县| 平昌县| 长宁县| 阿瓦提县| 岗巴县| 娱乐| 米林县| 巴东县| 宁德市| 龙游县| 商南县| 德庆县| 林甸县| 牙克石市| 莫力| 芦溪县| 郁南县| 丰原市| 政和县| 揭阳市| 富蕴县| 姜堰市| 沐川县| 辛集市| 漳州市| 祁东县| 城口县|