oracle-11g-Dataguard详细配置手册.docx

《oracle-11g-Dataguard详细配置手册.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle11GDataguard详细配置手册版本：V1作者：知行合一一、环境描述：主库：IP地址：192.168.1.37OS：RHEL6.5X64Hostname:lin-1Oracle版本：11.2.0.1Oracle_home:/u01/app/oracle/product/11.2.0/db_1SQL>showparametername;NAMETYPEVALUE---------------------------------------------------------------------

2、--------db_file_name_convertstringdb_namestringorcldb_unique_namestringorclglobal_namesbooleanFALSEinstance_namestringorcllock_name_spacestringlog_file_name_convertstringservice_namesstringorcl备库：IP地址：192.168.1.38OS：RHEL6.5X64Hostname:lin-2Oracle版本：11.2.0.1O

3、racle_home:/u01/app/oracle/product/11.2.0/db_1SQL>showparametername;NAMETYPEVALUE-----------------------------------------------------------------------------db_file_name_convertstringdb_namestringorcldb_unique_namestringorcl2global_namesbooleanFALSEinstance

4、_namestringorcllock_name_spacestringlog_file_name_convertstringservice_namesstringorcl说明：由于我采用的是vmware虚拟化环境进行测试的。测试时首先安装好一台数据库，然后再克隆出另外一套。第二套根据需要，对主机名、IP地址进行更改。另外不要忘记更换oracle用户的环境变量、更改/etc/hosts解析文件注意：主库和备库的db_unique_name不能相同二：修改主备库listener.ora，tnsnames.ora2

5、.1、主库配置2.1.1、配置主库的监听：[oracle@lin-1admin]$vilistener.ora(G#listener.oraNetworkConfigurationFile:/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=orcl)(ORACL

6、E_HOME=/u01/app/oracle/product/11.2.0/db_1)(SID_NAME=orcl)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lin-1)(PORT=1521))))ADR_BASE_LISTENER=/u01/app/oracle2.1.2、修改主库的TnsnameORCL=(DESCRIPTION

7、=(ADDRESS=(PROTOCOL=TCP)(HOST=lin-1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))ORCL2=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lin-2)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl2)))2.2、备库配置2.2.1、配置备库的监听监听：[oracle@lin-2

8、admin]$catlistener.ora#listener.oraNetworkConfigurationFile:/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DE