曾经的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);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25174901/viewspace-2640299/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25174901/viewspace-2640299/