Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS(六)
1.2.1.0.8 17044551 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_130718.0526_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jul 18 2013 10:34:27
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (vzwc1) 1> dblogin userid goldengate, password goldengate
Successfully logged into database.
GGSCI (vzwc1) 2> add extract exta, tranlog, begin now, threads 2
EXTRACT added.
GGSCI (vzwc1) 3> add exttrail ./dirdat/ea, extract exta
EXTTRAIL added.
GGSCI (vzwc1) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXTA 00:00:00 00:03:31
GGSCI (vzwc1) 13> view params exta
EXTRACT exta
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
--setenv (ORACLE_SID="VRAC1")
USERID goldengate@zwc, PASSWORD goldengate
--cachemgr cachedirectory ./dirtmp 100MB, CacheDirectory /ggs
--DDL Include Mapped
DDL INCLUDE OBJNAME "ZWC.*" EXCLUDE INSTR 'CREATE TRIGGER'
DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT
TRANLOGOPTIONS RAWDEVICEOFFSET 0
REPORTCOUNT EVERY 1 MINUTES, RATE
DISCARDFILE ./dirrpt/exta.dsc,APPEND,MEGABYTES 1024
DBOPTIONS ALLOWUNUSEDCOLUMN
WARNLONGTRANS 5h,CHECKINTERVAL 30m
EXTTRAIL ./dirdat/ea
FETCHOPTIONS NOUSESNAPSHOT
--tranlogoptions altarchivelogdest instance zwc1 /ggs
TranLogOptions ExcludeUser goldengate
TRANLOGOPTIONS DBLOGREADER
ThreadOptions MaxCommitPropagationDelay 10000 IOLatency 3000
TRANLOGOPTIONS _INFINITYTOZERO
TranlogOptions ASMUser sys@asm , asmpassword oracle
TRANLOGOPTIONS CONVERTUCS2CLOBS
--exclude report--
TABLEEXCLUDE ZWC.TAB2;
TABLE ZWC.*;
Create data pump group
GGSCI (vzwc1) 14>
add extract pumpa, exttrailsource ./dirdat/ea, begin now
EXTRACT added.
add remote trail file
GGSCI (vzwc1) 15> add rmttrail ./dirdat/ra, extract pumpa
RMTTRAIL added.
GGSCI (vzwc1) 4> view params pumpa
EXTRACT pumpa
RMTHOST 192.168.1.233, MGRPORT 7839
RMTTRAIL /ggs/ora/dirdat/ra
PASSTHRU
TABLEEXCLUDE ZWC.TAB2;
TABLE ZWC.*;
"oracle" user tnsnames.ora
ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vzwc1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
(INSTANCE_NAME = +ASM1)
(UR=A)
)
)
--on node2 tnsnames.ora
ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vzwc2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
(INSTANCE_NAME = +ASM2)
(UR=A)
)
)
on target
SQL> @sequence.sql
Please enter the name of a schema for the GoldenGate database objects:
goldengate
Setting schema name to GOLDENGATE
UPDATE_SEQUENCE STATUS:
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors
GETSEQFLUSH
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors
SEQTRACE
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No errors
REPLICATE_SEQUENCE STATUS:
Line/pos
--------------------
Error
-----------------------------------------------------------------
No errors
No