在Oracle 10g 中，傳輸日志到備用節點數據庫的進程為ARCH 和LGWR 。（在11g 中，LGWR 被LNS 替代，但10g 中是不是LGWR 我不確定！

1. 架構

在Oracle 10g 中，傳輸日志到備用節點數據庫的進程為ARCH 和LGWR 。（在11g 中，LGWR 被LNS 替代，但10g 中是不是LGWR 我不確定！）

在備用節點上通過參數log_archive_config 、fal_client 和fal_server 接收日志，并和主節點通訊，，標識該日志是否被應用。

Data Guard 采用最大可用模式，保證數據實時同步到最少一個節點上。因為我們選擇第一個備用節點作為數據實時同步點，同步進程采用LGWR 進程。

2. 配置

在一個主節點兩個備用節點的Data Guard 10g 的環境中，各個節點的初始化參數的主要配置項。

在主節點的初始化參數文件配置：

*.log_archive_config='dg_config=(codb,codg,codg2)'
*.log_archive_dest_1='location=/oradata/htcodb/archive_logs_codb'
*.log_archive_dest_2='service=codb_standby lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=codg'
*.log_archive_dest_3='service=codb_standby2 arch async affirm valid_for=(online_logfiles,primary_role) db_unique_name=codg2'
*.log_archive_dest_state_2='enable'
*.log_archive_dest_state_3='enable'

在備用節點一的初始化參數文件配置：

*.db_name='codb'
*.db_unique_name='codg'
*.fal_client='code_standby'
*.fal_server='codb_primary'
*.log_archive_config='dg_config=(codb,codg,codg2)'
*.log_archive_dest_1='location=/oradata/archivelog/ valid_for=(all_logfiles,all_roles) db_unique_name=codg'
*.log_archive_format='%t_%s_%r.dbf'

在備用節點二的初始化參數文件配置：

*.db_name='codb'
*.db_unique_name='codg2'
*.fal_client='codb_standby'
*.fal_server='codb_primary'
*.log_archive_config='dg_config=(codb,codg2)'
*.log_archive_dest_1='location=/u01/archivelog_standby/ valid_for=(all_logfiles,all_roles) db_unique_name=codg2'
*.log_archive_format='%t_%s_%r.dbf'

主節點和備用節點之間的通訊是通過Oracle Net 實現的。在參數fal_client 和fal_server 上就用到Oracle Net 中的配置信息。

在主節點的tnsnames.ora 文件中，關于DG 的配置項如下所示：

CODB_PRIMARY =
(DESCRIPTION =
( ADDRESS = (PROTOCOL = TCP)(HOST = codb1-vip.htsc.com.cn)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = codb2-vip.htsc.com.cn)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = codb)
)
)-

CODB_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.219)(PORT = 1521))
)
(CONNECT_DATA =
(SID = codb)
)
)

CODB_STANDBY2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.90)(PORT = 1521))
)
(CONNECT_DATA =
(SID = codb)
)
)

在備用節點一的tnsnames.ora 文件中，關于DG 的配置項如下所示：

CODB_PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = codb1-vip.htsc.com.cn)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = codb2-vip.htsc.com.cn)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = codb)
)
)

CODB_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.219)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = codb)
)
)

在備用節點二的tnsnames.ora 文件中，關于DG 的配置項如下所示：

CODB_PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = codb1-vip.htsc.com.cn)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = codb2-vip.htsc.com.cn)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = codb)
)
)

CODB_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.90)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = codb)
)
)

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com