Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS(五)
--------------------
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 errors
STATUS OF SEQUENCE SUPPORT
--------------------------------------------------------------
SUCCESSFUL installation of Oracle Sequence Replication support
[oracle@vzwc1 ora]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.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> view params mgr
PORT 7839
DYNAMICPORTLIST 7840-7914
USERID goldengate, PASSWORD goldengate
--AUTOSTART EXTRACT *
AUTORESTART EXTRACT *,RETRIES 3,WAITMINUTES 5,RESETMINUTES 10
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 1
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
config source extract group
GGSCI (vzwc1) 2> dblogin userid goldengate, password goldengate
Successfully logged into database.
GGSCI (vzwc1) 3> info trandata zwc.*
Logging of supplemental redo log data is disabled for table ZWC.TAB1.
GGSCI (vzwc1) 4>
add trandata zwc.tab1
Logging of supplemental redo data enabled for table ZWC.TAB1.
GGSCI (vzwc1) 5> info trandata zwc.tab1
Logging of supplemental redo log data is enabled for table ZWC.TAB1.
Columns supplementally logged for table ZWC.TAB1: OBJECT_ID.
GGSCI (vzwc1) 6> info trandata zwc.*
Logging of supplemental redo log data is enabled for table ZWC.TAB1.
Columns supplementally logged for table ZWC.TAB1: OBJECT_ID.
GGSCI (vzwc1) 7> list tables *
GOLDENGATE.GGS_DDL_COLUMNS
GOLDENGATE.GGS_DDL_HIST
GOLDENGATE.GGS_DDL_HIST_ALT
GOLDENGATE.GGS_DDL_LOG_GROUPS
GOLDENGATE.GGS_DDL_OBJECTS
GOLDENGATE.GGS_DDL_PARTITIONS
GOLDENGATE.GGS_DDL_PRIMARY_KEYS
GOLDENGATE.GGS_DDL_RULES
GOLDENGATE.GGS_DDL_RULES_LOG
GOLDENGATE.GGS_MARKER
GOLDENGATE.GGS_SETUP
GOLDENGATE.GGS_STICK
GOLDENGATE.GGS_TEMP_COLS
GOLDENGATE.GGS_TEMP_UK
Found 14 tables matching list criteria.
GGSCI (vzwc1) 8> capture tabledef zwc.tab1
Table definitions for ZWC.TAB1:
OWNER VARCHAR (30)
OBJECT_NAME VARCHAR (128)
SUBOBJECT_NAME VARCHAR (30)
OBJECT_ID NUMBER NOT NULL PK
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR (19)
CREATED DATETIME
LAST_DDL_TIME DATETIME
TIMESTAMP VARCHAR (19)
STATUS VARCHAR (7)
TEMPORARY VARCHAR (1)
GENERATED VARCHAR (1)
SECONDARY VARCHAR (1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR (30)
GGSCI (vzwc1) 9>
create a primary Extract group exta,and local trail file
[oracle@vzwc1 ora]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 1