Oracle GoldenGate(ogg)安装经验大汇总，采坑总结，绝对干货！

一下是安装ogg过程中遇到的问题和解决办法，绝对良心干货，抽空会写更详细的安装教程。更多精彩内容请点击

• OGG-00685 begin time prior to oldest log in log history

  https://blog.csdn.net/kiwi_kid/article/details/36184241

• goldengate 故障及解决方法汇总

  https://blog.csdn.net/amethystqi/article/details/6597861

• oracle 手册

  https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_gettingstarted.htm#GWUAD153

  https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/toc.htm

• (EXT.prm) line 13: Parsing error, [convertucs2clobs] is obsolete.

• expdp/impdp中parfile参数使用

  http://blog.itpub.net/26839123/viewspace-734463/

• window 注意 导入导出

  导入

  expdp parfile=D:\app\qingmiaokeji\admin\orcl\adump\expdp_zzbs.par PARALLEL=8 flashback_scn=1438905

  登录用户必须是dba

  F:\app\qingmiaokeji\admin\orcl\dpdump

  导出

  impdp qingmiaokeji/qingmiaokeji REMAP_SCHEMA=qingmiaokeji:qingmiaokeji REMAP_TABLESPACE=qingmiaokeji:qingmiaokeji_data dumpfile= expdp_zzbs_%U.dmp

• virtual box centos7 配置 上网

  https://blog.csdn.net/rcjjian/article/details/79879275

  https://blog.csdn.net/teisite/article/details/81196244

• centos7 安装oracle

  https://www.cnblogs.com/liuguosong/p/6057498.html

• 修改字符集

  https://www.cnblogs.com/gaoyuechen/p/9447404.html

• 错误整理： ORA-12705: Cannot access NLS data files or invalid environment specified

  https://blog.csdn.net/wolfchou/article/details/8696048

• 在Windows系统设置goldengate服务随系统启动

  https://blog.csdn.net/qq_42924709/article/details/85113791?tdsourcetag=s_pctim_aiomsg

• GoldenGate 配置extract,replicat进程自启动

  https://www.cnblogs.com/xqzt/p/4531045.html?tdsourcetag=s_pctim_aiomsg

• 删除10天前的trail文件

• Windows平台使用RMAN命令自动删除Oracle过期归档日志的方法

  https://blog.csdn.net/xiaolongzaixian/article/details/47921247

• Windows计划任务设置,定时执行指定脚本

  https://jingyan.baidu.com/article/e2284b2b72bffce2e6118d2c.html

• ogg trail文件版本问题,重置

  https://community.oracle.com/message/14447940?tstart=0

  https://www.2cto.com/database/201503/380443.html

  https://blog.csdn.net/orion61/article/details/25365741

  ALTER EXTRACT EPMP ETROLLOVER

ALTER REPLICAT finance, EXTSEQNO 53

• ORA-12560: TNS: 协议适配器错误

  https://www.jianshu.com/p/1c3dbe96af03

• OGG-01194 Oracle GoldenGate Capture for Oracle, ext_sc0.prm: EXTRACT task REP_SC0 abended : File InitialLoad, with compatibility level 6, is not compatible with the current software version's compatibility level of 5. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 5 option

  ogg 接收和发送端 ogg版本不一致，可用formate level参数

  EXTTRAIL ./dirdat/dbty/tr,FORMAT LEVEL 5

爱技术的程序员，在职上岸非全研究生；技术兴趣广泛：架构、java、python、nodejs、性能优化、工具、大数据、AI等技术分享！