TSM备份oracle数据库安装配置

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、软件安装、将所有需要安装的文件集上传到效劳器上，假设上传到/tmp/soft/tsm/oracle目录。、进入软件集目录，然后执行安装命令：bash-3.2*cd/tmp/soft/tsm/oraclebash-3.2*smittyinstall—InstallandUpdateSoftware——InstallandUpdatefromALLAvailableSoftware在*INPUTdevice/directoryforsoftware中输入./SOFTWAREtoinstall中输入allACCEPTnewlicenseagreements"选项中no改为yes然后按回车键安装，再按回车键确认后，软件安装完成。2、将RMAN与TDPO重新a、设置OracleLD_LIBRARY_PATH选项修改.proflie文件，将$ORACLE_HOME/lib放在LD_LIBRARY_PATH选项第一位，即：LD_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/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节点注册到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目录的权限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、定义存储池空间触发器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、更新客户端节点信息tsm:TSMSERVER>updatenodedb01_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*tdpoconfShowenvironment9、将数据库改为归档模式10、测试TDPO与Oracle数据库的连接db01:/home/oracle$sbttesttestThesbtfunctionpointersareloadedfromlibobk.a(shr.o)library.--sbtinitsucceededReturncode-1fromsbtinit,bsercoer=0,bsercerrno=0Message0notfound;product=RDBMS;facility=SBT如图：显示如上，表示测试成功，如果不成功，有可能是TDPO目录或TSMAPI目录权限设置不对或者tdpo.opt文件配置错误。10、备份数据库10.1、备份数据文件通过RMAN执行备份数据文件脚本，过程如下：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、全备数据库〔包括spfile文件、数据文件、控制文件、归档日志文件〕脚本如下：**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、增量备份数据库〔包括spfile文件、数据文件、控制文件、归档日志文件〕脚本如下：**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、查看已备份的数据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、恢复数据库12.1、恢复单个控制文件注：此恢复与备份无关，完全是测试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数据库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数据库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文件注：此功能与备份无关，只是测试通过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数据库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数据库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数据库，同时注意文件编号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