erp数据库恢复操作步骤.docxVIP

操作步骤通知信调检修开始，并启用IMS备用接口停止ERP应用系统172.16.86.28 su - ep1admstopsap allcleanipc 02 remove172.16.86.30 su - ep1admstopsap allcleanipc 04 remove172.16.86.74 su - ep1admstopsap allcleanipc 06 removecleanipc 12 remove172.16.86.76 su - ep1admstopsap allcleanipc 08 remove关闭数据库自动重组db2 update db cfg using AUTO_RUNSTATS OFF导出表结构db2look -d WLQZDB -t DUAL -z LMC -a –e表结构如下:CREATE TABLE SAPEP1.SRT_MONILOG_DATA (CALL_IDVARCHAR(96) NOT NULL DEFAULT , TS_CALLDECIMAL(21, 7) NOT NULL DEFAULT 0, DURATION INTEGER NOT NULL DEFAULT 0, NETHDRTIME INTEGER NOT NULL DEFAULT 0, PARENT_CALLID VARCHAR(96) NOT NULL DEFAULT , CDP_TYPEVARCHAR(60) NOT NULL DEFAULT , COMPLETEVARCHAR(6) NOT NULL DEFAULT , USERNAMEVARCHAR(36) NOT NULL DEFAULT , SYS_SIDVARCHAR(24) NOT NULL DEFAULT , SYS_NRVARCHAR(6) NOT NULL DEFAULT , SAPCLIENTVARCHAR(9) NOT NULL DEFAULT 000, HOSTNAMEVARCHAR(96) NOT NULL DEFAULT , APPLSERVERVARCHAR(120) NOT NULL DEFAULT , CALL_STATEVARCHAR(3) NOT NULL DEFAULT , ERRORTYPEVARCHAR(30) NOT NULL DEFAULT , ERRORAREAVARCHAR(30) NOT NULL DEFAULT , MSG_STATEVARCHAR(9) NOT NULL DEFAULT 000, PROC_STATEVARCHAR(3) NOT NULL DEFAULT , TERM_STATEVARCHAR(3) NOT NULL DEFAULT , LOCATIONVARCHAR(3) NOT NULL DEFAULT , ISRESUMEVARCHAR(3) NOT NULL DEFAULT , DIRECTIONVARCHAR(3) NOT NULL DEFAULT , IS_ASYNCVARCHAR(3) NOT NULL DEFAULT , IS_SHORTCUTVARCHAR(3) NOT NULL DEFAULT , CALLEDPROGVARCHAR(765) NOT NULL DEFAULT , SESSION_IDVARCHAR(120) NOT NULL DEFAULT , COMM_PATTVARCHAR(765) NOT NULL DEFAULT , SOAP_APPLVARCHAR(180) NOT NULL DEFAULT , DT_OBJVARCHAR(765) NOT NULL DEFAULT , IF_NAME_IVARCHAR(90) NOT NULL DEFAULT , IF_NAME_EVARCHAR(765)