goldengate oracle 安裝手冊(cè).doc

*Oracle goldengate安裝手冊(cè)公司Oracle Goldengate安裝手冊(cè) 提交日期:2014年10月 版本號(hào):v1.0文檔控制變更記錄 27日期作者版本號(hào)變更參考文件2020-3-2姚書懷V1.0審閱姓名職位發(fā)行拷貝號(hào)姓名地址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)有限公司（以下簡(jiǎn)稱：Oracle公司）向免費(fèi)提供，其內(nèi)容專供江西用于評(píng)估Oracle公司為其提供產(chǎn)品及服務(wù)的能力，僅供參考。本文件所包含的信息所有權(quán)屬于Oracle公司。由于本文件包含Oracle公司保密資料，因此要求貴公司在收到本文件后三年內(nèi)應(yīng)為Oracle公司保密；除非根據(jù)法律要求，不得出于除本項(xiàng)目評(píng)估之外的任何目的，以任何形式向任何第三方提供本文件內(nèi)容；并同意采取所有合理的步驟，保證其接觸本文件的人員不對(duì)外披露或散布本文件內(nèi)容。 本文件的內(nèi)容將可能且應(yīng)該根據(jù)的具體實(shí)施情況及階段的變化而變化。 本文件對(duì)硬件規(guī)格、型號(hào)、性能的分析與估計(jì)并沒有考慮操作系統(tǒng)、網(wǎng)絡(luò)資源或任何其它在同一服務(wù)器上運(yùn)轉(zhuǎn)的應(yīng)用軟件對(duì)硬件的消耗。具體的硬件配備必須根據(jù)硬件廠商的推薦來(lái)決定。對(duì)本項(xiàng)目硬件最終選擇的決定權(quán)應(yīng)由客戶掌握。本文件中對(duì)硬件規(guī)格的估計(jì)也不對(duì)客戶形成任何具有約束性質(zhì)的陳述或擔(dān)保。請(qǐng)注意：如果您不同意上述聲明，請(qǐng)不要閱讀本文件，并立即將其返還給Oracle公司；否則，Oracle公司將視為您接受并同意遵守上述聲明。目錄1環(huán)境信息52Goldengate安裝說(shuō)明62.1 總體說(shuō)明62.2 GG軟件的安裝（源和目標(biāo)系統(tǒng)均需要安裝）62.3 開啟數(shù)據(jù)庫(kù)附加日志62.4 關(guān)閉數(shù)據(jù)庫(kù)的recyclebin (僅實(shí)施DDL時(shí)進(jìn)行配置)72.5 配置定義文件72.6 添加環(huán)境變量82.7 編輯GLOBALS參數(shù)文件82.8 建立OGG的DDL對(duì)象82.9 建立OGG進(jìn)程和隊(duì)列92.10 數(shù)據(jù)初始化142.11 目標(biāo)庫(kù)disable相關(guān)對(duì)象142.12 目標(biāo)配置replicat進(jìn)程并追加增量數(shù)據(jù)（在目標(biāo)庫(kù)完成重構(gòu)后）151 環(huán)境信息以下為復(fù)制相關(guān)的環(huán)境信息說(shuō)明（根據(jù)用戶實(shí)際環(huán)境填寫）：源端目標(biāo)端1目標(biāo)端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ù)庫(kù)版本Oracle Oracle Oracle 是否RAC否否否IP地址356Oracle SIDOrclOrclOrcl是否ASMNoNoGG版本V.16V.16V.26GG安裝所在用戶OracleOracleOracleGG安裝所在主機(jī)單機(jī)單機(jī)單機(jī)GG安裝路徑/home/ogg/home/ogg/home/oggGoldengate數(shù)據(jù)庫(kù)用戶和表空間Ogg/oggOgg/oggOgg/ogg復(fù)制的用戶范圍MPIAGA ，MPIAGM ，MMSG用戶下所有表，復(fù)制到目標(biāo)的對(duì)應(yīng)用戶同名對(duì)象中。特別說(shuō)明部分表需要進(jìn)行轉(zhuǎn)換2 Goldengate安裝說(shuō)明2.1 總體說(shuō)明Goldengate軟件目錄的屬主為oracle:dba，權(quán)限為775;Goldengate目錄一般是建立在共享存儲(chǔ)上，這樣實(shí)際上goldengate的軟件和相應(yīng)的文件如參數(shù)文件，隊(duì)列文件等都是在共享存儲(chǔ)上的。這樣做的好處是，例如在RAC環(huán)境下，如果一臺(tái)服務(wù)區(qū)宕機(jī)，則可以將$GG_HOME mount到另外一個(gè)正常的rac節(jié)點(diǎn)上，啟動(dòng)goldengate各個(gè)進(jìn)程就可以了，不需要做任何其他的動(dòng)作;本次測(cè)試過程是部署在gpfs文件系統(tǒng)上。2.2 GG軟件的安裝（源和目標(biāo)系統(tǒng)均需要安裝）1) 使用Oracle用戶（如非此用戶，請(qǐng)自行取代，下同）通過ftp上傳GGS軟件到安裝目錄下并解壓縮：tar zxvf *.gz或者分兩步解壓：gunzip *.gz 或 gzip d *.gztar xvf *.gz2) 在/goldengate目錄下運(yùn)行GGS命令行控制界面：./ggsci3) 在GGS命令行界面下創(chuàng)建子目錄：GGSCI create subdirs2.3 開啟數(shù)據(jù)庫(kù)附加日志1）檢查附加日志情況使用以下sql語(yǔ)句檢查數(shù)據(jù)庫(kù)附加日志的打開狀況: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ù)庫(kù)附加日志打開附加日志并切換日志（保證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）打開表級(jí)附加日志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屬性要檢查所有要復(fù)制的表都有屬性LOGGING，樣例語(yǔ)句如下：SELECT OWNER, TABLE_NAME FROM DBA_TABLES WHERE LOGGING = NO AND OWNER=SEA;對(duì)LOGGING = NO的表執(zhí)行：ALTER TABLE . LOGGING;5）檢查compression屬性要檢查所有要復(fù)制的表都沒有屬性compression，樣例語(yǔ)句如下：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 關(guān)閉數(shù)據(jù)庫(kù)的recyclebin (僅實(shí)施DDL時(shí)進(jìn)行配置)查詢當(dāng)前recyclebin的參數(shù)值：SQL show parameter recyclebinNAME TYPE VALUE- - -recyclebin string OFFSQL如不是off，需要關(guān)閉recyclebin：SQLalter system set recyclebin=off scope=both;如果需要回退，打開recyclebin的話，可以使用以下語(yǔ)句：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目標(biāo)端：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 -指定的進(jìn)行DDL復(fù)制的數(shù)據(jù)庫(kù)用戶2.8 建立OGG的DDL對(duì)象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.注意這里的提示：需要手工將這個(gè)GGS_GGSUSER_ROLE指定給extract所使用的數(shù)據(jù)庫(kù)用戶（即參數(shù)文件里面通過userid指定的用戶），可以到sqlplus下執(zhí)行類似的sql:GRANT GGS_GGSUSER_ROLE TO goldengate;注：這里的goldengate是extract使用的用戶。如果你有多個(gè)extract，使用不同的數(shù)據(jù)庫(kù)用戶，則需要重述以上過程全部賦予GGS_GGSUSER_ROLE權(quán)限。運(yùn)行以下腳本，使觸發(fā)器生效SQL ddl_enable.sql安裝提升性能工具：本步驟為可選步驟，一般情況下建議運(yùn)行該步驟。為了提供OGG的DDL復(fù)制的性能，可以將ddl_pin腳本加入到數(shù)據(jù)庫(kù)啟動(dòng)的腳本后面，該腳本需要帶一個(gè)OGG的DDL用戶（即安裝DDL對(duì)象的用戶，本例中是goldengate）的參數(shù):SQL ddl_pin 注：如果因?yàn)闃I(yè)務(wù)問題，開啟DDL以后，對(duì)性能的影響比較大的話，需要臨時(shí)禁用DDL觸發(fā)器的話，可以運(yùn)行以下語(yǔ)句：SQL ddl_disable.sql 因?yàn)槟壳耙箨P(guān)閉DDL復(fù)制，所以執(zhí)行ddl_disable2.9 同步sequence (僅實(shí)施sequence同步時(shí)進(jìn)行配置)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進(jìn)程和隊(duì)列（1） MGR參數(shù)和進(jìn)程（源和目標(biāo)均需要配置）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 -目標(biāo)端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配置完成后，源和目標(biāo)均啟動(dòng)：ggsci start mgr（2） 源端配置extract和pump進(jìn)程（根據(jù)用戶實(shí)際環(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