TSM备份oracle数据库安装配置

1、TSM5.5备份和恢复Oracle11gR2IBMTivoliStorageManagerforDatabasesDataProtectionforOracle,以下简称：TDPO1、安装TDPO1.1、 软件选择tivoli.tsm.client.api.32bittivoli.tsm.client.api.64bittivoli.tsm.client.oracle.aix.64bittivoli.tsm.client.oracle.tools.aix.64bittivoli.tsm.loc.client.oracle.aix.64bit.ela1.2、 软件安装1.2.1、 将所有需要安装

2、的文件集上传到效劳器上，假设上传到/tmp/soft/tsm/oracle目录。1.2.2、 进入软件集目录，然后执行安装命令：bash-3.2#cd/tmp/soft/tsm/oraclebash-3.2#smittyinstallInstallandUpdateSoftwareInstallandUpdatefromALLAvailableSoftware在*INPUTdevice/directoryforsoftware中输入./SOFTWAREtoinstall中输入allACCEPTnewlicenseagreements选项中no改为yes然后按回车键安装，再按回车键确认后，软件安

3、装完成。2、将RMAN与TDPO重新a、设置OracleLD_LIBRARY_PATH选项选项第一位，即:修改.proflie文件,将$ORACLE_HOME/lib放在LD_LIBRARY_PATHLD_LIBRARY_PATH=$ORACLE_HOME/libb、关闭使用$ORACLE_HOME的所有Oracle实例c、转至$ORACLE_HOME目录d、将库文件符号连接到libobk.aln-s/usr/lib/libobk64.a$ORACLE_HOME/lib/libobk.a3、定义tdpo.opt文件中的TDPO选项bash-3.2#cd/usr/tivoli/tsm/clien

4、t/oracle/bin64bash-3.2#vitdpo.optDSMI_ORC_CONFIG/usr/tivoli/tsm/client/oracle/bin64/dsm.optDSMI_LOG/usr/tivoli/tsm/client/oracle/bin64db01 oraTDPOFSTDPO NODEdb01 oracleTDPO_OWNERTDPO_PSWDPATHoracle/usr/tivoli/tsm/client/oracle/bin64TDPO_DATE_FMT1TDPO_NUM_FMT1TDPO_TIME_FMT14、将TDPO节点注册到TSM效劳器registern

5、odedb01_oraclepasswordmaxnummp=2passexp=0backdelete=yes5、在dsm.opt和dsm.sys文件中定义TSM选项5.1、 配置dsm.optbash-3.2#cd/usr/tivoli/tsm/client/oracle/bin64bash-3.2#vidsm.optSErvernametsmserver注意：此文件必须位于tdpo.opt中的dsmi_orc_config指定的目录中。5.2、 配置dsm.sysbash-3.2#cd/usr/tivoli/tsm/client/api/bin64bash-3.2#vidsm.sysSEr

6、vernametsmserverMMethodTCPipTCPPort1500TCPServeraddress6NODEnamedb01_oraclePASSWORDAccessprompt6、修改TSMAPI和TDPO目录的权限bash-3.2#chmod-R777/usr/tivoli/tsm/client/api/bin64/bash-3.2#chmod-R777/usr/tivoli/tsm/client/oracle/bin64/6、配置TSM效劳器6.1、 定义策略域tsm:TSMSERVER>definedomainoradomainANR1500IP

7、olicydomainORADOMAINdefined.6.2、 定义策略tsm:TSMSERVER>definepoloradomainorapolANR1510IPolicysetORAPOLdefinedinpolicydomainORADOMAIN.6.3、 定义管理类tsm:TSMSERVER>definemgmtoradomainorapoloramgmtANR1520IManagementclassORAMGMTdefinedinpolicydomainORADOMAIN,setORAPOL.6.4、 指派缺省管理类tsm:TSMSERVER>assigndef

