备注：源端目标端

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

备注：源端目标端

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