SharePlex实施文档以及常见故障

by你好我是李白1．SharePlex安装配置部分...........................................31.1解压安装....................................................31.2ora_setup配置..............................................31.3sp_cop-u2300&启动.........................................31.4sp_ctrl控制台..............................................41.5config配置文件.............................................41.6analyzeconfigconfig_name................................42．SharePlex常用操作...............................................52.1copy命令...................................................52.2compare与repair............................................62.3param设置参数..............................................62.4清除当前复制................................................72.5SharePlex实用参数命令......................................72.6忽略大事务的操作............................................82.7修改SharePlex的数据库用户密码..............................82.8新增复制表.................................................112.9删除复制表.................................................132.10重命名表..................................................152.11新增LOB列或者重命名列....................................152.12Altertablemoveanewtablespace.........................162.13一个软件启动多个SP实例...................................173．SharePlexAA复制实施...........................................203.1前言.......................................................203.2环境准备...................................................203.3数据初始化.................................................203.4reconcile队列数据.........................................213.5开启目标端post.............................................223.6目标端FK，job，trigger处理................................224．SharePlex其他复制说明..........................................224.1DDL复制...................................................224.2异构复制mapcolumns.......................................234.3级联复制...................................................244.3.1中间系统为数据库，有post情况下级联复制..............24by你好我是李白4.3.2中间系统为pass-through...............................254.4SharePlex高可用复制.......................................264.5配置Change-History复制....................................264.5.1Change-History........................................264.5.2其他的change-history配置选项........................274.6Oracle到Kafka复制........................................294.6.1概述.................................................294.6.2发送到Kafka说明.....................................294.6.3源端SharePlex配置...................................294.6.4开启supplementallogging.............................294.6.5设置SP_OCT_USE_SUPP_KEYS参数........................294.6.6配置复制.............................................304.6.7目标端SharePlex配置.................................304.6.8查看并且修改Kafka设置...............................314.6.9设置恢复选项.........................................335．日常监控........................................................345.1启动/关闭SharePlex........................................345.2登录控制台.................................................345.3主要监控项目...............................................345.4查看日志...................................................366．一些性能诊断方案................................................366.1针对capturetooslow......................................367．SharePlex一些问题的解决方案....................................377.1Vieweventsanderror......................................377.2忽略一些确定的可以忽略的错误...............................377.3insertnull复制到Kafka不显示.............................387.3.1问题描述.............................................387.3.2解决方案.............................................40by你好我是李白1．SharePlex安装配置部分端口：2100：SharePlex默认端口。2501：startlauncher需要开启端口，可以使用copy快速复制表。安装前数据库操作打开数据库最小附加日志：首先查看v$transaction视图有没有大事务，尽量避免有大事务的时候执行，如果系统资源非常紧张会导致宕机,RAC情况下各个节点都需要执行。alterdatabaseaddsupplementallogdata(primarykey,uniqueindex)columns;查询最小附加日志情况：selectSUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALLfromv$database;源库需要打开归档。1.1解压安装使用oracle用户解压，安装。$./SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm1.2ora_setup配置--配置shareplex，配置时如果需要自定义复制的源与目标端的ORACLE_SID，则需要配置tnsnames.ora别名，且/etc/oratab中必须有对应于自定义的tnsnames别名的ORACLE_SID。1.3sp_cop-u2300&启动[splex@localhost~]exportSP_SYS_HOST_NAME=cluster1vip可以使用该参数指定shareplex启动到指定的IP上，可以使用netstat-an|grepport_number--启动-u可以启动shareplex实例到指定端口，可以复制多个库。by你好我是李白1.4sp_ctrl控制台SharePlex日常操作都在sp_ctrl控制台中进行，启动命令为：/prodir/bin/sp_ctrl,一般启动之后首先进入控制台执行sp_ctrlstoppost，停止。1.5config配置文件Config配置文件为复制链路需要复制对象以及链路映射文件。sp_ctrllistconfigsp_ctrlverifyconfigsp_ctrlactivateconfigfile_namesp_ctrlactivateconfigfilename[threads-n][nolock]--加nolock不锁表，如果在一定时间内获取锁失败，则继续往下进行activate尽量执行两次，确保成功，可以同时tail-fevent_log查看执行情况。config配置样例以及配置规则：datasource:o.wahaha#sourcetablestargettablesroutingmap#[e-mail]_sid--target_sid为目标端的sid或别名。splex.demo_src--源库的用户名.表名，可以使用%通配符，全匹配半匹配等。priv%not(table_name)排除表。splex.demo_dest--目标库的用户名.表名[e-mail]_sid--目标库的IP或hosts文件中映射名@为目标端的sid或别名。hr.testhr.tes