Brent的专栏

在官网上下载软件，oracle将软件归类到中间件那里。1.解压缩

本次实验oracle数据库为11.2.0.4gg版本为：Oracle GoldenGate Command Interpreter for OracleVersion 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBOLinux, x64, 64bit (optimized), Oracle 11g on Aug  7

1.源端mgr参数文件edit params mgrport 7809dynamicportlist 7810-7819autostart extract *autorestart extract *,retries 5,waitminutes 3,resetminutes 60  --每隔3分钟重启一次，尝试5次，等待5分钟后再尝试purgeoldextracts

FILTERUse FILTERto filter the display based on one or more criteria.■ You can string multiple FILTERcommands together, separating each one with a semi-colon, as in:FILTER INCLUDE FILENAME fin.

一、先停止replicat进程。GGSCI (bre2) 49> stop rep_t1Sending STOP request to REPLICAT REP_T1 ...Request processed.二、获取当前源端的scn号SQL> select dbms_flashback.get_system_change_number from dual;

1.查看record header：To view the record header with the data:Logdump 1> GHDR ONThe record header contains information about the transaction.2.添加列信息，列信息包括使用hex和ascii的编码显示的长度：To add column in