1.mali环境
1.1 用户还原
107服务器的bmp还原
rm –rf malibmp;
gunzip –cvf malibmp.tar.gz | tar –xvf -;
108服务器的cbp和scp还原
stop_enip.sh和kill -9
rm –rf malicbp;
rm –rf maliscp;
rm –rf malismdb;
gunzip –cvf malicbp.tar.gz | tar –xvf -;
gunzip –cvf maliscp.tar.gz | tar –xvf -;
gunzip –cvf malismdb.tar.gz | tar –xvf -;
232服务器的cbp和scp还原
rm -rf cbpml;
rm –rf scuml;
rm –rf smdbml;
gunzip –cvf cbpml.tar.gz | tar –xvf -;
gunzip –cvf scuml.tar.gz | tar –xvf -;
gunzip –cvf smdbml.tar.gz | tar –xvf -;
105 的数据库
SQL> select username from dba_users where username like '%MALI%';
USERNAME
------------------------------
MALISCP
MALICDB
MALIUDB
MALISDB
1.2.数据库还原
1.2.1查看ORCLE用户:
select username from dba_users where username like '%ML%';
1.2.2 数据库用户修改
alter user malisdb identified by sysdb74;
alter user maliudb identified by maliudb2;
alter user malicdb identified by cbpdb74;
alter user maliscp identified by scpdb74;
alter user cbpdbml1 identified by smpdb74;
alter user ops$scuml identified by smpdb74;
1.2.3 数据库用户的删除
drop user malisdb cascade;
drop user maliudb cascade;
drop user malicdb cascade;
drop user maliscp cascade;
drop user ops$scuml cascade;
drop user cbpdbml1 cascade;
1.2.4 创建用户
create user malisdb identified by malisdb default tablespace CBS_DEFAULT_DAT temporary tablespace "TEMP";
grant dba,connect,resource to malisdb;
grant select any dictionary to malisdb;
grant create any sequence to malisdb;
grant create any table to malisdb;
grant create any procedure to malisdb;
grant create any trigger to malisdb;
grant create session to malisdb;
grant create sequence to malisdb;
grant create table to malisdb;
grant create procedure to malisdb;
grant create trigger to malisdb;
create user maliudb identified by maliudb default tablespace CBS_USER_DAT temporary tablespace "TEMP";
grant dba,connect,resource to maliudb;
grant select any dictionary to maliudb;
grant create any sequence to maliudb;
grant create any table to maliudb;
grant create any procedure to maliudb;
grant create any trigger to maliudb;
grant create session to maliudb;
grant create sequence to maliudb;
grant create table to maliudb;
grant create procedure to maliudb;
grant create trigger to maliudb;
create user malicdb identified by malicdb default tablespace CBP_WORKDBS temporary tablespace "TEMP";
grant dba,connect,resource to malicdb;
grant select any dictionary to malicdb;
grant create any sequence to malicdb;
grant create any table to malicdb;
grant create any procedure to malicdb;
grant create any trigger to malicdb;
grant create session to malicdb;
grant create sequence to malicdb;
grant create table to malicdb;
grant create procedure to malicdb;
grant create trigger to malicdb;
create user maliscp identified by maliscp default tablespace SCUDATATBS temporary tablespace "TEMP";
grant dba,connect,resource to maliscp;
grant select any dictionary to maliscp;
grant create any sequence to maliscp;
grant create any table to maliscp;
grant create any procedure to maliscp;
grant create any trigger to maliscp;
grant create session to maliscp;
grant create sequence to maliscp;
grant create table to maliscp;
grant create procedure to maliscp;
grant create trigger to maliscp;
create user ops$scuml identified by scuml default tablespace CBS_DEFAULT_DAT temporary tablespace "TEMP";
grant dba,connect,resource to ops$scuml;
grant select any dictionary to ops$scuml;
grant create any sequence to ops$scuml;
grant create any table to ops$scuml;
grant create any procedure to ops$scuml;
grant create any trigger to ops$scuml;
grant create session to ops$scuml;
grant create sequence to ops$scuml;
grant create table to ops$scuml;
grant create procedure to ops$scuml;
grant create trigger to ops$scuml;
create user cbpdbml1 identified by cbpdbml1 default tablespace SMPDATATBS temporary tablespace "TEMP";
grant dba,connect,resource to cbpdbml1;
grant select any dictionary to cbpdbml1;
grant create any sequence to cbpdbml1;
grant create any table to cbpdbml1;
grant create any procedure to cbpdbml1;
grant create any trigger to cbpdbml1;
grant create session to cbpdbml1;
grant create sequence to cbpdbml1;
grant create table to cbpdbml1;
grant create procedure to cbpdbml1;
grant create trigger to cbpdbml1;
1.2.5 用户解锁操作
alter user ops$scuml account unlock;
alter user cbpdbml1 account unlock;
alter user maliscp account unlock;
alter user maliscp account unlock;
alter user zbaudb02 account unlock;
1.2.6 导入数据
imp malisdb/malisdb fromuser=malisdb touser=malisdb rows=y commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=malisdb_LG0222.dmp;
imp maliudb/maliudb fromuser=maliudb touser=maliudb rows=y commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=maliudb_LG0222.dmp;
imp malicdb/malicdb fromuser=malicdb touser=malicdb rows=y commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=malicdb_LG0222.dmp;
imp maliscp/maliscp fromuser=maliscp touser=maliscp rows=y commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file= maliscu_LG0222.dmp;
imp cbpdbml1/cbpdbml1 fromuser=cbpdbml1 touser=cbpdbml1 rows=y commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=cbpdbml_LG0222.dmp;
imp 'ops$scuml'/scuml fromuser='ops$scuml' touser='ops$scuml' rows=y commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=scuml_LG0222.dmp;
1.2.7 内存卡重构不了就还原
1.内存库的重构
1.以smdb99身份登录到208服务器。
2.重建内存库,命令:mdauto.sh。
3.同步所有表,命令:SynMemDB –d(同步表完成,同步成功表个数:422,同步失败表个数:1表[OCS_QCTDEFINE] 同步失败)
4.同步所有的表,命令:all
5.退出同步,命令:q
2.还原内存库
mdimport -i
1.3 开启服务
1.3.1手动启动CBP
idagent idcenter icdcomm idlproxy namingDaemon configDaemon 最后起c 0
1.3.2 手动停止CBP
stop_enip.sh和kill -9
开户激活成功,现在可以把bmp cbp scp smdb密码都改成huawei123,停止服务。
1.4 数据库的导入导出
1.4.1 查询当前用户有哪些表
-- 查询你 当前用户下,有哪些表
SELECT count(*) FROM user_tables;
1.4.2 数据的导入和导出
exp 'ops$zbascp/zbascp@ora11g' tables=OCS_ONNETANALYZE, OCS_PASSBYCODELIST, OCS_RECHARGEAUTH, OCS_RECHARGEMEAUTH, OCS_RECHRGBNFLOG, OCS_RNTOAREACODE, OCS_ROAMCALLCTRL, OCS_SCPFEIDCFG, OCS_SCPFEIDCFG_BAK, OCS_SMCODINGTYPE, OCS_SWITCHPERIOD, OCS_SWITCHPERIOD_20111123, OCS_TARIFFFORQUERY, OCS_VLRTONETWORK, OUTBOUNDDATA, OUTBOUNDSCUTAB, PAIRSEXCEPTIO1, PAIRSEXCEPTION, PHYDISTTAB, PREFIXANALYSISTAB, SCCPGTINFO, SCCPGTINFOSELECT, SCPSERVICEKEY, SCUSYSTBLVERSION, SDDTABLE, SIPKEY, SIPMSGLOCATION, SPECIALCOD1, SPECIALCODE, SSPCONFI1, SSPCONFIG, SSPIPINFO, SYNCSQLLOG, TARIFFFORQUERYBAK0524, TASAMOBILEI1, TASAMOBILEID, TERMTYPECHGINDE1, TERMTYPECHGINDEX, TERMTYPEMATRI1, TERMTYPEMATRIX, TIMEDI1, TIMEDIS, TOLLCHARGECLAS1, TOLLCHARGECLASS, TRIGGERSERVICEKEY, USSDSERVICEKEY, UVS_EXCHGANALYZE, UVS_LASTCALLCOST, U_UVS_ATTACHED, U_UVS_ATTACHEDBAK, U_UVS_BASETAB, U_UVS_BASETABBAK, U_UVS_BASETABBAK_BACK0518, U_UVS_BASETAB_BACK0518, VERSIONCTRL, VERSIONCTRLBT, VOICEMESSAGE, VOLUMECHARGEMOD1, VOLUMECHARGEMODE, WEEKDISCOUN1, WEEKDISCOUNT, W_UVS_AIPINFO, W_UVS_AREATOTZONE, W_UVS_ATTENDANT, W_UVS_BCALLPROMPT, W_UVS_BMERESULT, W_UVS_BMERESULTMAP, W_UVS_BRDTOSMSID, W_UVS_CACTOCAC, W_UVS_CALLLENGTH, W_UVS_CALLNOTIFY, W_UVS_CALLSCREEN, W_UVS_CARDSEQPREF, W_UVS_CARDSEQTOVC, W_UVS_CARDTOSDP, W_UVS_CBERESULTMAP, W_UVS_CELLTOAREANO, W_UVS_CHARGEVNTSMS, W_UVS_CHGBLACKLST, W_UVS_CLGCATEGORY, W_UVS_CLI, W_UVS_COMMNTYMENU, W_UVS_COMMNTYMENU_LG0216, W_UVS_COMMNTYMENU_LG0216_BAK, W_UVS_DETECTION, W_UVS_EVCCARDLIST, W_UVS_FAVORITEAREA, W_UVS_FNPACKAGE, W_UVS_GROUP, W_UVS_GROUPOUTNO, W_UVS_GRPATTEND, W_UVS_GRPSCREEN, W_UVS_HROUTINGINFO, W_UVS_HUNTINGLIST, W_UVS_HUNTINGNO, W_UVS_ICFNUMBER, W_UVS_INTERPREFIX, W_UVS_ISDNTOAIP, W_UVS_ISDNTOSCP, W_UVS_ISDNTOSIP, W_UVS_LANGTYPE, W_UVS_LASTINFO, W_UVS_LASTZONEINFO, W_UVS_LOANSUPPLIED, W_UVS_MANAGELOG, W_UVS_MAPSMS, W_UVS_MAXCALLDRLST, W_UVS_MCCTOCC, W_UVS_MCNDATA, W_UVS_MESSAGE, W_UVS_MSCABILITY, W_UVS_NPDATA, W_UVS_NUMBERCHANGE, W_UVS_PACKAGESET, W_UVS_PARENTCHILD, W_UVS_PHONE, W_UVS_PREIPPREFIX, W_UVS_QUYSPEACCT, W_UVS_RCOMMRESULT, W_UVS_RECHGMATCH1, W_UVS_RECHGMATCH2, W_UVS_RECHGSERVICE, W_UVS_SCPCONFIG, W_UVS_SCREENEXT, W_UVS_SERVICE, W_UVS_SERVICETYPE, W_UVS_SERVICE_E2ELG0217, W_UVS_SIPNET2OPR, W_UVS_SIPVOICECFG, W_UVS_SPECCONFIG, W_UVS_SPECNUMBER, W_UVS_STPADDRESS, W_UVS_SUBSRVCEKEY, W_UVS_SUBSTATROUTE, W_UVS_SUPERGROUP, W_UVS_SWITCHMPACKG, W_UVS_SWITCHSUBCOS, W_UVS_SYSTEMINFO, W_UVS_TRACENUMBER, W_UVS_TRANSANALYZE, W_UVS_TRANSSUPPLY, W_UVS_UCBBLACKLIST, W_UVS_UCBGATEWAY, W_UVS_UCBIMSILIMIT, W_UVS_USSDSWITCHCS, W_UVS_VCCODE, W_UVS_VOICECONFIG, W_UVS_VOICEMENU file=out.dmp
imp maliscp/maliscp@maliscpdb file=out.dmp full=y
exp 'ops$zbascp/zbascp@ora11g' tables=U_UVS_BASETAB file=basetab.dmp
imp maliscp/maliscp@maliscpdb file=basetab.dmp full=y
exp maliscp/maliscp@ora105 tables=OCS_ONNETANALYZE,OCS_PASSBYCODELIST,OCS_RECHARGEAUTH,OCS_RECHARGEMEAUTH,OCS_RECHRGBNFLOG,OCS_RNTOAREACODE,OCS_ROAMCALLCTRL,OCS_SCPFEIDCFG,OCS_SCPFEIDCFG_BAK,OCS_SMCODINGTYPE,OCS_SWITCHPERIOD,OCS_SWITCHPERIOD_20111123,OCS_TARIFFFORQUERY,OCS_VLRTONETWORK,OUTBOUNDDATA,OUTBOUNDSCUTAB,PAIRSEXCEPTIO1,PAIRSEXCEPTION,PHYDISTTAB,PREFIXANALYSISTAB,SCCPGTINFO,SCCPGTINFOSELECT,SCPSERVICEKEY,SCUSYSTBLVERSION,SDDTABLE,SIPKEY,SIPMSGLOCATION,SPECIALCOD1,SPECIALCODE,SSPCONFI1,SSPCONFIG,SSPIPINFO,SYNCSQLLOG,TASAMOBILEI1,TASAMOBILEID,TERMTYPECHGINDE1,TERMTYPECHGINDEX,TERMTYPEMATRI1,TERMTYPEMATRIX,TIMEDI1,TIMEDIS,TOLLCHARGECLAS1,TOLLCHARGECLASS,TRIGGERSERVICEKEY,U_UVS_ATTACHED,U_UVS_ATTACHEDBAK,U_UVS_BASETAB,U_UVS_BASETABBAK,USSDSERVICEKEY,UVS_EXCHGANALYZE,UVS_FPHCALLERLIST,UVS_LASTCALLCOST,VERSIONCTRL,VERSIONCTRLBT,VOICEMESSAGE,VOLUMECHARGEMOD1,VOLUMECHARGEMODE,W_UVS_AIPINFO,W_UVS_AREATOTZONE,W_UVS_ATTENDANT,W_UVS_BCALLPROMPT,W_UVS_BMERESULT,W_UVS_BMERESULT_E2ELG0218,W_UVS_BMERESULTMAP,W_UVS_BRDTOSMSID,W_UVS_CACTOCAC,W_UVS_CALLLENGTH,W_UVS_CALLNOTIFY,W_UVS_CALLSCREEN,W_UVS_CARDSEQPREF,W_UVS_CARDSEQTOVC,W_UVS_CARDTOSDP,W_UVS_CBERESULTMAP,W_UVS_CELLTOAREANO,W_UVS_CHARGEVNTSMS,W_UVS_CHGBLACKLST,W_UVS_CLGCATEGORY,W_UVS_CLI,W_UVS_COMMNTYMENU,W_UVS_COMMNTYMENU_E2ELG0218,W_UVS_COMMNTYMENU_LG0216,W_UVS_DETECTION,W_UVS_EVCCARDLIST,W_UVS_FAVORITEAREA,W_UVS_FNPACKAGE,W_UVS_GROUP,W_UVS_GROUPOUTNO,W_UVS_GRPATTEND,W_UVS_GRPSCREEN,W_UVS_HROUTINGINFO,W_UVS_HUNTINGLIST,W_UVS_HUNTINGNO,W_UVS_ICFNUMBER,W_UVS_INTERPREFIX,W_UVS_ISDNTOAIP,W_UVS_ISDNTOSCP,W_UVS_ISDNTOSIP,W_UVS_LANGTYPE,W_UVS_LASTINFO,W_UVS_LASTZONEINFO,W_UVS_LOANSUPPLIED,W_UVS_MANAGELOG,W_UVS_MAPSMS,W_UVS_MAXCALLDRLST,W_UVS_MCCTOCC,W_UVS_MCNDATA,W_UVS_MESSAGE,W_UVS_MESSAGE_E2ELG0218,W_UVS_MSCABILITY,W_UVS_NPDATA,W_UVS_NUMBERCHANGE,W_UVS_PACKAGESET,W_UVS_PACKAGESET_20111020,W_UVS_PARENTCHILD,W_UVS_PHONE,W_UVS_PREIPPREFIX,W_UVS_QUYSPEACCT,W_UVS_RCOMMRESULT,W_UVS_RECHGMATCH1,W_UVS_RECHGMATCH2,W_UVS_RECHGSERVICE,W_UVS_SCPCONFIG,W_UVS_SCREENEXT,W_UVS_SERVICE,W_UVS_SERVICETYPE,W_UVS_SIPNET2OPR,W_UVS_SIPVOICECFG,W_UVS_SPECCONFIG,W_UVS_SPECNUMBER,W_UVS_STPADDRESS,W_UVS_SUBSRVCEKEY,W_UVS_SUBSTATROUTE,W_UVS_SUPERGROUP,W_UVS_SWITCHMPACKG,W_UVS_SWITCHSUBCOS,W_UVS_SYSTEMINFO,W_UVS_SYSTEMINFO_E2ELG0217,W_UVS_TRACENUMBER,W_UVS_TRANSANALYZE,W_UVS_TRANSSUPPLY,W_UVS_UCBBLACKLIST,W_UVS_UCBGATEWAY,W_UVS_UCBIMSILIMIT,W_UVS_USSDSWITCHCS,W_UVS_VCCODE,W_UVS_VOICECONFIG,W_UVS_VOICEMENU,WEEKDISCOUN1,WEEKDISCOUNT file=out.dmp
imp 'ops$scuml'/scuml file=out.dmp full=y
exp zbasdb/zbasdb@zbasdb tables=w_uvs_service,ts_brand file=out.dmp
imp zbasdb/zbasdb@zbasdb file=out.dmp full=y
1.5 数据库的备份
exp malisdb/malisdb owner=malisdb rows=y compress=n buffer=65536 feedback=100000 volsize=0 file= malisdb_LG0222.dmp;
exp maliudb/maliudb owner =maliudb rows=y compress=n buffer=65536 feedback=100000 volsize=0 file=maliudb_LG0222.dmp;
exp malicdb/malicdb owner =malicdb rows=y compress=n buffer=65536 feedback=100000 volsize=0 file=malicdb_LG0222.dmp;
exp maliscp/maliscp owner =maliscp rows=y compress=n buffer=65536 feedback=100000 volsize=0 file= maliscu_LG0222.dmp;
exp cbpdbml1/cbpdbml1 owner =cbpdbml1 rows=y compress=n buffer=65536 feedback=100000 volsize=0 file=cbpdbml1_LG0222.dmp;
exp 'ops$scuml'/scuml owner ='ops$scuml' rows=y compress=n buffer=65536 feedback=100000 volsize=0 file=scuml_LG0222.dmp;
1.6 用户的备份
tar -cvf malibmp.tar malibmp;
gzip malibmp.tar;
tar -cvf malicbp.tar malicbp;
gzip malicbp.tar;
tar -cvf malismdb.tar malismdb;
gzip malismdb.tar;
tar -cvf maliscp.tar maliscp;
gzip maliscp.tar;
tar -cvf cbpml.tar cbpml;
gzip cbpml.tar;
tar -cvf scuml.tar scuml;
gzip scuml.tar;
tar -cvf smdbml.tar smdbml;
gzip smdbml.tar;