goldengate oracle 安裝手冊.doc

*Oracle goldengate安裝手冊公司Oracle Goldengate安裝手冊 提交日期:2014年10月 版本號:v1.0文檔控制變更記錄 27日期作者版本號變更參考文件2020-3-2姚書懷V1.0審閱姓名職位發(fā)行拷貝號姓名地址1234Note: The copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table and the Copy Number label from the cover page.甲骨文公司聲明 本文件是由甲骨文軟件系統(tǒng)有限公司（以下簡稱：Oracle公司）向免費提供，其內(nèi)容專供江西用于評估Oracle公司為其提供產(chǎn)品及服務的能力，僅供參考。本文件所包含的信息所有權屬于Oracle公司。由于本文件包含Oracle公司保密資料，因此要求貴公司在收到本文件后三年內(nèi)應為Oracle公司保密；除非根據(jù)法律要求，不得出于除本項目評估之外的任何目的，以任何形式向任何第三方提供本文件內(nèi)容；并同意采取所有合理的步驟，保證其接觸本文件的人員不對外披露或散布本文件內(nèi)容。 本文件的內(nèi)容將可能且應該根據(jù)的具體實施情況及階段的變化而變化。 本文件對硬件規(guī)格、型號、性能的分析與估計并沒有考慮操作系統(tǒng)、網(wǎng)絡資源或任何其它在同一服務器上運轉(zhuǎn)的應用軟件對硬件的消耗。具體的硬件配備必須根據(jù)硬件廠商的推薦來決定。對本項目硬件最終選擇的決定權應由客戶掌握。本文件中對硬件規(guī)格的估計也不對客戶形成任何具有約束性質(zhì)的陳述或擔保。請注意：如果您不同意上述聲明，請不要閱讀本文件，并立即將其返還給Oracle公司；否則，Oracle公司將視為您接受并同意遵守上述聲明。目錄1環(huán)境信息52Goldengate安裝說明62.1 總體說明62.2 GG軟件的安裝（源和目標系統(tǒng)均需要安裝）62.3 開啟數(shù)據(jù)庫附加日志62.4 關閉數(shù)據(jù)庫的recyclebin (僅實施DDL時進行配置)72.5 配置定義文件72.6 添加環(huán)境變量82.7 編輯GLOBALS參數(shù)文件82.8 建立OGG的DDL對象82.9 建立OGG進程和隊列92.10 數(shù)據(jù)初始化142.11 目標庫disable相關對象142.12 目標配置replicat進程并追加增量數(shù)據(jù)（在目標庫完成重構后）151 環(huán)境信息以下為復制相關的環(huán)境信息說明（根據(jù)用戶實際環(huán)境填寫）：源端目標端1目標端2操作系統(tǒng)版本Linux version 2.6.32-220.el6.x86_64Linux version 2.6.32-220.el6.x86_64Linux version 2.6.32-358.el6.x86_64數(shù)據(jù)庫版本Oracle Oracle Oracle 是否RAC否否否IP地址356Oracle SIDOrclOrclOrcl是否ASMNoNoGG版本V.16V.16V.26GG安裝所在用戶OracleOracleOracleGG安裝所在主機單機單機單機GG安裝路徑/home/ogg/home/ogg/home/oggGoldengate數(shù)據(jù)庫用戶和表空間Ogg/oggOgg/oggOgg/ogg復制的用戶范圍MPIAGA ，MPIAGM ，MMSG用戶下所有表，復制到目標的對應用戶同名對象中。特別說明部分表需要進行轉(zhuǎn)換2 Goldengate安裝說明2.1 總體說明Goldengate軟件目錄的屬主為oracle:dba，權限為775;Goldengate目錄一般是建立在共享存儲上，這樣實際上goldengate的軟件和相應的文件如參數(shù)文件，隊列文件等都是在共享存儲上的。這樣做的好處是，例如在RAC環(huán)境下，如果一臺服務區(qū)宕機，則可以將$GG_HOME mount到另外一個正常的rac節(jié)點上，啟動goldengate各個進程就可以了，不需要做任何其他的動作;本次測試過程是部署在gpfs文件系統(tǒng)上。2.2 GG軟件的安裝（源和目標系統(tǒng)均需要安裝）1) 使用Oracle用戶（如非此用戶，請自行取代，下同）通過ftp上傳GGS軟件到安裝目錄下并解壓縮：tar zxvf *.gz或者分兩步解壓：gunzip *.gz 或 gzip d *.gztar xvf *.gz2) 在/goldengate目錄下運行GGS命令行控制界面：./ggsci3) 在GGS命令行界面下創(chuàng)建子目錄：GGSCI create subdirs2.3 開啟數(shù)據(jù)庫附加日志1）檢查附加日志情況使用以下sql語句檢查數(shù)據(jù)庫附加日志的打開狀況:Select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL, FORCE_LOGGING from v$database;2）打開數(shù)據(jù)庫附加日志打開附加日志并切換日志（保證Online redo log和Archive log一致）alter database add supplemental log data ; 或全部打開：alter database add supplemental log data(primary key) columns;alter database add supplemental log data(all,primary key,unique,foreign key) columns;alter database force logging;3）打開表級附加日志create tablespace goldengate datafile /home/oracle/oradata/mpiag/ogg.dbf size 1G; create user goldengate identified by goldengate1 default tablespace users;grant connect,resource,dba to goldengate; Dblogin userid ogg, password oggAdd trandata MPIAGA.* Add trandata MPIAGM.*Add trandata MMSG.*obey ./dirprm/table.txt.4）檢查logging屬性要檢查所有要復制的表都有屬性LOGGING，樣例語句如下：SELECT OWNER, TABLE_NAME FROM DBA_TABLES WHERE LOGGING = NO AND OWNER=SEA;對LOGGING = NO的表執(zhí)行：ALTER TABLE . LOGGING;5）檢查compression屬性要檢查所有要復制的表都沒有屬性compression，樣例語句如下：SELECT OWNER, TABLE_NAME FROM DBA_TABLES WHERE compression= ENABLED AND OWNER=SEA;SELECT TABLE_OWNER, TABLE_NAME FROM DBA_TAB_PARTITIONS WHERE compression= ENABLED AND TABLE_OWNER=SEA;2.4 關閉數(shù)據(jù)庫的recyclebin (僅實施DDL時進行配置)查詢當前recyclebin的參數(shù)值：SQL show parameter recyclebinNAME TYPE VALUE- - -recyclebin string OFFSQL如不是off，需要關閉recyclebin：SQLalter system set recyclebin=off scope=both;如果需要回退，打開recyclebin的話，可以使用以下語句：SQLalter system set recyclebin=on scope=both;2.5 配置定義文件Shell cd Shell ggsciGGSCI edit param defgenDEFSFILE dirdef/source.def, PURGESOURCEDB orcl, USERID ogg, PASSWORD oggTABLE MPIAGA.* ;TABLE MPIAGM.*;TABLE MMSG.*;GGSCI exitShell defgen paramfile dirprm/defgen.prmShell ftp Name (:): Password: passwordftp asciiftp cd /dirdefftp lcd /dirdefftp put source.defftp bye2.6 添加環(huán)境變量在oracle用戶下增加環(huán)境變量：源端：export GG_HOME=/gg/oggexport PATH=$PATH:$GG_HOMEexport LIBPATH=$GG_HOME:$ORACLE_HOME/lib-export LD_LIBRARY_PATH=/ogg:$ORACLE_HOME/lib目標端：export GG_HOME=/gg/oggexport PATH=$PATH:$GG_HOMEexport LIBPATH=$GG_HOME:$ORACLE_HOME/lib2.7 編輯GLOBALS參數(shù)文件這里直接建立在goldengate用戶下：GgsciEDIT PARAMS ./GLOBALS -在該文件中添加以下內(nèi)容GGSCHEMA ogg -指定的進行DDL復制的數(shù)據(jù)庫用戶2.8 建立OGG的DDL對象sqlplus / as sysdbaSQL marker_setup.sqlEnter GoldenGate schema name:goldengateSQL ddl_setup.sqlEnter GoldenGate schema name:goldengateSQL role_setup.sqlGrant this role to each user assigned to the Extract, Replicat, GGSCI, and Manager processes, by using the following SQL command:GRANT GGS_GGSUSER_ROLE TO goldengatewhere is the user assigned to the GoldenGate processes.注意這里的提示：需要手工將這個GGS_GGSUSER_ROLE指定給extract所使用的數(shù)據(jù)庫用戶（即參數(shù)文件里面通過userid指定的用戶），可以到sqlplus下執(zhí)行類似的sql:GRANT GGS_GGSUSER_ROLE TO goldengate;注：這里的goldengate是extract使用的用戶。如果你有多個extract，使用不同的數(shù)據(jù)庫用戶，則需要重述以上過程全部賦予GGS_GGSUSER_ROLE權限。運行以下腳本，使觸發(fā)器生效SQL ddl_enable.sql安裝提升性能工具：本步驟為可選步驟，一般情況下建議運行該步驟。為了提供OGG的DDL復制的性能，可以將ddl_pin腳本加入到數(shù)據(jù)庫啟動的腳本后面，該腳本需要帶一個OGG的DDL用戶（即安裝DDL對象的用戶，本例中是goldengate）的參數(shù):SQL ddl_pin 注：如果因為業(yè)務問題，開啟DDL以后，對性能的影響比較大的話，需要臨時禁用DDL觸發(fā)器的話，可以運行以下語句：SQL ddl_disable.sql 因為目前要求關閉DDL復制，所以執(zhí)行ddl_disable2.9 同步sequence (僅實施sequence同步時進行配置)SQL sequence.sqlSQL GRANT EXECUTE on ogg.updateSequence TO ogg;SQL GRANT EXECUTE on ogg.replicateSequence TO ogg;SQL alter table sys.seq$ add supplemental log data (primary key) columns;2.10 建立OGG進程和隊列（1） MGR參數(shù)和進程（源和目標均需要配置）cd $GG_HOME./ggsciggsciedit param mgr -源端PORT 7809DYNAMICPORTLIST 7810-7860-AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 3, RESETMINUTES 60PURGEOLDEXTRACTS ./dirdat/*, usecheckpoints, minkeepdays 1LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45-PURGEDDLHISTORY MINKEEPDAYS 1, MAXKEEPDAYS 1 -如果打開ddl，去掉注釋-PURGEMARKERHISTORY MINKEEPDAYS 1, MAXKEEPDAYS 1-如果打開ddl，去掉注釋ggsciedit param mgr -目標端PORT 7809DYNAMICPORTLIST 7840-7914-AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3, RESETMINUTES 60PURGEOLDEXTRACTS ./dirdat/*, usecheckpoints, minkeepdays 1LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45PURGEDDLHISTORY MINKEEPDAYS 1, MAXKEEPDAYS 1PURGEMARKERHISTORY MINKEEPDAYS 1, MAXKEEPDAYS 1配置完成后，源和目標均啟動：ggsci start mgr（2） 源端配置extract和pump進程（根據(jù)用戶實際環(huán)境填寫）cd $GG_HOME./ggsciggsciedit param extcj具體ggsext內(nèi)容如下：EXTRACT extcjSetenv (NLS_LANG=AMERICAN_AMERICA.UTF8)USERID goldengate, PASSWORD neusoftSaugettruncatesDISCARDFILE ./dirrpt/extcj.dsc, APPEND, MEGABYTES 1024-THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000DBOPTIONS ALLOWUNUSEDCOLUMNREPORTCOUNT EVERY 1 MINUTES, RATEWARNLONGTRANS 2h,CHECKINTERVAL 3mFETCHOPTIONS NOUSESNAPSHOTTRANLOGOPTIONS CONVERTUCS2CLOBSEXTTRAIL ./dirdat/cjTRANLOGOPTIONS altarchivelogdest primary instance sea1 /seaarch1, altarchivelogdest instance sea2 /seaarch2WILDCARDRESOLVE DYNAMICdynamicresolutiontable sea.E_DATA_MP;table sea.E_DATA_MP_HIS;table sea.E_DATA_TOTAL;table sea.E_FEE_USEVALUE;table sea.E_MET_DATA_READ;table sea.E_MET_SWITCH_OPERATE;table sea.E_MP_ABC_OFF;table sea.E_MP_ANALOG_CURVE;table sea.E_MP_BATTERYSTATE;table sea.E_MP_CUR_CURVE;table sea.E_MP_CURPHASE_CURVE;table sea.E_MP_CURVE;table sea.E_MP_DAY_ABC_DEMAND;table sea.E_MP_DAY_ABC_READ;table sea.E_MP_DAY_COMP;table sea.E_MP_DAY_DC_ANALOG_LIMIT;table sea.E_MP_DAY_DEMAND;table sea.E_MP_DAY_DEMAND_ZC;table sea.E_MP_DAY_ENERGY;table sea.E_MP_DAY_ISTAT;table sea.E_MP_DAY_LOAD_RATE;table sea.E_MP_DAY_LOSE_PHASE;table sea.E_MP_DAY_PFTIME;table sea.E_MP_DAY_POWER;table sea.E_MP_DAY_POWER_ONOFF;table sea.E_MP_DAY_READ;table sea.E_MP_DAY_READ_ZC;table sea.E_MP_DAY_UNBALANCE;table sea.E_MP_DAY_VSTAT;table sea.E_MP_ENERGY_CURVE;table sea.E_MP_FACTOR_CURVE;table sea.E_MP_HARMONIC;table sea.E_MP_MET_BC_ENERGY;table sea.E_MP_METER_CLOCK;table sea.E_MP_METER_READ;table sea.E_MP_MON_DC_ANALOG_LIMIT;table sea.E_MP_MON_DEMAND;table sea.E_MP_MON_ENERGY;table sea.E_MP_MON_ISTAT;table sea.E_MP_MON_LOAD_RATE;table sea.E_MP_MON_PFTIME;table sea.E_MP_MON_POWER;table sea.E_MP_MON_READ;table sea.E_MP_MON_UNBALANCE;table sea.E_MP_MON_VSTAT;table sea.E_MP_PLC_INFO;table sea.E_MP_POWER_CURVE;table sea.E_MP_RDAY_DEMAND;table sea.E_MP_RDAY_READ;table sea.E_MP_READ;table sea.E_MP_READ_CURVE;table sea.E_MP_VOL_CURVE;table sea.E_MP_VOLPHASE_CURVE;table sea.E_TMNL_DAY_STAT;table sea.E_TMNL_DAY_SUPPLY_POWER;table sea.E_TMNL_EVENT;table sea.E_TMNL_MON_STAT;table sea.E_TOTAL_CURVE;table sea.E_TOTAL_CURVE_LOG;table sea.E_TOTAL_DAY_STAT;table sea.E_TOTAL_ENERGY_CURVE;table sea.E_TOTAL_MON_LIMIT_STAT;table sea.E_TOTAL_MON_STAT;table sea.CP_CONSPQ_DAY;table sea.CP_CONSREAD_DAY;table sea.CP_TGPQ_DAY;table sea.DATA_MP;table sea.DATATYPE;table sea.E_TOTAL_POWER_CURVE;table sea.BG_TASK_IEIG_RELA;table sea.F9;table sea.F97;table sea.F98;table sea.T_AUTO_CLOCK_STRATEGY;table sea.T_BATCH_CALL_CONFIG;table sea.T_BATCH_CALL_DETAIL;table sea.T_BATCH_CALL_OBJ;table sea.T_BG_TASK;table sea.T_BG_TASK_DETAIL;table sea.T_BG_TASK_HIS;table sea.T_BG_TASK_MET_SEND;table sea.T_BG_TASK_RESULT;table sea.T_BG_TASK_SEND;table sea.T_CLEAR_COMBI;table sea.T_CLEAR_COMBI_DETAIL;table sea.T_COLL_TASK;table sea.T_COLL_TASK_DET;table sea.T_DATA_COMBI;table sea.T_DDN_CHANNEL;table sea.T_DIAL_CHANNEL;table sea.T_DIAL_GROUP_CHANNEL;table sea.T_INTER_TASK;table sea.T_INTER_TASK_DETAIL;table sea.T_INTER_TASK_LOG;table sea.T_INTER_TASK_RESULT;table sea.T_MET_PARAM;table sea.T_METER_CHECK_CLOCK;table sea.T_METER_VOLT_CALLVALUE;table sea.T_METER_VOLT_TASK;table sea.T_MOXA_DIAL_GROUP;table sea.T_MOXA_GROUP_CHANNEL;table sea.T_MOXA_INFO;table sea.T_MOXA_TMNL_CHANNEL;table sea.T_MP_QUOTA_PARAM;table sea.T_NET_CHANNEL;table sea.T_STATION_CONFIG;table sea.T_STATION_INFO;table sea.T_TASK_STATISTIC_BASE;table sea.T_TASK_STATISTIC_ERROR;table sea.T_TASK_TEMPLATE_DATA_XMB;table sea.T_TASK_TEMPLATE_XMB;table sea.I_TMNL_TASK_SETUP_XMB;table sea.T_TASK_STATISTIC_STATUS;table sea.T_TASK_TEMPLATE;table sea.T_TASK_TEMPLATE_DATA;table sea.T_TIMEADM_TASK;table sea.T_TMNL_ADDR_GROUP;table sea.T_TMNL_ADDR_GROUP_DETAIL;table sea.T_TMNL_CHECK_CLOCK;table sea.T_TMNL_CTRL_PARAM;table sea.T_TMNL_CTRL_PARAM_DETAIL;table sea.T_TMNL_GROUP;table sea.T_TMNL_GROUP_DETAIL;table sea.T_TMNL_MP_PARAM;table sea.T_TMNL_PARAM;table sea.T_TMNL_PARAM_F1;table sea.T_TMNL_PARAM_F10;table sea.T_TMNL_PARAM_F11;table sea.T_TMNL_PARAM_F12;table sea.T_TMNL_PARAM_F13;table sea.T_TMNL_PARAM_F14;table sea.T_TMNL_PARAM_F15;table sea.T_TMNL_PARAM_F150;table sea.T_TMNL_PARAM_F16;table sea.T_TMNL_PARAM_F17;table sea.T_TMNL_PARAM_F18;table sea.T_TMNL_PARAM_F19;table sea.T_TMNL_PARAM_F2;table sea.T_TMNL_PARAM_F20;table sea.T_TMNL_PARAM_F21;table sea.T_TMNL_PARAM_F22;table sea.T_TMNL_PARAM_F23;table sea.T_TMNL_PARAM_F28;table sea.T_TMNL_PARAM_F29;table sea.T_TMNL_PARAM_F3;table sea.T_TMNL_PARAM_F30;table sea.T_TMNL_PARAM_F33;table sea.T_TMNL_PARAM_F34;table sea.T_TMNL_PARAM_F35;table sea.T_TMNL_PARAM_F36;table sea.T_TMNL_PARAM_F37;table sea.T_TMNL_PARAM_F38;table sea.T_TMNL_PARAM_F39;table sea.T_TMNL_PARAM_F4;table sea.T_TMNL_PARAM_F5;table sea.T_TMNL_PARAM_F57;table sea.T_TMNL_PARAM_F58;table sea.T_TMNL_PARAM_F59;table sea.T_TMNL_PARAM_F6;table sea.T_TMNL_PARAM_F60;table sea.T_TMNL_PARAM_F61;table sea.T_TMNL_PARAM_F65;table sea.T_TMNL_PARAM_F66;table sea.T_TMNL_PARAM_F67;table sea.T_TMNL_PARAM_F68;table sea.T_TMNL_PARAM_F7;table sea.T_TMNL_PARAM_F8;table sea.T_TMNL_PARAM_F84;table sea.T_TMNL_PARAM_F89;table sea.T_TMNL_PARAM_F9;table sea.T_TMNL_PARAM_F90;table sea.T_TMNL_PARAM_F91;table sea.T_TMNL_PARAM_F97;table sea.T_TMNL_PARAM_F98;table sea.T_TMNL_PULSE_INFO;table sea.T_TMNL_TASK;table sea.T_TMNL_TOTAL_INFO;table sea.C_AVOID_FILCH_EQUIP;table sea.C_CERT;table sea.C_CONS;table sea.C_CONS_CONTACT_RELA;table sea.C_CONS_LOW_PRESSURE;table sea.C_CONS_VIP;table sea.C_CONTACT;table sea.C_CUST;table sea.C_CUST_ADDR;table sea.C_CUST_RELA;table sea.C_ELEC_ADDR;table sea.C_IT_RUN;table sea.C_METER;table sea.C_METER_ENCRYPT;table sea.C_METER_MP_RELA;table sea.C_METER_PBS_RELA;table sea.C_METER_PHASIC;table sea.C_MP;table sea.C_MP_IT_RELA;table sea.C_MP_SECT;table sea.C_MP_USE;table sea.C_PS;table sea.C_SP;table sea.C_CONS_KV;table sea.C_CONS_NET_PEI;table sea.CIS_OPERATOR;table sea.D_CARRIER_WAVE;table sea.D_FMR_EQUIP;table sea.D_IT;table sea.D_LC_EQUIP;table sea.D_MEAS_BOX;table sea.D_MEAS_CUBICLE;table sea.D_METER;table sea.D_OTHER_DEV;table sea.D_STATUS_CHG;table sea.D_VL_DEV;table sea.FC_CONS_CERT_RELA;table sea.FC_CONS_GC_RELA;table sea.FC_GC;table sea.FC_GC_ADDR;table sea.FC_GN;table sea.FC_GP;table sea.FC_PLANT;table sea.G_CUST_SORT_SETUP;table sea.G_LINE;table sea.G_LINE_ITEMS;table sea.G_LINE_RELA;table sea.G_LINE_TG_RELA;table sea.G_ORDERS;table sea.G_SUBS;table sea.G_SUBS_LINE_RELA;table sea.G_TG;table sea.G_TRAN;table sea.N_NET_MANAGE;table sea.N_NET_MANAGE_RELA;table sea.O_DEPT;table sea.O_ORG;table sea.O_ORG_CHILDS;table sea.O_ORG_CHILDS_NEW;table sea.O_STAFF;table sea.ORG_FORMULA;table sea.R_AR_DATA_LOG;table sea.R_COLL_OBJ;table sea.R_CONS_TMNL_RELA;table sea.R_CP;table sea.R_CP_COMM_PARA;table sea.R_CP_CONS_RELA;table sea.R_CP_CTRL_PARA;table sea.R_CP_DESIGN_SCHEME;table sea.R_CP_FAULT;table sea.R_CP_MP_RELA;table sea.R_CP_SURVEY;table sea.R_CP_SWITCH_PARA;table sea.R_CP_TS_PARA;table sea.R_CR_RECORD;table sea.R_DEV_STAFF_RELA;table sea.R_EXEC_OTHER_DEV;table sea.R_FMR_EQUIP;table sea.R_LC_SWITCH_TURNS;table sea.R_MEASURE_CHK_CFG;table sea.R_OPER_ACTIVITY;table sea.R_PATROL;table sea.R_PATROL_PLAN;table sea.R_PLAN_DAY;table sea.R_SECT;table sea.R_SECT_GRID_RELA;table sea.R_SIM_CHARGE;table sea.R_SITE_FAULT_RMV;table sea.R_TEMPLATE_ERATE;table sea.R_TEMPLATE_LADDERFEE;table sea.R_TG_CP_DIAGRAM;table sea.R_TMNL_ABNORMAL_ARCHIVES;table sea.R_TMNL_APP;table sea.R_TMNL_COLL_MET_REG;table sea.R_TMNL_DEBUG;table sea.R_TMNL_INFO;table sea.R_TMNL_INST_SCHEME;table sea.R_TMNL_IR;table sea.R_TMNL_IR_TASK;table sea.R_TMNL_MAINT;table sea.R_TMNL_MAINT_PLAN;table sea.R_TMNL_MISSING_MARK;table sea.R_TMNL_RUN;table sea.R_TMNL_RUN_VER;table sea.R_TMNL_SEACH_METER;table sea.R_USER_GROUP;table sea.R_TMNL;table sea.READ_FAIL;table sea.R_METER_TMNL_TG_RELA;table sea.R_USER_GROUP_DETAIL;table sea.UPGRADE_BLOCK_INFO;table sea.UPGRADE_FILE_INFO;table sea.UPGRADE_PROGRESS_INFO;table sea.UPGRADE_PROGRESS_INFO_HIST;table sea.I_BUSI_STOP_CTRL;table sea.I_CONS_STAT_D;table sea.I_ERROR_LOG;table sea.I_FEECTRL_LOG;table sea.I_FLOW_PROCESS;table sea.I_INTERFACE_LOG;table sea.I_MET_AUDIT_STATUS;table sea.I_MET_AUDIT_STATUS_HIS;table sea.I_MET_CTRL_AUDIT;table sea.I_MET_CTRL_LOG;table sea.I_MET_CTRL_STATUS;table sea.I_MET_CTRL_STATUS_HIS;table sea.I_MET_ERATE;table sea.I_MET_LADDERFEE;table sea.I_MET_OTHERPARAM;table sea.I_MET_PARAM;table sea.I_MET_TIMESLICE_TAB;table sea.I_MET_TIMEZONE;table sea.I_MET_WEEK_HOLIDAY;table sea.I_METER_FEE_TASK;table sea.I_METER_READ;table sea.I_PREPAY_CTRL;table sea.I_PUB_CONFIG;table sea.I_PUB_DETAIL;table sea.I_PUB_ERR_LOG;table sea.I_PUB_LOG;table sea.I_PUB_SCHEMA;table sea.I_PUB_SOURCE;table sea.I_QUARTZ_LOG;table sea.I_SCHEME;table sea.I_SCHEME_DET;table sea.I_TMNL_DEBUG;table sea.I_TMNL_PROT_SEND_SETUP;table sea.I_TMNL_TASK;table sea.I_TMNL_TASK_SETUP;table sea.JK_O_ORG;table sea.JK_YCTDXX_TEST;table sea.JLPT_TMNL_ONLINE_LIST;table sea.JXPBS_SEA_RELA;table sea.R_AR_DATA;table sea.R_AR_DATA_JX;table sea.R_AR_DATA_LOG160;table sea.R_AR_DATA_SYN;table sea.R_AR_DATA160;table sea.I_MASK_TMNL_FACTORY;table sea.I_TMNL_TASK_SR;table sea.G_CHKUNIT;table sea.G_CHKUNIT_COMP;table sea.G_CHKUNIT_LINK_RELA;table sea.G_CHKUNIT_REF_IDX;table sea.G_IO_MP;table sea.F_APP_REG;table sea.F_EVENT_CLOSE;table sea.F_EVENT_FLOW;table sea.F_EVENT_SHIELD;table sea.F_EVENT_SRC;table sea.F_FLOW_APP;table sea.F_FLOW_EXCEPTION;table sea.F_FLOW_SHIELD_CYC;table sea.F_FQA_KNOWLEDGE;table sea.F_FQA_NEWS;table sea.F_FQA_NEWSCOMMENT;table sea.F_SYS_DEV_EXCEPT;table sea.FC_GC_AGREEMENT_RELA;table sea.FC_GC_AGREEMENT_RELA;table sea.FC_GC_CONTACT_RELA;table sea.FC_GC_CONTACT_RELA;table sea.LACK_METER_DET;table sea.LACK_TEMPLATE_ID_DET;table sea.LS_TAB_COL;table sea.LS_TAB_PARTITION;table sea.LS_TB_COL;table sea.PLAN_TABLE;table sea.SCADA_ACLINE;table sea.SCADA_ACLINEDOT;table sea.SCADA_BUSBAR;table sea.SCADA_CONS_RELA;table sea.SCADA_DATA_INS_CFG;table sea.SCADA_ORG;table sea.SCADA_ORG_LOAD_CFG;table sea.SCADA_SUBS;table sea.SCADA_TRAN;table sea.SCADA_TRAN_WINDING;table