共計 5578 個字符，預計需要花費 14 分鐘才能閱讀完成。
這篇文章主要介紹了 DG Broker 如何搭建，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓丸趣 TV 小編帶著大家一起了解一下。
DG Broker 搭建
1. 環境說明
databasesid db_name db_unique_namenet service nameprimary oggoggoggogg_pphysical standbydoggoggdoggdogg_s
2. 查看參數
—- 主庫
SYS@ogg show parameter broker
NAME TYPE VALUE
———————————— ———– ——————————
dg_broker_config_file1 string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/dr1ogg.dat
dg_broker_config_file2 string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/dr2ogg.dat
dg_broker_start boolean FALSE
—- 備庫
SYS@dogg show parameter broker
NAME TYPE VALUE
———————————— ———– ——————————
dg_broker_config_file1 string /u01/app/oracle/product/11.2.0 /db_1/dbs/dr1dogg.dat
dg_broker_config_file2 string /u01/app/oracle/product/11.2.0/db_1/dbs/dr2dogg.dat
dg_broker_start boolean FALSE
—— 修改 dg_broker_config_file 參數。這里就用默認的路徑，也可以自己指定。如果是在 RAC 環境中，這個把這個文件把到共享的存儲上面，如果有 ASM 可以放到 ASM 中。
3. 啟用 BROKER
—- 在兩個數據庫上面都執行：
alter system set dg_broker_start=true scope=both;
4. 登錄配置
— 在其中任意一臺做下面的操作就可以了，另它安裝了 client 的客戶端也是可以的
[oracle@ogg-80 ~]$ dgmgrl
（1）連接到當前的主數據庫
DGMGRL connect sys/oracle@ogg_p
DGMGRL help create —– 查看幫助
Creates a broker configuration
Syntax:
CREATE CONFIGURATION configuration name AS
PRIMARY DATABASE IS database name
CONNECT IDENTIFIER IS connect identifier
（2）創建一個配置文件 (ogg 是 db_unique_name，oggDG 是配置的名字 – 可以修改，ogg_p 是連接到 prod 數據庫的 tnsname）
create configuration oggDG as primary database is ogg connect identifier is ogg_p;
（3）啟用配置文件
DGMGRL enable configuration;
（4）增加備庫到配置文件中 (dogg 是備機的 db_unique_name，dogg_s 是連接到 sprod 數據庫的 tnsname）
DGMGRL add database dogg as connect identifier is dogg_s;
（5）啟用備庫
DGMGRL enable database dogg;
（6）查看配置文件
DGMGRL show configuration
Configuration – oggdg
Protection Mode: MaxPerformance
Databases:
ogg – Primary database
dogg – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
（7）查看主庫的配置消息
DGMGRL show database verbose ogg;
Database – ogg
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ogg
Properties:
DGConnectIdentifier = ogg_p
ObserverConnectIdentifier =
LogXptMode = ASYNC
DelayMins = 0
Binding = optional
MaxFailure = 0
MaxConnections = 1
ReopenSecs = 300
NetTimeout = 30
RedoCompression = DISABLE
LogShipping = ON
PreferredApplyInstance =
ApplyInstanceTimeout = 0
ApplyParallel = AUTO
StandbyFileManagement = auto
ArchiveLagTarget = 0
LogArchiveMaxProcesses = 4
LogArchiveMinSucceedDest = 1
DbFileNameConvert = /u01/app/oracle/oradata/dogg/, /u01/app/oracle/oradata/ogg/
LogFileNameConvert = /u01/app/oracle/oradata/dogg/, /u01/app/oracle/oradata/ogg/
FastStartFailoverTarget =
InconsistentProperties = (monitor)
InconsistentLogXptProps = (monitor)
SendQEntries = (monitor)
LogXptStatus = (monitor)
RecvQEntries = (monitor)
ApplyLagThreshold = 0
TransportLagThreshold = 0
TransportDisconnectedThreshold = 30
SidName = ogg
StaticConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ogg-80)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ogg_DGMGRL)(INSTANCE_NAME=ogg)(SERVER=DEDICATED)))
StandbyArchiveLocation = /u01/app/oracle/archive
AlternateLocation =
LogArchiveTrace = 0
LogArchiveFormat = %t_%s_%r.dbf
TopWaitEvents = (monitor)
Database Status:
SUCCESS
（8）查看備庫的配置消息
DGMGRL show database verbose dogg;
Database – dogg
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: ON
Instance(s):
dogg
Properties:
DGConnectIdentifier = dogg_s
ObserverConnectIdentifier =
LogXptMode = ASYNC
DelayMins = 0
Binding = OPTIONAL
MaxFailure = 0
MaxConnections = 1
ReopenSecs = 300
NetTimeout = 30
RedoCompression = DISABLE
LogShipping = ON
PreferredApplyInstance =
ApplyInstanceTimeout = 0
ApplyParallel = AUTO
StandbyFileManagement = auto
ArchiveLagTarget = 0
LogArchiveMaxProcesses = 4
LogArchiveMinSucceedDest = 1
DbFileNameConvert = /u01/app/oracle/oradata/ogg/, /u01/app/oracle/oradata/dogg/
LogFileNameConvert = /u01/app/oracle/oradata/ogg/, /u01/app/oracle/oradata/dogg/
FastStartFailoverTarget =
InconsistentProperties = (monitor)
InconsistentLogXptProps = (monitor)
SendQEntries = (monitor)
LogXptStatus = (monitor)
RecvQEntries = (monitor)
ApplyLagThreshold = 0
TransportLagThreshold = 0
TransportDisconnectedThreshold = 30
SidName = dogg
StaticConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=d-ogg)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dogg_DGMGRL)(INSTANCE_NAME=dogg)(SERVER=DEDICATED)))
StandbyArchiveLocation = /u01/app/oracle/archive
AlternateLocation =
LogArchiveTrace = 0
LogArchiveFormat = %t_%s_%r.dbf
TopWaitEvents = (monitor)
Database Status:
SUCCESS
（9）修改 StaticConnectIdentifier 參數，記得兩個數據庫都要修改。
DGMGRL edit database ogg set property StaticConnectIdentifier= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.80)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ogg)(SERVER=DEDICATED)))
DGMGRL edit database dogg set property StaticConnectIdentifier= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.90)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dogg)(SERVER=DEDICATED)))
（10）開始切換
DGMGRL switchover to dogg;
Performing switchover NOW, please wait…
Operation requires a connection to instance dogg on database dogg
Connecting to instance dogg …
Connected.
New primary database dogg is opening…
Operation requires startup of instance ogg on database ogg
Starting instance ogg …
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is dogg
（11）查看狀態
DGMGRL show configuration;
Configuration – oggdg
Protection Mode: MaxPerformance
Databases:
dogg – Primary database
ogg – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
（12）再次切換回去
DGMGRL switchover to ogg;
感謝你能夠認真閱讀完這篇文章，希望丸趣 TV 小編分享的“DG Broker 如何搭建”這篇文章對大家有幫助，同時也希望大家多多支持丸趣 TV，關注丸趣 TV 行業資訊頻道，更多相關知識等著你來學習!
