XXXX SharePlex维护手册

XXXXSharePlex维护手册XXXX项目管理文档Preparedby:NameHereQuestSoftware,SQuestProfessionalServices,2/3/20202InternalPartnerWinStorySharePlex维护手册保密声明本文档是由Quest虹天软件有限公司（以下简称：Quest公司或QuestSoftware）向XXXX免费提供，其内容专供XXXXSharePlex有关项目的规范和指导。本文档所包含的信息所有权属于Quest公司。本文件包含Quest公司保密资料，因此要求贵公司在收到本文件后五年内应为Quest公司保密；除非根据法律要求，不得出于除本项目评估之外的任何目的，以任何形式向任何第三方提供本文件内容；并同意采取所有合理的步骤，保证其接触本文件的人员不对外披露或散布本文件内容。请注意：如果您不同意上述声明，请不要阅读本文件，并立即将其返还给Quest公司；否则，Quest公司将视为您接受并同意遵守上述声明。SQuestProfessionalServices,2/3/20203InternalPartnerWinStorySharePlex维护手册目录1SHAREPLEX日常维护工作的重要性................................................................42当前环境配置及复制方案...........................................................................42.1环境配置...................................................................................................................................................42.2复制方案...................................................................................................................................................53SHAREPLEX日常监控................................................................................64常规表DDL操作的维护.............................................................................84.1Createatable操作――新增复制表.........................................................................................................84.2Dropatable――删除复制表...................................................................................................................94.3Altertablerenameto...............................................................................................................................94.4AltertableaddaLOBcolumn（或renamecolumn）.........................................................................104.5Altertablemoveanewtablespace.......................................................................................................115数据库模式操作的维护.............................................................................115.1需要同时维护的操作...............................................................................................................................115.2需要控制的操作......................................................................................................................................126其他常用操作........................................................................................126.1copy表..................................................................................................................................................126.2compare表............................................................................................................................................136.3忽略大事务的操作..................................................................................................................................136.4修改SharePlex的数据库用户密码........................................................................................................137获得SUPPORT........................................................................................15SQuestProfessionalServices,2/3/20204InternalPartnerWinStorySharePlex维护手册注意：本文档内容对于维护SharePlex的复制链路以及高可用环境至关重要。1SharePlex日常维护工作的重要性SharePlex提供了数据级的逻辑复制方案，它可以复制DML操作和DDL操作。目前XXXX的策略中关闭了DDL复制功能，只是打开了DML操作和Truncate操作。以后对生产库的DDL操作需要同时在管理库上执行，部分DDL操作需通过相应的操作步骤保证数据库的一致性和复制系统的可靠性，详见后面部分。2当前环境配置及复制方案2.1环境配置生产环境主要配置如下：Node1Node2硬件环境主机dcdb0110.120.8.63dcdb0210.120.8.65OracleVIPdcdb01_vip10.120.8.64dcdb01_vip10.120.8.66PrivateIPdcdb01_priv192.168.0.1dcdb02_priv192.168.0.2SharePlexVIPyxzb10.120.8.65(节点2不可用时才会将此IP地址绑定在节点1上)yxzb10.120.8.65(SharePlex运行在节点2上)名称解析/etc/hosts/etc/hosts软件环境操作系统HP-UX11.31HP-UX11.31数据库Oracle10.2.0.4Oracle10.2.0.4SharePlexSharePlex6.1SharePlex6.1SharePlexTNSsplexsplex报表环境主要配置如下：管理环境硬件环境主机dcadm10.120.8.67SQuestProfessionalServices,2/3/20205InternalPartnerWinStorySharePlex维护手册名称解析/etc/hosts软件环境操作系统HP-UX11.31数据库Oracle10.2.0.4SharePlexSharePlex6.1生产数据库：Node1Node2OracleSIDdl1dl2OracledbnamedldlOracleHome/oracle/product/db/10.2/oracle/product/db/10.2SharePlexOSuseroracleoracleSharePlexadmingroupdbadbaSharePlexportnumber22002200SharePlexcopyport25012501SharePlexcompareport25002500SharePlexhomedirectory/databackup/splex/databackup/splexSharePlexvardirdir/databackup/splex/vardir/databackup/splex/vardirSharePlexOracleusersplexsplexSharePlexusertablespaceusersusersSharePlextemptablespacetemptempSharePlexindextablespaceusersusers管理数据库：管理库OracleSIDadmOracledbnameadmOracleHome/oracle/product/db/10.2SharePlexOSuseroracleSharePlexadmingroupdbaSharePlexportnumber2200SharePlexhomedirectory/databackup/splexSharePlexvardirdir/databackup/splex/vardirSharePlexOracleusersplexSharePlexusertablespaceUsersSharePlextemptablespaceTempSharePlexindextablespaceusers2.2复制方案如下图所示：SQuestProfessionalServices,2/3/20206InternalPartnerWinStorySharePlex维护手册Oracle生产库SharePlex应用服务器RACOracle管理库查询应用服务器当前建立了一套复制链路，通过2200端口复制数据到管理库。同时考虑到以后的copy和compare操作，也分别开通了2501端口和2500端口。目前的链路是单向复制，管理库不会对复制的数据进行修改。复制链路：2200链路：生产库管理库生产库的操作系统用户：oracle生产库的数据库用户：splex管理库的数据库用户：splex3SharePlex日常监控日常监控非常重要，这是维护人员最基本也