环境的还原和备份操作

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;