




版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進行舉報或認領(lǐng)
文檔簡介
TSM5.5備份和恢復Oracle11gR2IBMTivoliStorageManagerforDatabasesDataProtectionforOracle,以下簡稱:TDPO1、安裝TDPO1.1、軟件選擇tivoli.tsm.client.oracle.ai*.64bittivoli.tsm.client.oracle.tools.ai*.64bittivoli.tsm.loc.client.oracle.ai*.64bit.ela1.2、軟件安裝、將所有需要安裝的文件集上傳到效勞器上,假設(shè)上傳到/tmp/soft/tsm/oracle目錄。、進入軟件集目錄,然后執(zhí)行安裝命令:bash-3.2*cd/tmp/soft/tsm/oraclebash-3.2*smittyinstall—InstallandUpdateSoftware——InstallandUpdatefromALLAvailableSoftware在*INPUTdevice/directoryforsoftware中輸入./SOFTWAREtoinstall中輸入allACCEPTnewlicenseagreements"選項中no改為yes然后按回車鍵安裝,再按回車鍵確認后,軟件安裝完成。2、將RMAN與TDPO重新a、設(shè)置OracleLD_LIBRARY_PATH選項修改.proflie文件,將$ORACLE_HOME/lib放在LD_LIBRARY_PATH選項第一位,即:LD_LIBRARY_PATH=$ORACLE_HOME/libb、關(guān)閉使用$ORACLE_HOME的所有Oracle實例c、轉(zhuǎn)至$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/client/oracle/bin64bash-3.2*vitdpo.optDSMI_ORC_CONFIG/usr/tivoli/tsm/client/oracle/bin64/dsm.optDSMI_LOG/usr/tivoli/tsm/client/oracle/bin64TDPO_FSdb01_oraTDPO_NODEdb01_oracleTDPO_OWNERoracleTDPO_PSWDPATH/usr/tivoli/tsm/client/oracle/bin64TDPO_DATE_FMT1TDPO_NUM_FMT1TDPO_TIME_FMT14、將TDPO節(jié)點注冊到TSM效勞器registernodedb01_oraclepasswordma*nummp=2passe*p=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.sysSErvernametsmserverMMethodTCPipTCPPort1500NODEnamedb01_oraclePASSWORDAccessprompt6、修改TSMAPI和TDPO目錄的權(quán)限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>definedomainoradomainANR1500IPolicydomainORADOMAINdefined.6.2、定義策略tsm:TSMSERVER>definepoloradomainorapolANR1510IPolicysetORAPOLdefinedinpolicydomainORADOMAIN.6.3、定義管理類tsm:TSMSERVER>definemgmtoradomainorapoloramgmtANR1520IManagementclassORAMGMTdefinedinpolicydomainORADOMAIN,setORAPOL.6.4、指派缺省管理類tsm:TSMSERVER>assigndefmgmtoradomainorapoloramgmtANR1538IDefaultmanagementclasssettoORAMGMTforpolicydomainORADOMAIN,setORAPOL.6.5、定義存儲池tsm:TSMSERVER>definestgpoolorapooldiskANR2200IStoragepoolORAPOOLdefined(deviceclassDISK).6.6、定義存儲池卷tsm:TSMSERVER>definevolumeorapool/tsm1/ora.dsmformatsize=512wait=yesANR0984IProcess9forDEFINEVOLUMEstartedintheFOREGROUNDat12:19:20.ANR2206IVolume/tsm1/ora.dsmdefinedinstoragepoolORAPOOL(deviceclassDISK).ANR0986IProcess9forDEFINEVOLUMErunningintheFOREGROUNDprocessed1itemsforatotalof536,870,912byteswithapletionstateofSUCCESSat12:19:26.6.7、定義存儲池空間觸發(fā)器tsm:TSMSERVER>definespacetriggerstgstgpool=orapoolspacee*pansion=50e*pansionprefi*=/tsm1/ANR4485IAstoragepoolspacetriggerhasbeendefinedandenabledforstoragepoolORAPOOL.6.8、定義副本組tsm:TSMSERVER>definecopyoradomainorapoloramgmtdest=orapoolverdeleted=0retonly=0SessionestablishedwithserverTSMSERVER:AI*-RS/6000ServerVersion5,Release5,Level4.0Serverdate/time:09/03/1012:58:21Lastaccess:09/03/1012:14:15ANR1530IBackupcopygroupSTANDARDdefinedinpolicydomainORADOMAIN,setORAPOL,managementclassORAMGMT.6.9、激活備份策略ANR1554WDEFAULTManagementclassORAMGMTinpolicysetORADOMAINORAPOLdoesnothaveanARCHIVEcopygroup:fileswillnotbearchivedbydefaultifthissetisactivated.Doyouwishtoproceed"(Yes(Y)/No(N))yANR1554WDEFAULTManagementclassORAMGMTinpolicysetORADOMAINORAPOLdoesnothaveanARCHIVEcopygroup:fileswillnotbearchivedbydefaultifthissetisactivated.ANR1514IPolicysetORAPOLactivatedinpolicydomainORADOMAIN.6.10、更新客戶端節(jié)點信息tsm:TSMSERVER>updatenodedb01_oracledomain=oradomainANR2063INodeDB01_ORACLEupdated.注:將節(jié)點db01_oracle的策略域改為oradomain.7、修改TDPO節(jié)點密碼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*tdpoconfShowenvironment9、將數(shù)據(jù)庫改為歸檔模式10、測試TDPO與Oracle數(shù)據(jù)庫的連接db01:/home/oracle$sbttesttestThesbtfunctionpointersareloadedfromlibobk.a(shr.o)library.--sbtinitsucceededReturncode-1fromsbtinit,bsercoer=0,bsercerrno=0Message0notfound;product=RDBMS;facility=SBT如圖:顯示如上,表示測試成功,如果不成功,有可能是TDPO目錄或TSMAPI目錄權(quán)限設(shè)置不對或者tdpo.opt文件配置錯誤。10、備份數(shù)據(jù)庫10.1、備份數(shù)據(jù)文件通過RMAN執(zhí)行備份數(shù)據(jù)文件腳本,過程如下:db01:/home/oracle$rmanRecoveryManager:Release.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/bin64/tdpo.opt)';5>backup6>filesperset57>format'df_%t_%s_%p'8>(database);9>}allocatedchannel:t1channelt1:SID=237instance=zgwang1devicetype=SBT_TAPEStartingbackupat04-SEP-10channelt1:startingfulldatafilebackupsetchannelt1:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00002name=+ZGWANG/zgwang/sysau*02.dbfinputdatafilefilenumber=00001name=+ZGWANG/zgwang/system01.dbfinputdatafilefilenumber=00003name=+ZGWANG/zgwang/undotbs103.dbfinputdatafilefilenumber=00005name=+ZGWANG/zgwang/undotbs205.dbfinputdatafilefilenumber=00004name=+ZGWANG/zgwang/users04.dbfchannelt1:startingpiece1at04-SEP-10channelt1:finishedpiece1at04-SEP-10channelt1:backupsetplete,elapsedtime:00:05:07channelt1:startingfulldatafilebackupsetchannelt1:specifyingdatafile(s)inbackupsetincludingcurrentcontrolfileinbackupsetincludingcurrentSPFILEinbackupsetchannelt1:startingpiece1at04-SEP-10channelt1:finishedpiece1at04-SEP-10channelt1:backupsetplete,elapsedtime:00:02:23Finishedbackupat04-SEP-10releasedchannel:t1如下列圖:10.2、全備數(shù)據(jù)庫〔包括spfile文件、數(shù)據(jù)文件、控制文件、歸檔日志文件〕腳本如下:**BackupDatabaseFullrmantarget/<<EOF_RMANrun{allocatechannelt1type'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)';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_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=0databaseincludecurrentcontrolfile;sql'altersystemarchivelogcurrent';backupformat'arch%t_%s_%p'diskratio=0archivelogalldeleteinput;releasechannelt1;releasechannelt2;releasechannelt3;releasechannelt4;releasechannelt5;releasechannelt6;}EOF_RMAN**DeleteOldBackupsrman<<EOF_RMANconnecttarget;allocatechannelformaintenancetype'sbt_tape'parms'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';crosscheckbackup;crosscheckarchivelogall;reportobsolete;deletenopromptobsoleterecoverywindowof90days;deletenoprompte*piredbackup;releasechannel;EOF_RMAN10.3、增量備份數(shù)據(jù)庫〔包括spfile文件、數(shù)據(jù)文件、控制文件、歸檔日志文件〕腳本如下:**BackupDatabaseFullrmantarget/<<EOF_RMANrun{allocatechannelt1type'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)';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_optfile=/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;sql'altersystemarchivelogcurrent';backupformat'arch%t_%s_%p'diskratio=0archivelogalldeleteinput;releasechannelt1;releasechannelt2;releasechannelt3;releasechannelt4;releasechannelt5;releasechannelt6;}EOF_RMAN**DeleteOldBackupsrman<<EOF_RMANconnecttarget;allocatechannelformaintenancetype'sbt_tape'parms'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';crosscheckbackup;crosscheckarchivelogall;reportobsolete;deletenopromptobsoleterecoverywindowof90days;deletenoprompte*piredbackup;releasechannel;EOF_RMAN10.4、查看已備份的數(shù)據(jù)RMAN>listbackup;ListofBackupSets===================BSKeyTypeLVSizeDeviceTypeElapsedTimepletionTime-------------------------------------------------------------3Full1.23GSBT_TAPE00:05:0304-SEP-10BPKey:3Status:AVAILABLEpressed:NOTag:TAG20100904T065805Handle:df_728809085_4_1Media:26ListofDatafilesinbackupset3FileLVTypeCkpSCkpTimeName---------------------------------1Full352964704-SEP-10+ZGWANG/zgwang/system01.dbf2Full352964704-SEP-10+ZGWANG/zgwang/sysau*02.dbf3Full352964704-SEP-10+ZGWANG/zgwang/undotbs103.dbf4Full352964704-SEP-10+ZGWANG/zgwang/users04.dbf5Full352964704-SEP-10+ZGWANG/zgwang/undotbs205.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimepletionTime-------------------------------------------------------------4Full13.75MSBT_TAPE00:02:1704-SEP-10BPKey:4Status:AVAILABLEpressed:NOTag:TAG20100904T065805Handle:df_728809393_5_1Media:26SPFILEIncluded:Modificationtime:04-SEP-10SPFILEdb_unique_name:ZGWANGControlFileIncluded:CkpS:3531130Ckptime:04-SEP-10如下列圖:12、恢復數(shù)據(jù)庫12.1、恢復單個控制文件注:此恢復與備份無關(guān),完全是測試Oracle自身的多文件備份功能。以下為測試步驟、模擬單個控制文件喪失:bash-3.2*su-griddb01:/home/grid$lsoradiag_griddb01:/home/grid$asmcmdASMCMD>lsDATA/ZGWANG/ASMCMD>cdzgwang/zgwangASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>cpcontrol01.ctlarchive/copying+zgwang/zgwang/control01.ctl->+zgwang/zgwang/archive/control01.ctlASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>rmcontrol01.ctlASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>e*it、試圖啟動Oracle數(shù)據(jù)庫db01:/home/oracle$sqlplus'/assysdba'SQL*Plus:Release.0ProductiononTueSep715:25:382010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFi*edSize2214712bytesVariableSize1.8119E+10bytesDatabaseBuffers1.9596E+10bytesRedoBuffers96641024bytesORA-00205:errorinidentifyingcontrolfile,checkalertlogformoreinfoSQL>e*itDisconnectedfromOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,OLAP,DataMiningandRealApplicationTestingoptions、恢復單個控制文件db01:/home/grid$asmcmdASMCMD>cdzgwang/zgwangASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>cpcontrol02.ctlcontrol01.ctlcopying+zgwang/zgwang/control02.ctl->+zgwang/zgwang/control01.ctlASMCMD>e*it、重新啟動Oracle數(shù)據(jù)庫bash-3.2*su-oracledb01:/home/oracle$sqlplus'/assysdba'SQL*Plus:Release.0ProductiononTueSep715:26:362010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>startupORA-01081:cannotstartalready-runningORACLE-shutitdownfirstSQL>shutdownimmediateORA-01507:databasenotmountedORACLEinstanceshutdown.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFi*edSize2214712bytesVariableSize1.8119E+10bytesDatabaseBuffers1.9596E+10bytesRedoBuffers96641024bytesDatabasemounted.Databaseopened.SQL>e*itDisconnectedfromOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptions12.2、恢復spfile文件注:此功能與備份無關(guān),只是測試通過pfile文件重建spfile文件的功能。、模擬spfile文件喪失db01:/home/grid$asmcmdASMCMD>cdzgwang/zgwangASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>cpspfilezgwang.oraarchive/copying+zgwang/zgwang/spfilezgwang.ora->+zgwang/zgwang/archive/spfilezgwang.oraASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>rmspfilezgwang.oraASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logsysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>e*it、試圖啟動Oracle數(shù)據(jù)庫db01:/home/oracle$sqlplus'/assysdba'SQL*Plus:Release.0ProductiononTueSep715:13:372010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupORA-01078:failureinprocessingsystemparametersORA-01565:errorinidentifyingfile'+ZGWANG/zgwang/spfilezgwang.ora'ORA-17503:ksfdopn:2Failedtoopenfile+ZGWANG/zgwang/spfilezgwang.oraORA-15056:additionalerrormessageORA-17503:ksfdopn:DGOpenFile05Failedtoopenfile+ZGWANG/zgwang/spfilezgwang.oraORA-17503:ksfdopn:2Failedtoopenfile+ZGWANG/zgwang/spfilezgwang.oraORA-15173:entry'spfilezgwang.ora'doesnote*istindirectory'zgwang'ORA-06512:atline4、重建spfile文件SQL>createspfile='+ZGWANG/zgwang/spfilezgwang.ora'frompfile='/data/app/oracle/admin/zgwang/scripts/init.ora';Filecreated.、啟動Oracle數(shù)據(jù)庫SQL>startupORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFi*edSize2214712bytesVariableSize1.8119E+10bytesDatabaseBuffers1.9596E+10bytesRedoBuffers96641024bytesDatabasemounted.Databaseopened.12.3、恢復users.dbf文件、模擬users*.dbf文件喪失db01:/home/grid$asmcmdlsASMCMD>DATA/ZGWANG/ASMCMD>cdzgwang/zgwangASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfusers04.dbfASMCMD>rmusers04.dbfASMCMD>lsARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/TEMPFILE/UNDOTBS205.dbfarchive/control01.ctlcontrol02.ctlredo01.logredo02.logredo03.logredo04.logspfilezgwang.orasysau*02.dbfsystem01.dbftemp01.dbfundotbs103.dbfASMCMD>e*it如圖:、試圖啟動Oracle數(shù)據(jù)庫,同時注意文件編號db01:/home/oracle$sqlplus'/assysdba'SQL*Plus:Release.0ProductiononTueSep714:25:562010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFi*edSize2214712bytesVariableSize1.8119E+10bytesDatabaseBuffers1.9596E+10bytesRedoBuffers96641024bytesDatabasemounted.ORA-01157:cannotidentify/lockdatafile4-seeDBWRtracefileORA-01110:datafile4:'+ZGWANG/zgwang/users04.dbf'SQL>e*itDisconnectedfromOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptions如圖:在這里我們可以看到文件編號為4、通過RMAN恢復users*.dbf文件〔附腳本〕db01:/home/oracle$rmantarget/RecoveryManager:Release.0-ProductiononTueSep714:30:352010Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:ZGWANG(DBID=747272013,notopen)RMAN>reportschema;usingtargetdatabasecontrolfileinsteadofrecoverycatalogReportofdatabaseschemafordatabasewithdb_unique_nameZGWANGListofPermanentDatafiles===========================FileSize(MB)TablespaceRBsegsDatafileName---------------------------------------------------------------1700SYSTEM***+ZGWANG/zgwang/system01.dbf2840SYSAU****+ZGWANG/zgwang/sysau*02.dbf350UNDOTBS1***+ZGWANG/zgwang/undotbs103.dbf40USERS***+ZGWANG/zgwang/users04.dbf525UNDOTBS2***+ZGWANG/zgwang/undotbs205.dbfListofTemporaryFiles=======================FileSize(MB)TablespaceMa*size(MB)TempfileName---------------------------------------------------------------120TEMP32767+ZGWANG/zgwang/temp01.dbfRMAN>e*itRecoveryManagerplete.db01:/home/oracle$sqlplus'/assysdba'SQL*Plus:Release.0ProductiononTueSep714:33:092010Copyright(c)1982,2009,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>startupmountORACLEinstancestarted.TotalSystemGlobalArea3.7814E+10bytesFi*edSize2214712bytesVariableSize1.8119E+10bytesDatabaseBuffers1.9596E+10bytesRedoBuffers96641024bytesDatabasemounted.SQL>e*itDisconnectedfromOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsdb01:/home/oracle$rmantarget/RecoveryManager:Release.0-ProductiononTueSep714:34:002010Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:ZGWANG(DBID=747272013,notopen)RMAN>run{2>allocatechannelt1type'sbt_tape'parms'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';3>sql"alterdatabasedatafile4offline";4>restoredatafile4;5>recoverdatafile4;6>sql"alterdatabasedatafile4online";7>releasechannelt1;8>}allocatedchannel:t1channelt1:SID=171devicetype=SBT_TAPEsqlstatement:alterdatabasedatafile4offlineStartingrestoreat07-SEP-10channelt1:startingdatafilebackupsetrestorechannelt1:specifyingdatafile(s)torestorefrombackupsetchannelt1:restoringdatafile00004to+ZGWANG/zgwang/users04.dbfchannelt1:readingfrombackuppiece0nln9p6r_1_1channelt1:piecehandle=0nln9p6r_1_1tag=%D_FULL_%S_%Pchannelt1:restoredbackuppiece1channelt1:restoreplete,elapsedtime:00:00:49Finishedrestoreat07-SEP-10Startingrecoverat07-SEP-10startingmediarecoverychannelt1:startingarc
溫馨提示
- 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預覽,若沒有圖紙預覽就沒有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負責。
- 6. 下載文件中如有侵權(quán)或不適當內(nèi)容,請與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
最新文檔
- 豬肉收儲知識培訓課件
- 人教版(2024)七年級英語下冊Unit 7 學情調(diào)研測試卷(含答案)
- 鋼結(jié)構(gòu)切割施工方案
- 2025年中考物理二輪復習:電磁學實驗題 能力提升練習題(含答案)
- 合同范本融資租賃合同
- 課題2 原子結(jié)構(gòu)(第2課時)(教學設(shè)計)九年級化學上冊同步高效課堂(人教版2024)
- 如何評估品牌傳播的效果與影響計劃
- 提升產(chǎn)品質(zhì)量的改進措施計劃
- 學期目標與教學任務分解計劃
- 實施素質(zhì)教育的年度工作要點計劃
- 2024年醫(yī)用衛(wèi)生材料敷料項目申請報告模板
- 《危險化學品企業(yè)安全生產(chǎn)標準化評審標準》
- 成人鼻腸管的留置與維護
- 國能遼寧北票 200MW 風力發(fā)電項目地質(zhì)災害危險性評估報告
- ISO22000:2018體系之食品安全管理手冊含程序文件匯編2022版
- DZ∕T 0214-2020 礦產(chǎn)地質(zhì)勘查規(guī)范 銅、鉛、鋅、銀、鎳、鉬(正式版)
- QCSG1204009-2015電力監(jiān)控系統(tǒng)安全防護技術(shù)規(guī)范
- (正式版)SHT 3158-2024 石油化工管殼式余熱鍋爐
- 新生兒傳統(tǒng)四病篩查
- GB/T 41666.4-2024地下無壓排水管網(wǎng)非開挖修復用塑料管道系統(tǒng)第4部分:原位固化內(nèi)襯法
- 小班社會《多喝水身體好》課件
評論
0/150
提交評論