ogg配置复习(dml)ddl)sequnce) - 数据库编程

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

ogg配置复习(dml)ddl)sequnce)(四)