Sybase到oracleOGG实施文档

1Sybase到oracleOGG实施文档1结构图1.1源机器IP:59.212.204.248数据库产品：Sybase端口号：7220用户名：sa密码：123456数据库：aicbas/aicbiz1.2目的机器IP:172.27.5.252数据库产品：oracle端口号：1521用户名：dbo_aicbiz密码：dbo_aicbiz数据库：orcl2环境说明源端一服务器地址：59.212.200.244，用户名：root，口令：1234567，操作系统为Linux，数据库为Sybase12.5，在操作系统上设置了sybase用户，数据库安装在/home/sybase目录下，OGG安装在/home/sybase/ogg目录下，访问OGG时需要先切换到sybase用户下，否则环境变量不生效。Sybase生产库需要同步95张表，分布在Sybase的aicbiz和aicbas两个库中。源端二服务器地址：172.27.100.199，用户名：root，口令：12345678，操作系统为Linux，且为虚拟机，数据库为Oracle10g，在操作系统上设置了oracle用户，数据库安2装在/u01/oracle目录下，OGG安装在/u01/ogg目录下，访问OGG时需要先切换到oracle用户下，否则环境变量不生效。12315数据库需要同步4张表。运行ogg的ggsci命令必须在/home/sybase/ogg或/u01/ogg目录下，也就是说，必须在ogg的安装目录下，否则ggsci不能正确读取配置信息。由于Sybase数据库里会在数据表里自动生成TIMESTAMP列，Oracle数据库中不支持此数据类型，而且此列也没有用处，所以在数据抽取过程中要忽略此列，因此，在extract配置文件中需要增加colsexcept（TIMESTAMP）参数。3Sybase生产库安装配置过程及脚本3.1Sybase生产库环境准备（1）在Sybase数据库上创建用户oggaic，并赋予sa_role和replication_role权限。sp_role‘grant’,sa_role,oggaicsp_role‘grant’,replication_role,oggaic（2）打开本地日志dbccsettrunc（‘ltm’，valid）（2）为sybase数据库需复制的表打开log复制ggscidbloginsourcedbaicbiz,useridoggaic,passwordoggaic3.2生产库配置过程3.2.1配置mgrggscieditparamsmgr3port7809dynamicportlist7810-7820autorestarter*,retries5,waitminutes3purgeoldextracts/home/sybase/ogg/dirdat/hn*,usecheckpoints,minkeepfiles103.2.2配置extractggsciaddextracthnesyb,tranlog,beginnowggsciaddexttrail/home/sybase/ogg/dirdat/hn,extracthnesybggscieditparamshnesybextracthnesybsourcedbaicbiz,useridoggaic,passwordoggaicexttrail/home/sybase/ogg/dirdat/hnextracthnesybsourcedbaicbiz,useridoggaic,passwordoggaicexttrail/home/sybase/ogg/dirdat/hntabledbo.TSupervisionHistory,colsexcept(TIMESTAMP);tabledbo.BusinessInfo,colsexcept(TIMESTAMP);tabledbo.PawnItem,colsexcept(TIMESTAMP);tabledbo.TIllegalRecord,colsexcept(TIMESTAMP);tabledbo.TInspectionLog,colsexcept(TIMESTAMP);tabledbo.TPartyInfo,colsexcept(TIMESTAMP);4tabledbo.Broker,colsexcept(TIMESTAMP);tabledbo.Buyer,colsexcept(TIMESTAMP);tabledbo.ENTERPRISEFORMONEY_GB,colsexcept(TIMESTAMP);tabledbo.TSampleCaseInfo,colsexcept(TIMESTAMP);tabledbo.EntityCurrentBizRange,colsexcept(TIMESTAMP);tabledbo.FCLM_SupMagIndicators;tabledbo.TAffInfo,colsexcept(TIMESTAMP);tabledbo.TAmendsInfo,colsexcept(TIMESTAMP);tabledbo.TAmendsOpinion,colsexcept(TIMESTAMP);tabledbo.TAmendsAuditing,colsexcept(TIMESTAMP);tabledbo.TComposeInfo,colsexcept(TIMESTAMP);tabledbo.TDeclaration,colsexcept(TIMESTAMP);tabledbo.BrokerHistory,colsexcept(TIMESTAMP);tabledbo.TSupervisionTask,colsexcept(TIMESTAMP);tabledbo.CASE_FY_ADMREVDECINFO_GB,colsexcept(TIMESTAMP);tabledbo.CASE_FY_APPPARTY_GB,colsexcept(TIMESTAMP);tabledbo.CASE_SS_LITIGATION_GB,colsexcept(TIMESTAMP);tabledbo.Wzgsjbqk,colsexcept(TIMESTAMP);tabledbo.TMESprvsnObj,colsexcept(TIMESTAMP);tabledbo.TCaseJudgment,colsexcept(TIMESTAMP);tabledbo.CancelDebt,colsexcept(TIMESTAMP);tabledbo.ResoundBrand,colsexcept(TIMESTAMP);5tabledbo.BrandApply,colsexcept(TIMESTAMP);tabledbo.NonPubParAnlys,colsexcept(TIMESTAMP);tabledbo.EntityCurrentLicence,colsexcept(TIMESTAMP);tabledbo.TCaseInfo_GB,colsexcept(TIMESTAMP);tabledbo.BizindividualInvestor,colsexcept(TIMESTAMP);tabledbo.Activity,colsexcept(TIMESTAMP);tabledbo.TCaseInfoAppend,colsexcept(TIMESTAMP);tabledbo.Wzgsjyqk,colsexcept(TIMESTAMP);tabledbo.ADOutDoor,colsexcept(TIMESTAMP);tabledbo.modifyLog,colsexcept(TIMESTAMP);tabledbo.Ad,colsexcept(TIMESTAMP);tabledbo.AdPerson,colsexcept(TIMESTAMP);tabledbo.AdExaminant,colsexcept(TIMESTAMP);tabledbo.Pledge,colsexcept(TIMESTAMP);tabledbo.Debtor,colsexcept(TIMESTAMP);tabledbo.ApplicantInfo,colsexcept(TIMESTAMP);tabledbo.TKeyInfo,colsexcept(TIMESTAMP);tabledbo.ExamineField,colsexcept(TIMESTAMP);tabledbo.Wzgswhqk,colsexcept(TIMESTAMP);tabledbo.AfterAuction,colsexcept(TIMESTAMP);tabledbo.ADQualificationInfo,colsexcept(TIMESTAMP);tabledbo.AnnualBaseInfo,colsexcept(TIMESTAMP);6tabledbo.Auction,colsexcept(TIMESTAMP);tabledbo.CurrentIndividualInvestor,colsexcept(TIMESTAMP);tabledbo.CurStockFreeze,colsexcept(TIMESTAMP);tabledbo.CurStockImpawn,colsexcept(TIMESTAMP);tabledbo.BizEntityInfo,colsexcept(TIMESTAMP);tabledbo.InvestedCapital,colsexcept(TIMESTAMP);tabledbo.LiquidateGroup,colsexcept(TIMESTAMP);tabledbo.LiquidatePerson,colsexcept(TIMESTAMP);tabledbo.BrandProposer,colsexcept(TIMESTAMP);tabledbo.Brand,colsexcept(TIMESTAMP);tabledbo.EntityBelong,colsexcept(TIMESTAMP);tabledbo.EntityVIPList,colsexcept(TIMESTAMP);tabledbo.MarketEntity,colsexcept(TIMESTAMP);tabledbo.CancelOpinion,colsexcept(TIMESTAMP);tabledbo.TSupervisionObjectIndex,colsexcept(TIMESTAMP);tabledbo.FoodBusinessLoc,colsexcept(TIMESTAMP);tabledbo.TQuashCaseAuditing,colsexcept(TIMESTAMP);tabledbo.TCaseInfo,colsexcept(TIMESTAMP);tabledbo.entityLegalRepresentative,colsexcept(TIMESTAMP);tabledbo.FoodPermit,colsexcept(TIMESTAMP);tabledbo.FoodPermitHea,colsexcept(TIMESTAMP);tabledbo.EntityName,colsexcept(TIMESTAMP);7tabledbo.BizInvest,colsexcept(TIMESTAMP);tabledbo.CorpInvestor,colsexcept(TIMESTAMP);tabledbo.CurFreezeInvest,colsexcept(TIMESTAMP);tabledbo.curStockPledge,colsexcept(TIMESTAMP);tabledbo.StockTransferInfo,colsexcept(TIMESTAMP);table