8、mgmtoradomainorapoloramgmtANR1538IDefaultmanagementclasssettoORAMGMTforpolicydomainORADOMAIN,setORAPOL.6.5、 定义存储池tsm:TSMSERVER>definestgpoolorapooldiskANR2200IStoragepoolORAPOOLdefined(deviceclassDISK).6.6、 定义存储池卷tsm:TSMSERVER>definevolumeorapool/tsm1/ora.dsmformatsize=512wait=yesANR0984IProce

9、ss9forDEFINEVOLUMEstartedintheFOREGROUNDat12:19:20.ANR2206IVolume/tsm1/ora.dsmdefinedinstoragepoolORAPOOL(deviceclassDISK).ANR0986IProcess9forDEFINEVOLUMErunningintheFOREGROUNDprocessed1itemsforatotalof536,870,912byteswithapletionstateofSUCCESSat12:19:26.6.7、 定义存储池空间触发器tsm:TSMSERVER>definespacetr

10、iggerstgstgpool=orapoolspaceexpansion=50expansionprefix=/tsm1/ANR4485IAstoragepoolspacetriggerhasbeendefinedandenabledforstoragepoolORAPOOL.6.8、 定义副本组tsm:TSMSERVER>definecopyoradomainorapoloramgmtdest=orapoolverdeleted=0retonly=0SessionestablishedwithserverTSMSERVER:AIX-RS/6000ServerVersion5,Rele

11、ase5,Level4.0Serverdate/time:09/03/1012:58:21Lastaccess:09/03/1012:14:15ANR1530IBackupcopygroupSTANDARDdefinedinpolicydomainORADOMAIN,setORAPOL,managementclassORAMGMT.6.9、 激活备份策略ANR1554WDEFAULTManagementclassORAMGMTinpolicysetORADOMAINORAPOLdoesnothaveanARCHIVEcopygroup:fileswillnotbearchivedbydefau

