oracle dsg的优缺点,dsgoracle复杂软件比对步骤.doc

DSG软件比对步骤一、安装步骤均在目标端操作12DSG用户需要的权限ALLPRIVILEGES1ROLEFORDSGGRANTDBATODSGALTERUSERDSGDEFAULTROLEALL4SYSTEMPRIVILEGESFORDSGGRANTCUTEANYPROCEDURETODSGGRANTSELECTANYDICTIONARYTODSGGRANTSELECTANYSEQUENCETODSGGRANTSELECTANYTABLETODSG13创建DBLINK，连接生产库FORCREATEDBLINKDROPDATABASELINKDBVERIFYCREATEDATABASELINKDBVERIFYCONNECTTODSGIDENTIFIEDBYUSING TNSNAMES 14创建比对使用的临时表FORCREATECHECKTABLECREATETABLEDSGDSG_NO_SUP不支持的表OWNERVARCHAR210BYTE,TABLE_NAMEVARCHAR250BYTE,NO_SUP_TYPEVARCHAR220BYTECREATETABLECREATETABLEDSG_CHECK_TABLE当前比对的表DS_OWNERVARCHAR250NOTNULL,DT_OWNERVARCHAR250,DS_NAMEVARCHAR250NOTNULL,DT_NAMEVARCHAR250,TABLE_PARTITIONVARCHAR250NOTNULL,SYNONYM_NONUMBERDEFAULT0,CHECK_TYPEVARCHAR220,DS_COUNTNUMBER,DT_COUNTNUMBER,MINUS_COUNTNUMBER,SEQNUMBER,STATUSNUMBER,START_DIFFDATE,MINUS_DIFFDATE,DS_COUNT_DIFFDATE,DT_COUNT_DIFFDATE,ERR_MSGVARCHAR2500,CHECK_SQLVARCHAR24000CREATE/RECREATEPRIMARY,UNIQUEANDFOREIGNKEYCONSTRAINTSALTERTABLEDSG_CHECK_TABLEADDCONSTRAINTPK_DSG_CHECK_TABLEPRIMARYKEYDS_OWNER,DS_NAME,TABLE_PARTITIONCREATETABLEFORGETALLCHECKHIS,BUTITISONLYONCETIMECREATETABLEDSG_CHECK_HIS历史比对的表DS_OWNERVARCHAR250NOTNULL,DT_OWNERVARCHAR250,DS_NAMEVARCHAR250NOTNULL,DT_NAMEVARCHAR250,TABLE_PARTITIONVARCHAR250,SYNONYM_NONUMBER,CHECK_TYPEVARCHAR220,DS_COUNTNUMBER,DT_COUNTNUMBER,MINUS_COUNTNUMBER,SEQNUMBER,STATUSNUMBER,START_DIFFDATE,MINUS_DIFFDATE,DS_COUNT_DIFFDATE,DT_COUNT_DIFFDATE,ERR_MSGVARCHAR2500,CHECK_SQLVARCHAR24000创建存储过程见PAC_CHECK_OWNERPCK二、比对软件描述21初始化比对对象，包括表，对象(存储过程，函数，包等等)PROCEDUREINIT_CHECK_OWNERDS_OWNERINVARCHAR2,DT_OWNERINVARCHAR2比对单个表,首先COUNT比对，如果两边的COUNT值一致，然后再进行MINUS22初始化最后一次比对的表PROCEDUREINIT_CHECK_DATA23比对单表–在DSG_CHECK_TABLE里面STATUS2的是有问题的PROCEDURECHECK_TABLEP_DS_OWNERINVARCHAR2,P_DT_OWNERINVARCHAR2,P_TABLE_NAMEINVARCHAR2,P_TABLE_TYPEINNUMBER,P_CHECK_TYPEINNUMBER24对比两边分区表PROCEDURECHECK_TAB_PARTITIONP_DS_OWNERINVARCHAR2,P_DT_OWNERINVARCHAR2,P_TABLE_NAMEINVARCHAR2,P_PART_NAMEINVARCHAR2,P_CHECK_TYPEINNUMBER25发起数据比对PROCEDURECHECK_STARTP_TYPENUMBERDEFAULT00ISALL,1ISSIMPLE26停止数据比对,STATUS3WHERESTATUS0PROCEDURECHECK_STOP27重新启动并发，断点序传,STATUS0WHERESTATUS3PROCEDURECHECK_CONTINUE28比对结束,打印比对统计信息PROCEDURECHECK_SUMMARY_PRINT29发起比对对象PROCEDURECHECK_OBJECTS210找出不支持的表PROCEDURECHECK_NO_SUPP_OWNERINVARCHAR2211找出所有的JOB，以备可以手工处理PROCEDUREGET_ALL_JOBP_OWNERINVARCHAR2212找出所有的LOB数据PROCEDURESHOW_ALL_LOB_TAB213发起比对两边索引PROCEDURECHECK_INDEX214重建UNUSABLE索引，ENABLE外健PROCEDUREREPAIR_OBJ215编译所有的对象PROCEDURERECOMPILE_OBJ216打印出所有数据的大小，包括数据，索引，LOB数据，LOB索引PROCEDURESHOW_CHECK_TAB_SIZE217找出所有含有CHAINED_ROWS的表PROCEDUREFIND_CHAINED_ROW三、比对步骤31初始化比对用户SQLCPAC_CHECK_OWNERINIT_CHECK_OWNER AMBER , AMBER PL/SQLPROCEDURESUCCESSFULLYCOMPLETEDCUTEDIN0672SECONDS32发起数据比对(可以打开多个窗口，并发比对)SQLCPAC_CHECK_OWNERCHECK_STARTPL/SQLPROCEDURESUCCESSFULLYCOMPLETEDCUTEDIN33828SECONDS33检查比对结果SQLSETSERVEROUTPUTONSQLCPAC_CHECK_OWNERCHECK_SUMMARY_PRINTTYPUE_OKVALUE_ERRVALUE_NONETABLE40890SEQUENCE001OTHERISOKPL/SQLPROCEDURESUCCESSFULLYCOMPLETEDCUTEDIN0SECONDS34查找比对出错记录SQLSELECTDS_OWNER,DS_NAME,TABLE_PART

相关资源：软件滤波杂汇-C代码类资源-CSDN文库