如何激活 Oracle DataGuard Broker？

如果您之前没有安装过 Data Guard，您可以通过下面的链接安装它。

https://dbtut.com/index.php/2022/02/15/oracle-data-guard-installation/

1. 我们在主数据库和备用数据库中激活 DataGuard Broker。

SQL> ALTER SYSTEM SET dg_broker_start=true;

2、在主服务器上，我们如下连接DGMGRL，保存主数据库。

$ dgmgrl sys/<password>@testdb

DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected.

DGMGRL> CREATE CONFIGURATION dg_config AS PRIMARY DATABASE IS testdb CONNECT IDENTIFIER IS testdb;

Configuration "dg_config" created with primary database "testdb"

3.我们保存备用数据库。

DGMGRL> ADD DATABASE teststby AS CONNECT IDENTIFIER IS teststby MAINTAINED AS PHYSICAL;

Database "teststby" added

4. 新配置被激活。

DGMGRL> ENABLE CONFIGURATION;

Enabled.

5.我们检查配置如下。

DGMGRL> SHOW CONFIGURATION;

Configuration - dg_config

Protection Mode: MaxPerformance

  Databases:

    testdb   - Primary database

    teststby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

主要配置：

DGMGRL> SHOW DATABASE testdb;

Database - testdb

Role:            PRIMARY

  Intended State:  TRANSPORT-ON

  Instance(s):

    testdb

Database Status:

SUCCESS

待机配置：

DGMGRL> SHOW DATABASE teststby;

Database - teststby

Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds (computed 0 seconds ago)

  Apply Lag:       0 seconds (computed 0 seconds ago)

  Apply Rate:      0 Byte/s

  Real Time Query: OFF

  Instance(s):

    teststby

Database Status:

SUCCESS

原文标题：Active Oracle DataGuard Broker

原文作者：Melek Durdu

原文链接：https://dbtut.com/index.php/2022/10/13/active-oracle-dataguard-broker/