ACT dpe_ext2,MEGABYTES 100
extract dpe_ext2
dynamicresolution
passthru
rmthost 192.168.175.139, mgrport 7840, compress
rmttrail ./dirdat/t3
numfiles 5000
TABLE OGG1.*;
add replicat rep_ext2,exttrail ./dirdat/t3,checkpointtable goldengate.rep_demo_ckpt
REPLICAT rep_ext2
USERID goldengate,PASSWORD goldengate
REPORTCOUNT EVERY 30 MINUTES, RATE
REPERROR DEFAULT, ABEND
numfiles 5000
--HANDLECOLLISIONS
assumetargetdefs
DISCARDFILE ./dirrpt/rep_rep2.dsc, APPEND, MEGABYTES 1000
ALLOWNOOPUPDATES
MAP OGG1.*,TARGET OGG1.*;
启用序列：目标端：
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 errors
STATUS OF SEQUENCE SUPPORT
--------------------------------------------------------------
SUCCESSFUL installation of Oracle Sequence Replication support
SQL> GRANT EXECUTE on goldengate.replicateSequence to ogg1;
Grant succeeded.
SQL>
目标端：
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 errors
STATUS OF SEQUENCE SUPPORT
--------------------------------------------------------------
SUCCESSFUL installation of Oracle Sequence Replication support
SQL> GRANT EXECUTE on goldengate.replicateSequence to ogg1;
Grant succeeded.
SQL>
复制进程：
传输进程：
GGSCI (oratest) 41> edit params DPE_EXT2
extract dpe_ext2
dynamicresolution
passthru
rmthost 192.168.175.139, mgrport 7840, compress
rmttrail ./dirdat/t3
numfiles 5000
TABLE OGG1.*;
SEQUENCE OGG1.*;
~
"dirprm/dpe_ext2.prm" 8L, 158C written
GGSCI (oratest) 42> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPE_DEMO 00:00:00 00:00:00
EXTRACT RUNNING DPE_EXT2 00:00:00 00:00:04
EXTRACT RUNNING EXT1 00:00:00 00:00:09
EXTRACT RUNNING EXT2 00:00:00 00:00:06
EXTRACT RUNNING EXT_DEMO 00:00:00 00:00:09
GGSCI (oratest) 43> stop DPE_EXT2
Sending STOP request to EXTRACT DPE_EXT2 ...
Request processed.
GGSCI (oratest) 44> start DPE_EXT2
Sending START request to MANAGER ...
EXTRACT DPE_EXT2 starting
GGSCI (oratest) 45> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPE_DEMO 00:00:00 00:00:00
EXTRACT RU |