OGGRAC环境下配置OGG单向同步 四.docx
- 文档编号:5761573
- 上传时间:2023-01-01
- 格式:DOCX
- 页数:34
- 大小:59.53KB
OGGRAC环境下配置OGG单向同步 四.docx
《OGGRAC环境下配置OGG单向同步 四.docx》由会员分享,可在线阅读,更多相关《OGGRAC环境下配置OGG单向同步 四.docx(34页珍藏版)》请在冰豆网上搜索。
OGGRAC环境下配置OGG单向同步四
【OGG】RAC环境下配置OGG单向同步(四)
1.1BLOG文档结构图
1.2前言部分
1.2.1导读
各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~:
①RAC环境下配置OGG单向同步
注意:
本篇BLOG中代码部分需要特别关注的地方我都用黄色背景和红色字体来表示,比如下边的例子中,thread1的最大归档日志号为33,thread2的最大归档日志号为43是需要特别关注的地方。
ListofArchivedLogsinbackupset11
ThrdSeqLowSCNLowTimeNextSCNNextTime
-----------------------------------------------------------
13216215892015-05-2911:
09:
5216252422015-05-2911:
15:
48
13316252422015-05-2911:
15:
4816252932015-05-2911:
15:
58
24216139512015-05-2910:
41:
1816252452015-05-2911:
15:
49
24316252452015-05-2911:
15:
4916252532015-05-2911:
15:
53
本文如有错误或不完善的地方请大家多多指正,ITPUB留言或QQ皆可,您的批评指正是我写作的最大动力。
1.2.2实验环境介绍
项目
sourcedb
targetdb
db类型
rac
单实例
dbversion
11.2.0.1
11.2.0.1
db存储
ASM
FStype
ORACLE_SID
jmrac1/jmrac2
orcl
db_name
jmrac
orcl
主机IP地址:
192.168.1.31/192.168.1.32
192.168.1.128
OS版本及kernel版本
RHEL5.764位,2.6.18-274.el5
RHEL6.564位,2.6.32-504.16.2.el6.x86_64
OGG版本
11.2.1.0.164位
11.2.1.0.164位
OShostname
node1/node2
orcltest
1.2.3相关参考文章链接
【OGG】OGG的下载和安装篇:
【OGG】OGG的单向DML复制配置
(一):
【OGG】OGG的单向复制配置-支持DDL
(二):
【OGG】OGG简单配置双向复制(三):
1.2.4本文简介
本文基于RAC环境下配置OGG单向同步,主要参考网址为:
,非常感谢斩月大师。
1.3实验部分
1.3.1实验目标
本文配置是:
rac(source)同单实例(target)数据库之间的ogg单向同步
1.4RAC环境下配置OGG单向同步
1.4.1首先在两个rac节点上配置ASM动态注册,11g的监听器引入了endpoints_listener.ora文件管理
1.4.1.1配置listener
配置监听,加入对ASM的动态注册:
[oracle@node1~]$srvctlstatuslistener
ListenerLISTENERisenabled
ListenerLISTENERisrunningonnode(s):
node1,node2
[oracle@node1~]$lsnrctlservices
LSNRCTLforLinux:
Version11.2.0.1.0-Productionon11-JUN-201516:
39:
32
Copyright(c)1991,2009,Oracle.Allrightsreserved.
Connectingto(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
ServicesSummary...
Service"+ASM"has2instance(s).
Instance"+ASM1",statusUNKNOWN,has1handler(s)forthisservice...
Handler(s):
"DEDICATED"established:
0refused:
0
LOCALSERVER
Instance"+ASM1",statusREADY,has1handler(s)forthisservice...
Handler(s):
"DEDICATED"established:
3refused:
0state:
ready
LOCALSERVER
Service"HAHA"has2instance(s).
Instance"jmrac1",statusREADY,has2handler(s)forthisservice...
Handler(s):
"DEDICATED"established:
0refused:
0state:
ready
REMOTESERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521)))
"DEDICATED"established:
5refused:
0state:
ready
LOCALSERVER
Instance"jmrac2",statusREADY,has1handler(s)forthisservice...
Handler(s):
"DEDICATED"established:
0refused:
0state:
ready
REMOTESERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521)))
Thecommandcompletedsuccessfully
[oracle@node1~]$
[grid@node1~]$cat$TNS_ADMIN/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))#lineaddedbyAgent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))#lineaddedbyAgent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON#lineaddedbyAgent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON#lineaddedbyAgent
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=+ASM)
(ORACLE_HOME=/u01/grid)
(SID_NAME=+ASM1)
)
)
[grid@node1~]$cat$TNS_ADMIN/endpoints_listener.ora
LISTENER_NODE1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1521)(IP=FIRST))))#lineaddedbyAgent
[grid@node1~]$
节点二监听:
[grid@node2~]$cat$TNS_ADMIN/listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))#lineaddedbyAgent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))#lineaddedbyAgent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON#lineaddedbyAgent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON#lineaddedbyAgent
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=+ASM)
(ORACLE_HOME=/u01/grid)
(SID_NAME=+ASM2)
)
)
[grid@node2~]$cat$TNS_ADMIN/endpoints_listener.ora
LISTENER_NODE2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.32)(PORT=1521)(IP=FIRST))))#lineaddedbyAgent
[grid@node2~]$
检查配置情况:
C:
\Users\Administrator>sqlplussys/lhr@192.168.1.31:
1521/+ASMassysdba
SQL*Plus:
Release11.2.0.1.0ProductiononThuJun1111:
13:
372015
Copyright(c)1982,2010,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions
SQL>setline9999
SQL>showparametername
NAMETYPEVALUE
----------------------------------------------------------------------------------------
db_unique_namestring+ASM
instance_namestring+ASM1
lock_name_spacestring
service_namesstring+ASM
SQL>connsys/lhr@192.168.1.32:
1521/+ASMassysdba
Connected.
SQL>showparametername
NAMETYPEVALUE
----------------------------------------------------------------------------------------
db_unique_namestring+ASM
instance_namestring+ASM2
lock_name_spacestring
service_namesstring+ASM
SQL>
1.4.1.2配置tnsnames.ora
注意切换到oracle用户下,2个节点均配置:
节点一:
[oracle@node1~]$su-oracle
Password:
[oracle@node1~]$cd$TNS_ADMIN
[oracle@node1admin]$ll
total16
drwxr-xr-x2oracleoinstall4096Feb272012samples
-rw-r--r--1oracleoinstall187May72007shrept.lst
-rw-r--r--1oracleoinstall1137Apr2814:
41tnsnames1504282PM4155.bak
-rw-r-----1oracleoinstall1752May1216:
17tnsnames.ora
[oracle@node1admin]$moretnsnames.ora
#tnsnames.oraNetworkConfigurationFile:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
#GeneratedbyOracleconfigurationtools.
RAC=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.32)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=HAHA)
)
)
ASM=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=+ASM)
(SID_NAME=+ASM1)
)
)
[oracle@node1admin]$
节点二:
[oracle@node2admin]$moretnsnames.ora
#tnsnames.ora.node2NetworkConfigurationFile:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora.node2
#GeneratedbyOracleconfigurationtools.
RAC=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.32)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=HAHA)
)
)
ASM=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.32)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=+ASM)
(SID_NAME=+ASM2)
)
)
[oracle@node2admin]$
检查配置情况:
[oracle@node1admin]$sqlpluslhr/lhr@rac
SQL*Plus:
Release11.2.0.1.0ProductiononThuJun1116:
47:
452015
Copyright(c)1982,2009,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,
DataMiningandRealApplicationTestingoptions
SQL>showparametername
NAMETYPEVALUE
-----------------------------------------------------------------------------
db_file_name_convertstring
db_namestringjmrac
db_unique_namestringjmrac
global_namesbooleanFALSE
instance_namestringjmrac2
lock_name_spacestring
log_file_name_convertstring
service_namesstringHAHA,jmrac
SQL>connsys/lhr@ASMassysasm
Connected.
SQL>showparametername
NAMETYPEVALUE
-----------------------------------------------------------------------------
db_unique_namestring+ASM
instance_namestring+ASM1
lock_name_spacestring
service_namesstring+ASM
SQL>
1.4.2RAC上安装OGG软件
1.4.2.1安装ACFS
我们首先来安装ACFS,即ASMClusterFileSystem,相关知识不多解释,而安装ACFS也有很多种办法,这里我们采用命令行的方式来安装ACFS,我们在节点一上操作:
a、root用户手工加载驱动:
ASMvolumedriver,acfsload为grid用户下的命令
[root@node1~]#acfsload-s
acfsload:
ACFS-9228:
usage:
acfsload{start|stop}[-s]
[root@node1~]#acfsloadstart
ACFS-9327:
VerifyingADVM/ACFSdevices.
ACFS-9322:
done.
[root@node1~]#
b、创建磁盘组,也可以不用创建磁盘组,后边采用已经存在的磁盘组来创建卷组,我们这里就不再重新创建磁盘组了
c、创建asm卷
[root@node1~]#su-grid
[grid@node1~]$sqlplus/assysasm
SQL*Plus:
Release11.2.0.1.0ProductiononThuJun1114:
16:
132015
Copyright(c)1982,2009,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions
SQL>alterdiskgroupDATAaddvolumeacfsvol1size1G;
Diskgroupaltered.
SQL>exit
DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions
[grid@node1~]$ll/dev/asm
total0
brwxrwx---1rootasmadmin252,118786Jun1114:
16acfsvol1-232
brwxrwx---1rootasmadmin252,118785Jun1113:
45vol01-232
[grid@node1~]$
d、创建acfs挂载目录,在rac1和rac2节点都执行
[root@node1~]#mkdir-p/u01/app/acfsmounts/acfsvol1-232
[root@node2~]#mkdir-p/u01/app/acfsmounts/acfsvol1-232
e、用mkfs创建文件系统
[root@node1~]#/sbin/mkfs-tacfs-nacfs01/dev/asm/acfsvol1-232
mkfs.acfs:
version=11.2.0.1.0.0
mkfs.acfs:
on-diskversion=39.0
mkfs.acfs:
volume=/dev/asm/acfsvol1-232
mkfs.acfs:
volumesize=1073741824
mkfs.acfs:
Formatcomplete.
[root@node1~]#
f、用acfsui
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OGGRAC环境下配置OGG单向同步 OGGRAC 环境 配置 OGG 单向 同步