备注:源端目标端
1.安装goldengate 软件
单独创建ogg 用户或使用oracle用户配置
查看oracle及grid用户属组:
[root@node1 ~]# id grid
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmDBA),1202(asmoper)
[root@node1 ~]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)
[root@node1 ~]#
rac 端:
asmca 创建通用acfs 文件系统
挂载点/u01/app/ogg
调整挂载点权限
chown oracleinstall ogg/
chmod -R 775 ogg/
单机端:
su - oracle
cd /u01/app
mkdir ogg
chown oracleinstall ogg/
chmod -R 775 ogg/
调整RAC及单机端oracle用户环境变量:
oracle .bash_profile
# ---------------------------------------------------
# OS User: oracle
# Application: Oracle Database Software Owner
# Version: Oracle 11g release 2
# ---------------------------------------------------
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
ORACLE_SID=orcl; export ORACLE_SID #another is dgh2
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
###add GGHOME
GGHOME=/u01/app/ogg/
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.{JAVA_HOME}/bin{PATH}HOME/binORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}ORACLE_HOME/oracm/lib
#ADD $ORACLE_HOME/lib
LD_LIBRARY_PATH=${ORACLE_HOME}/lib{LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
# ---------------------------------------------------
# UMASK
# ---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the user performing
# the Oracle software installation creates files
# with 644 permissions.
# ---------------------------------------------------
umask 022
解压ogg 12c软件
cd /tmp
unzip V46695-01.zip
cd fbo_ggs_Linux_x64_shiphome ./runInstaller 图形界面安装
2.创建goldengate 数据库用户:
--------------------------------------
rac:
create tablespace ogg datafile '+DATA/orcc/datafile/ogg.dbf' size 1G autoextend on extent management local uniform size 1M;
create user OGG identified by oracle default tablespace ogg temporary tablespace TEMP;
grant DBA to OGG;
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('OGG');
单机:
create tablespace ogg datafile '/u01/app/oracle/oradata/orcl/ogg.dbf' size 1g;
create user OGG identified by oracle default tablespace ogg temporary tablespace TEMP;
alter user ogg identified by ogg account unlock;
grant DBA to OGG;
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('OGG');
3.调整数据库配置:
ALTER DATABASE FORCE LOGGING;
Select SUPPLEMENTAL_LOG_DATA_MIN ,SUPPLEMENTAL_LOG_DATA_PK ,SUPPLEMENTAL_LOG_DATA_UI ,SUPPLEMENTAL_LOG_DATA_FK ,SUPPLEMENTAL_LOG_DATA_ALL from v$database;
打开数据库附加日志
打开附加日志并切换日志(保证Online redo log和Archive log一致)
alter database add supplemental log data ;
alter database add supplemental log data (primary key, unique,foreign key) columns;
alter system switch logfile;
Select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL from v$database;
注:确保最小附加日志,pk,uk,fk附加日志打开。而all columns的附加日志关闭;
如果all columns的附加日志打开的话,则需要使用以下语句予以关闭:
alter system set streams_pool_size=1024m scope=spfile;
alter system set enable_goldengate_replication=true;
shutdown immediate;
startup;
5.创建验证用户:
配置时注意源端目标端数据库连接串可能不同,及时调整
Create Wallet
Add CredentialStore
-----ALTER CREDENTIALSTORE DELETE USER ogg ALIAS ogg
Alter CredentialStore Add User ogg@orcc Password oracle Alias ogg
Info CredentialStore
-----12c 安装完成后自动启动MGR
edit params mgr
port 7809
su - oracle
cd $GGHOME
ggsci
edit params mgr
port 7809
autostart er *
autorestart er *
start mgr
6.源端EXTRACT,DATAPUMP进程
extract-------HEXT
datapump-----HPUMP
dblogin userid ogg,password oracle
Add TranData SCOTT.EMP
Add TranData SCOTT.DEPT
Info TranData SCOTT.EMP
Info TranData SCOTT.DEPT
edit params qext
Extract qext
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
--UserIdAlias ogg
UserId ogg@orcc,password oracle
TranlogOptions IntegratedParams (max_sga_size 512)
Exttrail ./dirdat/qu
LOGALLSUPCOLS
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table SCOTT.EMP;
table SCOTT.DEPT;
edit params hext
Extract hext
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
--UserIdAlias ogg
UserId ogg@orcc,password oracle
TranlogOptions IntegratedParams (max_sga_size 512)
Exttrail ./dirdat/hi
LOGALLSUPCOLS
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table SCOTT.EMP;
table SCOTT.DEPT;
register extract qext database
register extract hext database;
add extract qext, integrated tranlog, begin now;
add extract hext, integrated tranlog, begin now;
add exttrail ./dirdat/hi extract hext, megabytes 200
add exttrail ./dirdat/qu, extract qext, megabytes 200
备注:投递IP地址要用注册的oggvip对于RAC TO RAC的复制
edit params qupump
Extract qupump
--UserIdAlias ogg
UserId ogg@orcc,password oracle
rmthost 10.91.160.208, mgrport 7809
rmttrail ./dirdat/qu
table SCOTT.EMP;
table SCOTT.DEPT;
edit params hipump
Extract hipump
--UserIdAlias ogg
UserId ogg@orcc,password oracle
rmthost 10.91.160.208, mgrport 7809
rmttrail ./dirdat/hi
table SCOTT.EMP;
table SCOTT.DEPT;
add extract qupump, exttrailsource ./dirdat/qu
add extract hipump, exttrailsource ./dirdat/hi
add rmttrail ./dirdat/qu, extract qupump , megabytes 100
add rmttrail ./dirdat/hi, extract hipump , megabytes 100
edit params qrep
Replicat qrep
DBOPTIONS INTEGRATEDPARAMS(parallelism 6)
AssumeTargetDefs
DiscardFile ./dirrpt/rpdw.dsc, Purge
--UserIdAlias ogg
UserId ogg@orcc,password oracle
BATCHSQL
HANDLECOLLISIONS
Map SCOTT.EMP, target SCOTT.EMP;
Map SCOTT.DEPT, target SCOTT.DEPT;
add replicat qrep integrated exttrail ./dirdat/qu
edit params hrep
Replicat hrep
DBOPTIONS INTEGRATEDPARAMS(parallelism 6)
AssumeTargetDefs
DiscardFile ./dirrpt/rpdw.dsc, Purge
--UserIdAlias ogg
UserId ogg@orcl,password oracle
BATCHSQL
HANDLECOLLISIONS
Map SCOTT.EMP, target SCOTT.EMP;
Map SCOTT.DEPT, target SCOTT.DEPT;
add replicate hrep integrated exttrail ./dirdat/hi
同步用户实例化过程:
¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥
源端记录数据库当前SCN:此步在启动EXTRACT之前执行
su - oracle
sqlplus /nolog
connect /as sysdba
select current_scn from v$database;
创建数据泵导入导出目录:
源端导出数据:
----expdp system/oracle dumpfile=2016_%U.dmp directory=expdp_dir SCHEMAS=ECIQ_OPERATION,ECIQ_SUPPORT,ECIQ_LOB parallel=8 cluster=n FLASHBACK_SCN=1157541206
expdp system/oracle dumpfile=2016_%U.dmp directory=expdp_dir SCHEMAS=ECIQ_OPERATION,ECIQ_SUPPORT,ECIQ_LOB parallel=8 cluster=n FLASHBACK_SCN=1157541206
scp -pr *.dmp desthost:/u01/expdp_dir/
目标端导入数据:
SQL> create or replace directory expdp_dir as '/u01/expdp_dir';
grant read,write on directory expdp_dir to system;
-----impdp system/oracle dumpfile=2016_%U.dmp directory=expdp_dir SCHEMAS=ECIQ_OPERATION,ECIQ_SUPPORT,ECIQ_LOB parallel=8 cluster=n
impdp system/oracle dumpfile=2016_%U.dmp directory=expdp_dir SCHEMAS=ECIQ_OPERATION,ECIQ_SUPPORT,ECIQ_LOB parallel=8 cluster=n
问题:注意监听状态和配置是否正常
as root:
[root@node1 ~]# cd /u01/app/11.2.0/grid/bin
[root@node1 bin]# ./crsctl stat res -p |grep -ie .network -ie subnet |grep -ie name -ie subnet
REGISTRATION_INVITED_SUBNETS=
NAME=ora.net1.network
USR_ORA_SUBNET=192.168.1.0
[root@node1 bin]# ./appvipcfg create -network=1 -ip=192.168.1.80 -vipname=oggvip -user=root
Production Copyright 2007, 2008, Oracle.All rights reserved
2015-08-03 23:01:09: Creating Resource Type
2015-08-03 23:01:09: Executing /u01/app/11.2.0/grid/bin/crsctl add type app.appvip_net1.type -basetype ora.cluster_vip_net1.type -file /u01/app/11.2.0/grid/crs/template/appvip.type
2015-08-03 23:01:09: Executing cmd: /u01/app/11.2.0/grid/bin/crsctl add type app.appvip_net1.type -basetype ora.cluster_vip_net1.type -file /u01/app/11.2.0/grid/crs/template/appvip.type
2015-08-03 23:01:15: Create the Resource
2015-08-03 23:01:15: Executing /u01/app/11.2.0/grid/bin/crsctl add resource oggvip -type app.appvip_net1.type -attr "USR_ORA_VIP=192.168.1.80,START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network),STOP_DEPENDENCIES=hard(ora.net1.network),ACL='owner:root:rwx,pgrp:root:r-x,other::r--,user:root:r-x',HOSTING_MEMBERS=node1,APPSVIP_FAILBACK="
2015-08-03 23:01:15: Executing cmd: /u01/app/11.2.0/grid/bin/crsctl add resource oggvip -type app.appvip_net1.type -attr "USR_ORA_VIP=192.168.1.80,START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network),STOP_DEPENDENCIES=hard(ora.net1.network),ACL='owner:root:rwx,pgrp:root:r-x,other::r--,user:root:r-x',HOSTING_MEMBERS=node1,APPSVIP_FAILBACK="
[root@node1 bin]# ./crsctl setperm resource oggvip -u userracle:r-x
------- [root@node1 bin]# ./crsctl setperm resource oggvip -u user:grid:r-x
[root@node1 bin]# ./crsctl status resource oggvip
NAME=oggvip
TYPE=app.appvip_net1.type
TARGET=OFFLINE
STATE=OFFLINE
as oracle:
[oracle@node1 bin]# ./crsctl start resource oggvip
CRS-2672: Attempting to start 'oggvip' on 'node1'
CRS-2676: Start of 'oggvip' on 'node1' succeeded
[oracle@node1 bin]# ip a | grep 192.168.1.150
[oracle@node1 bin]# ip a | grep 192.168.1.80
inet 192.168.1.80/24 brd 192.168.1.255 scope global secondary eth0:2
[oracle@node1 bin]# ./crsctl status resource oggvip
NAME=oggvip
TYPE=app.appvip_net1.type
TARGET=ONLINE
STATE=ONLINE on node1
[root@node1 bin]# cd /u01/app/ogg
[root@node1 ogg]# touch 11gr2_ogg_action.scr
[root@node1 ogg]# vi 11gr2_ogg_action.scr
####注意目录GGS_HOME
#!/bin/sh
#set the Oracle Goldengate installation directory
export GGS_HOME=/u01/app/ogg
#set the oracle home to the database to ensure GoldenGate will get the
#right environment settings to be able to connect to the database
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
#specify delay after start before checking for successful start
start_delay_secs=5
#Include the GoldenGate home in the library path to start GGSCI
export LD_LIBRARY_PATH=$ORACLE_HOME/lib{GGS_HOME}:${LD_LIBRARY_PATH}
#check_process validates that a manager process is running at the PID
#that GoldenGate specifies.
check_process () {
if ( [ -f "${GGS_HOME}/dirpcs/MGR.pcm" ] )
then
pid=`cut -f8 "${GGS_HOME}/dirpcs/MGR.pcm"`
if [ ${pid} = `ps -e |grep ${pid} |grep mgr |cut -d " " -f2` ]
then
#manager process is running on the PID exit success
exit 0
else
if [ ${pid} = `ps -e |grep ${pid} |grep mgr |cut -d " " -f1` ]
then
#manager process is running on the PID exit success
exit 0
else
#manager process is not running on the PID
exit 1
fi
fi
else
#manager is not running because there is no PID file
exit 1
fi
}
#call_ggsci is a generic routine that executes a ggsci command
call_ggsci () {
ggsci_command=$1
ggsci_output=`${GGS_HOME}/ggsci<<EOF
${ggsci_command}
exit
EOF`
}
case $1 in
'start')
#start manager
call_ggsci 'start manager'
#there is a small delay between issuing the start manager command
#and the process being spawned on the OS. wait before checking
sleep ${start_delay_secs}
#check whether manager is running and exit accordingly
check_process
;;
'stop')
#attempt a clean stop for all non-manager processes
#call_ggsci 'stop er *'
#ensure everything is stopped
call_ggsci 'stop er *!'
#call_ggsci 'kill er *'
#stop manager without (y/n) confirmation
call_ggsci 'stop manager!'
#exit success
exit 0
;;
'check')
check_process
;;
'clean')
#attempt a clean stop for all non-manager processes
#call_ggsci 'stop er *'
#ensure everything is stopped
#call_ggsci 'stop er *!'
#in case there are lingering processes
call_ggsci 'kill er *'
#stop manager without (y/n) confirmation
call_ggsci 'stop manager!'
#exit success
exit 0
;;
'abort')
#ensure everything is stopped
call_ggsci 'stop er *!'
#in case there are lingering processes
call_ggsci 'kill er *'
#stop manager without (y/n) confirmation
call_ggsci 'stop manager!'
#exit success
exit 0
;;
esac
"11gr2_ogg_action.scr" 93L, 2660C written
[root@node1 ogg]# chmod +x 11gr2_ogg_action.scr
[root@node1 ogg]# ls -l | grep 11gr2_ogg_action.scr
-rwxr-xr-x 1 root root 2660 Aug 3 23:05 11gr2_ogg_action.scr
使用oracle用户添加oggapp,并授权给oracle用户管理
as oracle:
[grid@node1 ~]$ echo $ORACLE_HOME/bin
/u01/app/11.2.0/grid/bin
[oracle@node1 ~]$/u01/app/11.2.0/grid/bin/crsctl add resource oggapp -type cluster_resource -attr "ACTION_SCRIPT=/u01/app/ogg/11gr2_ogg_action.scr, CHECK_INTERVAL=30, START_DEPENDENCIES='hard(oggvip,ora.orcc.db) pullup(oggvip)', STOP_DEPENDENCIES='hard(oggvip)'"
[oracle@node1 ~]$./crsctl status resource oggapp
NAME=oggapp
TYPE=cluster_resource
TARGET=OFFLINE
STATE=OFFLINE
[root@node1 bin]# pwd
/u01/app/11.2.0/grid/bin
[root@node1 bin]# ./crsctl setperm resource oggapp -o oracle
检查target端的数据库是否可以正常连接,ogg进程是否运行正常
[root@dg3 ~]# su - oracle
[oracle@dg3 ~]$ sqlplus test/test
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 18 20:41:13 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
[oracle@dg3 ~]$ cd /u01/app/oracle/ogg/
[oracle@dg3 ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg3.yang.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING TESTRPT 00:00:00 00:00:03
GGSCI (dg3.yang.com) 2> exit
六:检查source端的数据库是否可以正常连接,ogg进程未启动
[root@node1 ~]# su - oracle
[oracle@node1 ~]$ sqlplus test/test@rac
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 18 20:42:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle
Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
T1 TABLE
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle
Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
[oracle@node1 ~]$ cd /ogg/
[oracle@node1 ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1.yang.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT ABENDED TESTEXT 00:00:00 22:54:53
EXTRACT ABENDED TESTPUMP 00:00:00 22:55:41
七:使用oracle用户启动oggapp resource,检查source(node1)上的ogg进程是否成功启动
[oracle@node1 ~]$ crsctl status resource oggapp
NAME=oggapp
TYPE=cluster_resource
TARGET=OFFLINE
STATE=OFFLINE
[oracle@node1 ~]$ crsctl start resource oggapp
CRS-2672: Attempting to start 'oggapp' on 'node1'
CRS-2676: Start of 'oggapp' on 'node1' succeeded
[oracle@node1 ~]$ cd /ogg/
[oracle@node1 ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1.yang.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING TESTEXT 00:00:00 00:00:07
EXTRACT RUNNING TESTPUMP 00:00:00 23:18:23
[oracle@node1 ~]$ crs_stat -t -v oggapp
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
oggapp clus...esource 0/1 0/0 ONLINE ONLINE node1
八:测试failover
[oracle@node1 ~]$ crsctl relocate resource oggapp -f
CRS-2673: Attempting to stop 'oggapp' on 'node1'
CRS-2677: Stop of 'oggapp' on 'node1' succeeded
CRS-2673: Attempting to stop 'oggvip' on 'node1'
CRS-2677: Stop of 'oggvip' on 'node1' succeeded
CRS-2672: Attempting to start 'oggvip' on 'node2'
CRS-2676: Start of 'oggvip' on 'node2' succeeded
CRS-2672: Attempting to start 'oggapp' on 'node2'
CRS-2676: Start of 'oggapp' on 'node2' succeeded
[oracle@node1 ~]$ crs_stat -t -v oggapp
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
oggapp clus...esource 0/1 0/0 ONLINE ONLINE node2
[root@node2 ~]# su - oracle
[oracle@node2 ~]$ cd /ogg/
[oracle@node2 ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (node2.yang.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING TESTEXT 00:00:00 00:00:05
EXTRACT ABENDED TESTPUMP 00:00:00 23:24:30
九:排错与停止oggapp服务,view report testpump查看日志报错如下
2012-07-18 21:05:59 ERROR OGG-01031 There is a problem in network communication, a remote file problem,
encryption keys for target and source do not match (if using ENCRYPT) or an unknown error.(Reply received is Unable to open file "/ogg/dirdat/rt000001" (error 11, Resource temporarily unavailable)).
2012-07-18 21:05:59 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (node2.yang.com) 15> alter extract testpump etrollover
2012-07-18 21:20:40 INFO OGG-01520 Rollover performed. For each affected output trail of Version 10 or higher format,
after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.
EXTRACT altered.
GGSCI (node2.yang.com) 18> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING TESTEXT 00:00:00 00:00:00
EXTRACT RUNNING TESTPUMP 00:00:00 00:00:10
[oracle@node2 ogg]$ crsctl stop resource oggapp
CRS-2673: Attempting to stop 'oggapp' on 'node2'
CRS-2677: Stop of 'oggapp' on 'node2' succeeded
[oracle@node2 ogg]$ crsctl status resource oggapp
crsctl stop resource ggatevip
NAME=oggapp
TYPE=cluster_resource
TARGET=OFFLINE
STATE=OFFLINE
如果停止使用grid infrastructure来管理ogg进程,只需要使用crsctl命令删除oggapp和oggvip服务即可!
需要值得注意的是,如果使用grid infrastructure来管理ogg,则mgr进程的参数文件中必须要配置autostart和autorestart选项!
参考文档:
http://blog.sina.com.cn/s/blog_6f1123420100qgl8.html
http://www.rickyzhu.com/2311_config-ha-goldengate.html
http://www.oracle.com/technetwor ... itepaper-128197.pdf
查询oggvip,oggapp配置信息
su - oracle
cd /u01/app/11.2.0/grid/bin
crsctl status res oggapp -p
crsctl status res ggatevip -p
crsctl status res resourcename -p
|
|