12、ltifthissetisactivated.Doyouwishtoproceed?(Yes(Y)/No(N)yANR1554WDEFAULTManagementclassORAMGMTinpolicysetORADOMAINORAPOLdoesnothaveanARCHIVEcopygroup:fileswillnotbearchivedbydefaultifthissetisactivated.ANR1514IPolicysetORAPOLactivatedinpolicydomainORADOMAIN.6.10、 更新客户端节点信息tsm:TSMSERVER>updatenoded

13、b01_oracledomain=oradomainANR2063INodeDB01_ORACLEupdated.注：将节点db01_oracle的策略域改为oradomain.7、修改TDPO节点密码bash-3.2#cd/usr/tivoli/tsm/client/oracle/bin64/bash-3.2#tdpoconfpassword8、查看TDOP配置信息bash-3.2#cd/usr/tivoli/tsm/client/oracle/bin64/bash-3.2#tdpoconfShowenvironment|IBMTivoliGtopag白ManagerforDatabases

14、:flitsPr'otArticnfor门ral.qVersLor5,Release包,Level1-0(C)CopyrightIBMCorporation1997,.Allrightsreserved.DataPretentionforOracLeInformitionVersion：5Reiease:4Level:1Sublevel:gPlatform:64bitTDPOracleAIKServer Information TSMSERVER 192-163.2.1 AIX-RS/6000 1500 TCP/IPTivoli5torageMngerServerName:Server

15、Address：ServerType:ServerPort：Sessi.or Inf ormaitioiiOwn er Nam*:Node Name:Node Type:DSHI_DIR:DMI_ORC_rOMFlG:TDO_OPTFILE:Password Directory:CoTipresLsn ：License Inf orrnation;ConrnurirationMaHncd:op5cledb©l_oracleTDPOracleAIX/sr/tivoli/terr/client/api/bin64/Sr/tLvoLl/ts(ri/clLctn't/oracle/b

16、i_n64，d与m.0P七/usr/tivoli/tsrp/cLient/oracLe/biri64/tdpo.cp't/usr/tivoli/tsrp/client/aracl/bin64FALSELicensefileexistsandcontainsvalidLicen5edataJ9、将数据库改为归档模式bash-3.xl#儿-oracle/home/oreclefbeShdbl:/home/oreclelscLp-LS1/assysdba'S；.*PIus：秒msiil,7.«.1,0PnodeletionpnStSep4.A4：0i：212命1总Copyn

17、ight(c)1982p200*9,OrfKlc.Allnightsreserved.Correctedto:OricLeDatabase11gErterpriseEditioiiRelease11.2,6.1T6-GJ-bLIProduct.criAllththmPnr'titionLnRmLJJppli.cati.OTClJErterit,AutomsticStaiesMar'iaement,OLEP,DataMiningard艮白siAppLicticnTe&ting0pti_ori&SQL：shutconnimmediateDatabasecLcsed+

18、Viatsbc*5edi'mourted*OFACLfitrikeshutdown.SQL>ittiPtuprrOuntJOF.JCLEin?tancestarted.1otal System GLobe_Fixed SizeVariable Size口占 t3 |】W*a FuffarRado BuffopsDez«b«s« ra(?Lnt4c.SQ L> alter satjbascDardbsie dLterec.Ared d _7814E4Hii jytes 221471> bytes 1 .S254E+10 byte5 1.9J

19、67E+1P hyta三archLvelcg;SQL>altArdatabapoppr;口白工$匕3二日sltarec-setLOG_4RCHIVE_DEST_Is'LCCilTIOM=tzgpiang/zgi>jang/achivs/'SystemalteredBSQL>shutduhiniRirnQdigtaj.口七gL口5d. at«b«sadisrrDUirt4d.ORACLELnstnc*§hutdm-in.SQL>startup FtACLFinstance5t内尸tfd.Total Sy&tem G10

20、bml flxsJ Siz« VariiibLg Size 口鼻士8口丹/m fSuffisrs mad口 Buffer'sArea3.7814E+1022147121.825JE+101b467E+1Bbytes byt« byt» byts bytsfiQf卜 iv*e HfdvEnabledfZCiAftpsJG/ zpunR/a rchi v&f日目959- atflhfl'*7f*mnjnteJPDatabaeopenedl.5QL2白腿hirel气List,Jw十3b司存曰L0.wicdeAuitonatiGarchivalar

21、chin*dpticiaition1.orilinelegsaquenceNextlegspqi.encetoarchiveCumnt:口gsequeic?5QL>exitDisconnectedfromOuacL®Datbse11gEnterpr'iseEditLonReleaB吧-64&i.tPruducticnWi"th-thePartit£dtIhe#1JSppLis司ti©口ClusteryrJJutaii3it.ii；StcrapeManspamen11DLJQP#二3士mMlni.ng,3ndRwwLjpplLecti

22、onTestinoptLnsdbei:/horrerjracletl10、测试TDPO与Oracle数据库的连接db01:/home/oracle$sbttesttestThesbtfunctionpointersareloadedfromlibobk.a(shr.o)library.-sbtinitsucceededReturncode-1fromsbtinit,bsercoer=0,bsercerrno=0Message0notfound;product=RDBMS;facility=SBT如图：db01:/home/oracLeJsbttestta&tThesbtFunction

23、pointrsareloadedfrom1Lbobk.a(shr.o)Li_brary-sbtinLteusg曰曰d曰dReturncode-1fromsbtinit,bsercoer=g,t>sercerrno=0Mees日日3notfound;product-RDBM;facility-SET显示如上，表示测试成功，如果不成功，有可能是TDPO目录或TSMAPI目录权限设置不对或者tdpo.opt文件配置错误。10、备份数据库10.1、 备份数据文件通过RMAN执行备份数据文件脚本，过程如下：db01:/home/oracle$rmanRecoveryManager:Release1

24、.0-ProductiononSatSep406:46:332010Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.RMAN>connecttargetconnectedtotargetdatabase:ZGWANG(DBID=747272013)MAN>run2>3>allocatechannelt1type'sbt_tape'parms4>'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bi

25、n64/tdpo.opt)'5>backup6>filesperset57>format'df_%t_%s_%p'8>(database);9>allocatedchannel:t1channelt1:SID=237instance=zgwang1devicetype=SBT_TAPEchannelt1:DataProtectionforOracle:versionStartingbackupat04-SEP-10channelt1:startingfulldatafilebackupsetchannelt1:specifyi

26、ngdatafile(s)inbackupsetinputdatafilefilenumber=00002name=+ZGWANG/zgwang/sysaux02.dbfinputdatafilefilenumber=00001name=+ZGWANG/zgwang/system01.dbfinputdatafilefilenumber=00003name=+ZGWANG/zgwang/undotbs103.dbfinputdatafilefilenumber=00005name=+ZGWANG/zgwang/undotbs205.dbfinputdatafilefilenumber=0000

27、4name=+ZGWANG/zgwang/users04.dbfchannelt1:startingpiece1at04-SEP-10channelt1:finishedpiece1at04-SEP-10piecehandle=df_728809085_4_1tag=TAG20100904T065805ment=APIVersion2.0,MMSVersionchannelt1:backupsetplete,elapsedtime:00:05:07channelt1:startingfulldatafilebackupsetchannelt1:specifyingdatafile

28、(s)inbackupsetincludingcurrentcontrolfileinbackupsetincludingcurrentSPFILEinbackupsetchannelt1:startingpiece1at04-SEP-10channelt1:finishedpiece1at04-SEP-10piecehandle=df_728809393_5_1tag=TAG20100904T065805ment=APIVersion2.0,MMSVersionchannelt1:backupsetplete,elapsedtime:00:02:23Finishedbackup

29、at04-SEP-10releasedchannel:t1如下列图:aLLocatd_channaL:tl-chanreLtl:5ID=237instance-ZEuang;!deviceZYpe=SbI4F匕<_hmnnwLtl;DoLaProleklionfor0rsc1e;veisLon5*4.1.©StartingbackupatW4-5EP-1Wchanneltl:5tartingfulldatafilebackupsetchflnnplirl：perj_fyingc)：nbackupqatinput dflitafLla input datafile innut d

