曾经的Integrated Extract测试

GGSCI (testogg) 14> view param extsrc EXTRACT extsrc setenv (ORACLE_SID="testrac1") setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8) EXTTRAIL /grid/goldengate/dirdat/ff USERID goldengate,PASSWORD "goldengate" TRANLOGOPTIONS ALTARCHIVELOGDEST +ASM_DATA TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.dbf TRANLOGOPTIONS ASMUSER SYS@asmpwd, ASMPASSWORD oracle_asm THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 90000 numfiles 3000 DISCARDROLLOVER AT 05:30 DYNAMICRESOLUTION GETTRUNCATES DDL INCLUDE MAPPED & exclude objtype 'PACKAGE' & exclude objtype 'PACKAGE BODY' & --exclude objtype 'PROCEDURE' & --exclude objtype 'FUNCTION' & --exclude objtype 'TYPE' & --exclude objtype 'TRIGGER' & --exclude objtype 'GRANT' & --exclude objtype 'DATABASE LINK' & --exclude objtype 'CONSTRAINT' & --exclude objtype 'JOB' & exclude instr 'ALTER SESSION' & exclude INSTR 'AS SELECT' & EXCLUDE OBJNAME "UPG_TESTA.DBMS_TABCOMP_TEMP_CMP" & EXCLUDE OBJNAME "UPG_TESTA.DBMS_TABCOMP_TEMP_UNCMP" & EXCLUDE OBJNAME "UPG_TESTB.DBMS_TABCOMP_TEMP_CMP" & EXCLUDE OBJNAME "UPG_TESTB.DBMS_TABCOMP_TEMP_UNCMP" DDLOPTIONS ADDTRANDATA,REPORT FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT STATOPTIONS REPORTFETCH WARNLONGTRANS 1H, CHECKINTERVAL 5M table UPG_TESTA.*; table UPG_TESTB.*; table test_schema.*; dblogin USERID goldengate,PASSWORD "goldengate" add trandata  GGSCI (testogg) 22> dblogin USERID goldengate,PASSWORD "goldengate" Successfully logged into database. GGSCI (testogg) 23> add schematrandata test_schema     add extract extsrc tranlog threads 3 begin now add exttrail /grid/goldengate/dirdat/ff, extract extsrc megabytes 200 添加pump进程： ： add extract edptest, exttrailsource /u01/goldengate/dirdat/co, begin now edit param edptest EXTRACT edptest                                                   setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8) PASSTHRU                                                          RMTHOST 192.168.88.9, MGRPORT 7819                                RMTTRAIL /data2/goldengate/dirdat/co                        DISCARDFILE ./dirrpt/extsrc.dsc,APPEND,MEGABYTES 5             TABLE  test_schema.*; --TABLE  UPG_TESTA.*; --TABLE  UPG_TESTB.*; add rmttrail /data2/goldengate/dirdat/co, extract edptest megabytes 200  注释： 可以根据不同的需求使用不同的pump传输不同的schema到目标端。 exec dbms_goldengate_auth.grant_admin_privilege('goldengate') Login into GGSCI Check to see if upgrade possible          GGSCI> INFO <extract_name> UPGRADE             info extsrc UPGRADE Upgrade may fail, in case of existing open transactions  GGSCI>stop extract <extract_name>                     stop extsrc GGSCI>dblogin userid <ggadmin>,password <password>    dblogin USERID goldengate,PASSWORD "goldengate" --Register the extract in the databse if not done already GGSCI>register extract <extract_name> database         register extract extsrc database GGSCI (testogg) 8> info extsrc EXTRACT    extsrc    Last Started 2014-03-17 16:34   Status STOPPED Checkpoint Lag       00:00:00 (updated 00:06:02 ago) Log Read Checkpoint  Oracle Redo Logs                      2014-03-17 17:38:43  Thread 1, Seqno 7978, RBA 16330752                      SCN 70.3270294843 (303918005563) Log Read Checkpoint  Oracle Redo Logs                      2014-03-17 17:38:41  Thread 2, Seqno 8944, RBA 650549248                      SCN 70.3270294838 (303918005558) GGSCI (testogg) 9>  GGSCI>alter extract <extract_name>,upgrade integrated tranlog         GGSCI>start extract <extract_name>     GGSCI (testogg) 10>  alter extract extsrc,upgrade integrated tranlog    ERROR: Extract extsrc is not ready to be upgraded because recovery SCN 303917843031 has not reached SCN 303918007090. GGSCI (testogg) 11> info extsrc EXTRACT    extsrc    Last Started 2014-03-17 16:34   Status STOPPED Checkpoint Lag       00:00:00 (updated 00:11:12 ago) Log Read Checkpoint  Oracle Redo Logs                      2014-03-17 17:38:43  Thread 1, Seqno 7978, RBA 16330752                      SCN 70.3270294843 (303918005563) Log Read Checkpoint  Oracle Redo Logs                      2014-03-17 17:38:41  Thread 2, Seqno 8944, RBA 650549248                      SCN 70.3270294838 (303918005558) GGSCI (testogg) 12> info extsrc upgrade ERROR: Extract extsrc is not ready to be upgraded because recovery SCN 303917843031 has not reached SCN 303918007090. GGSCI (testogg) 13>  开启extsrc   GGSCI (testogg) 38> info extsrc upgrade  Extract extsrc is ready to be upgraded to integrated capture.   可以升级 GGSCI (testogg) 39> alter extsrc ,upgrade integrated tranlog Extract extsrc successfully upgraded to integrated capture. GGSCI (testogg) 40> start extsrc 报错： 2014-03-17 18:00:44  INFO    OGG-02000  Oracle GoldenGate Capture for Oracle, extsrc.prm:  Ignoring option ASMUSER because it is incompatible with an integrated capture configuration. 2014-03-17 18:00:44  INFO    OGG-02000  Oracle GoldenGate Capture for Oracle, extsrc.prm:  Ignoring option ASMPASSWORD because it is incompatible with an integrated capture configuration. 2014-03-17 18:00:44  WARNING OGG-02064  Oracle GoldenGate Capture for Oracle, extsrc.prm:  Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support. 2014-03-17 18:00:44  ERROR   OGG-02021  Oracle GoldenGate Capture for Oracle, extsrc.prm:  This database lacks the required libraries to support integrated capture. 2014-03-17 18:00:44  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extsrc.prm:  PROCESS ABENDING. dblogin USERID goldengate,PASSWORD "goldengate" 同时 也需要执行授权 语句： EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE( - grantee => 'goldengate', - privilege_type => 'capture', grant_select_privileges=> true, do_grants => TRUE);