欢迎来到天天文库
浏览记录
ID:58821057
大小:20.53 KB
页数:13页
时间:2020-10-25
《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
此文档下载收益归作者所有