30、tafi :2 input datafile input dfltafi-1 efile numben=00002 fLie numbei"0001 file number=&000 file numbers白色005 Fl!c number=O00iriame=+ZGIrtANG/zgiA)flirg/s¥£ciux02,dbfname-iZGIaANG/zguiiflrg/systemOl.dbfnam=+ZGlAANG/TeLjjrg/jndotbt103.cbfname=+ZGIrtANG/3Riftjanp/jndotbs205.cbfnaine

31、=+ZGlAANG7zgwarg/usersOi-dbchanneltl:startingpiece1at(h4-SFP-I0channeltl:finishedpiece1atw4-SEP-l(&piecehandle=djf_72SS99985_4_lt6g=TAG291GG994-QGS8&5csnrrnerit=AP£Version2.9rhannpl:backupsetcomplete,pIapseritime：'电臼：05:0了channeLtl:start!ngfu11datafilebackupsetchanridtl:specLfyingda

32、tjfile(c)Lrbackupsetincludingcurrentcontrol-lieinbackup=etincludinggurreritSPFILEtnbackupsetchanneltl:stantingpiece1atzG4-SEP-10channeltl:-inishedpiece1at64-SEP-10piecehfliidlrf-uf_728S09j9_5_lta目一73620工0)4飞858把corrmenL-APIVersioi2.0ehanneltl：backupsst金lipddtimai0®:&2i23l-inishadbackupat04-

33、5EP-19reLeasedchanrel.;tl10.2、 全备数据库包括spfile文件、数据文件、控制文件、归档日志文件脚本如下：#BackupDatabaseFullrmantarget/<<EOF_RMANrunallocatechannelt1type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt2type'sbt_tape'parms'ENV=(tdpo_optfile

34、=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt3type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt4type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannel

35、t5type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt6type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'backupfulltag'dbfull'format'dbfull_%t_%s_%p'diskratio=0databasein

36、cludecurrentcontrolfile;sql'altersystemarchivelogcurrent'backupformat'arch%t_%s_%p'diskratio=0archivelogalldeleteinput;releasechannelt1;releasechannelt2;releasechannelt3;releasechannelt4;releasechannelt5;releasechannelt6;EOF_RMAN#DeleteOldBackupsrman<<EOF_RMANconnecttarget;allo

37、catechannelformaintenancetype'sbt_tape'parms'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'crosscheckbackup;crosscheckarchivelogall;reportobsolete;deletenopromptobsoleterecoverywindowof90days;deletenopromptexpiredbackup;releasechannel;EOF_RMAN10.3、 增量备份数据库包括spfile文件

38、、数据文件、控制文件、归档日志文件脚本如下：#BackupDatabaseFullrmantarget/<<EOF_RMANrunallocatechannelt1type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt2type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)

39、'allocatechannelt3type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt4type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt5type'sbt_tape'parms'ENV=(tdpo_op

40、tfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'allocatechannelt6type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'backupincrementallevel1tag'dbincr'format'%d_full_%s_%p'filesperset5diskratio=0databaseincludecurrentcontrolfile

41、;sql'altersystemarchivelogcurrent'backupformat'arch%t_%s_%p'diskratio=0archivelogalldeleteinput;releasechannelt1;releasechannelt2;releasechannelt3;releasechannelt4;releasechannelt5;releasechannelt6;EOF_RMAN#DeleteOldBackupsrman<<EOF_RMANconnecttarget;allocatechannelformaintenan

42、cetype'sbt_tape'parms'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'crosscheckbackup;crosscheckarchivelogall;reportobsolete;deletenopromptobsoleterecoverywindowof90days;deletenopromptexpiredbackup;releasechannel;EOF_RMAN10.4、查看已备份的数据RMAN>listbackup;ListofBackupSe

43、tsBSKeyTypeLVSizeDeviceTypeElapsedTimepletionTimeFull1.23GSBTTAPE00:05:0304-SEP-10BPKey:3Status:AVAILABLEpressed:NOTag:TAG20100904T065805Handle:df72880908541Media:26ListofDatafilesinbackupset3FileLVTypeCkpSCkpTimeNameFull352964704-SEP-10+ZGWANG/zgwang/system01.dbfFull352964704-SEP-10+ZGWANG/zgwang/s

44、ysaux02.dbfFull352964704-SEP-10+ZGWANG/zgwang/undotbs103.dbfFull352964704-SEP-10+ZGWANG/zgwang/users04.dbfFull352964704-SEP-10+ZGWANG/zgwang/undotbs205.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimepletionTime4Full13.75MSBT_TAPE00:02:1704-SEP-10BPKey:4Status:AVAILABLEpressed:NOTag:TAG20100904T065805Handle:

45、df_728809393_5_1Media:26SPFILEIncluded:Modificationtime:04-SEP-10SPFILEdb_unique_name:ZGWANGControlFileIncluded:CkpS:3531130Ckptime:04-SEP-10如下列图:IBSKd/TypeLVTypeEL«ipi4cTirnC0rrpL_TimaFileLVTypeCkpSCNCkpTlmeName1Pllll於X3L7ad-SEP-10+2GAlANG/7gwAng/7三terrtSl.dbf2PulI3SK647&4-5EP-：6+/GAlftNG/

46、7Ekiarij/syaux0J.clbf3FullM-SEP-16+ZGiaNG/zgwangundctbsl0.dbf4FULL352S64704-SEP-16+ZGAlftNG/zgkiang/user£iii4-dbf5FuLL352964704-5EP-10+ZGfllANG/zgwaiig/undatbs2©5.dbf85<cyTypeL¥f5izsDevi匚eTypeELpsedTimeConrpLwtionTime.1Full1?.75MSBTCPEg60:02:17021-SFP-LeFull1.23GSKI'_TAPE阳：的湖3独

47、百印-18EPKey:3Status:AVAILABLECompressed;NOTag:-AG2(51054165305Handle:df_7233®3e£5_4_lMedia:26Lis二ofDoitaFilesLnbackup自己七3HPKey:4Status:AVAlLAHLtC0叩位三sed:UUlag:1必2包L电羽841我兄85Handle：df_7288eS»33_5.1Media:26SPFILEIficlitded：Modi-lestiontlrue:©4-5EP-10SPFTLCdb_dqujn6ZGWANGSn=©l“口

48、InuTudkd:Sp丈M:英弘1三2CkpM勺EF-l已12、恢复数据库12.1、 恢复单个控制文件注：此恢复与备份无关，完全是测试Oracle自身的多文件备份功能。以下为测试步骤12.1.1 、模拟单个控制文件丧失：bash-3.2#su-griddb01:/home/grid$lsoradiag_griddb01:/home/grid$asmcmdASMCMD>IsDATA/ZGWANG/ASMCMD>cdzgwang/zgwangASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205

49、.dbfarchive/control02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysaux02.dbfsystem01.dbftempOl.dbfundotbs103.dbfusers04.dbfASMCMD>cpcontrolOl.ctlarchive/copying+zgwang/zgwang/control01.ctl->+zgwang/zgwang/archive/control01.ctlASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINEL

50、OG/TEMPFILE/UNDOTBS205.dbfarchive/control02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysaux02.dbfsystem01.dbftempOl.dbfundotbs103.dbfusers04.dbfASMCMD>rmcontrolOl.ctlASMCMD>IsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control02.ctlredo02.logredo0

51、3.logredo04.logspfilezgwang.orasysaux02.dbfsystem01.dbftempOl.dbfundotbs103.dbfusers04.dbfASMCMD>exit12.1.2 图启动Oracle数据库db01:/home/oracle$sqlplus7assysdba'SQL*Plus:Release.0ProductiononTueSep715:25:382010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>s

52、tartupORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFixed SizeVariable SizeDatabase BuffersRedo Buffers2214712 bytes1.8119E+10 bytes1.9596E+10 bytes96641024 bytesORA-00205:errorinidentifyingcontrolfile,checkalertlogformoreinfoSQL>exitDisconnectedfromOracleDatabase11gEnterpriseEditionR

53、elease.0-64bitProductionWiththePartitioning,RealApplicationClusters,OLAP,DataMiningandRealApplicationTestingoptions12.1.3 恢复单个控制文件db01:/home/grid$asmcmdASMCMD>cdzgwang/zgwangASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control02.ctlredo01.logredo02.

54、logredo03.logredo04.logspfilezgwang.orasysaux02.dbfsystem01.dbftempOl.dbfundotbs103.dbfusers04.dbfASMCMD>cpcontrol02.ctlcontrolOl.ctlcopying+zgwang/zgwang/control02.ctl->+zgwang/zgwang/control01.ctlASMCMD>exit12.1.4 重新启动Oracle数据库bash-3.2#su-oracledb01:/home/oracle$sqlplus7assysdba'SQL*P

55、lus:Release.0ProductiononTueSep715:26:362010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease1120.1.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>

56、;startupORA-01081:cannotstartalready-runningORACLE-shutitdownfirstSQL>shutdownimmediateORA-01507:databasenotmountedORACLEinstanceshutdown.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFixed SizeVariable SizeDatabase BuffersRedo Buffers2214712 bytes1.8119E+10 bytes1.9596E+10 bytes96641024 bytesDatabaseopened.SQL>exitDisconnectedfromOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptions12.2、 恢复spfile文件注：此功能与备份无关，只是测试通