原创TSM55备份和恢复Oracle 11gR2Word格式文档下载.docx
《原创TSM55备份和恢复Oracle 11gR2Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《原创TSM55备份和恢复Oracle 11gR2Word格式文档下载.docx（33页珍藏版）》请在冰豆网上搜索。
LD_LIBRARY_PATH=$ORACLE_HOME/lib
b、关闭使用$ORACLE_HOME的所有Oracle实例
c、转至$ORACLE_HOME目录
d、将库文件符号连接到libobk.a
ln-s/usr/lib/libobk64.a$ORACLE_HOME/lib/libobk.a
3、定义tdpo.opt文件中的TDPO选项
bash-3.2#cd/usr/tivoli/tsm/client/oracle/bin64
bash-3.2#vitdpo.opt
DSMI_ORC_CONFIG/usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG/usr/tivoli/tsm/client/oracle/bin64
TDPO_FSdb01_ora
TDPO_NODEdb01_oracle
TDPO_OWNERoracle
TDPO_PSWDPATH/usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT1
TDPO_NUM_FMT1
TDPO_TIME_FMT1
4、将TDPO节点注册到TSM服务器
registernodedb01_oraclepasswordmaxnummp=2passexp=0backdelete=yes
5、在dsm.opt和dsm.sys文件中定义TSM选项
5.1、配置dsm.opt
bash-3.2#vidsm.opt
SErvernametsmserver
注意：
此文件必须位于tdpo.opt中的dsmi_orc_config指定的目录中。
5.2、配置dsm.sys
bash-3.2#cd/usr/tivoli/tsm/client/api/bin64
bash-3.2#vidsm.sys
COMMMethodTCPip
TCPPort1500
TCPServeraddress192.168.2.16
NODEnamedb01_oracle
PASSWORDAccessprompt
6、修改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>
definedomainoradomain
ANR1500IPolicydomainORADOMAINdefined.
6.2、定义策略
definepoloradomainorapol
ANR1510IPolicysetORAPOLdefinedinpolicydomainORADOMAIN.
6.3、定义管理类
definemgmtoradomainorapoloramgmt
ANR1520IManagementclassORAMGMTdefinedinpolicydomainORADOMAIN,setORAPOL.
6.4、指派缺省管理类
assigndefmgmtoradomainorapoloramgmt
ANR1538IDefaultmanagementclasssettoORAMGMTforpolicydomainORADOMAIN,setORAPOL.
6.5、定义存储池
definestgpoolorapooldisk
ANR2200IStoragepoolORAPOOLdefined（deviceclassDISK）.
6.6、定义存储池卷
definevolumeorapool/tsm1/ora.dsmformatsize=512wait=yes
ANR0984IProcess9forDEFINEVOLUMEstartedintheFOREGROUNDat12:
19:
20.
ANR2206IVolume/tsm1/ora.dsmdefinedinstoragepoolORAPOOL（deviceclassDISK）.
ANR0986IProcess9forDEFINEVOLUMErunningintheFOREGROUNDprocessed1itemsforatotalof536,870,912byteswitha
completionstateofSUCCESSat12:
26.
6.7、定义存储池空间触发器
definespacetriggerstgstgpool=orapoolspaceexpansion=50expansionprefix=/tsm1/
ANR4485IAstoragepoolspacetriggerhasbeendefinedandenabledforstoragepoolORAPOOL.
6.8、定义副本组
definecopyoradomainorapoloramgmtdest=orapoolverdeleted=0retonly=0
SessionestablishedwithserverTSMSERVER:
AIX-RS/6000
ServerVersion5,Release5,Level4.0
Serverdate/time:
09/03/1012:
58:
21Lastaccess:
14:
15
ANR1530IBackupcopygroupSTANDARDdefinedinpolicydomainORADOMAIN,setORAPOL,managementclassORAMGMT.
6.9、激活备份策略
ANR1554WDEFAULTManagementclassORAMGMTinpolicysetORADOMAINORAPOLdoesnothaveanARCHIVEcopygroup:
fileswill
notbe
archivedbydefaultifthissetisactivated.
Doyouwishtoproceed?
（Yes（Y）/No（N））y
ANR1514IPolicysetORAPOLactivatedinpolicydomainORADOMAIN.
6.10、更新客户端节点信息
updatenodedb01_oracledomain=oradomain
ANR2063INodeDB01_ORACLEupdated.
注：
将节点db01_oracle的策略域改为oradomain.
7、修改TDPO节点密码
bash-3.2#cd/usr/tivoli/tsm/client/oracle/bin64/
bash-3.2#tdpoconfpassword
8、查看TDOP配置信息
bash-3.2#tdpoconfShowenvironment
9、将数据库改为归档模式
10、测试TDPO与Oracle数据库的连接
db01:
/home/oracle$sbttesttest
Thesbtfunctionpointersareloadedfromlibobk.a（shr.o）library.
--sbtinitsucceeded
Returncode-1fromsbtinit,bsercoer=0,bsercerrno=0
Message0notfound;
product=RDBMS;
facility=SBT
如图：
显示如上，表示测试成功，如果不成功，有可能是TDPO目录或TSMAPI目录权限设置不对或者tdpo.opt文件配置错误。
10、备份数据库
10.1、备份数据文件
通过RMAN执行备份数据文件脚本，过程如下：
/home/oracle$rman
RecoveryManager:
Release11.2.0.1.0-ProductiononSatSep406:
46:
332010
Copyright（c）1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
RMAN>
connecttarget
connectedtotargetdatabase:
ZGWANG（DBID=747272013）
MAN>
run
2>
{
3>
allocatechannelt1type'
sbt_tape'
parms
4>
'
ENV=（TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt）'
;
5>
backup
6>
filesperset5
7>
format'
df_%t_%s_%p'
8>
（database）;
9>
}
allocatedchannel:
t1
channelt1:
SID=237instance=zgwang1devicetype=SBT_TAPE
DataProtectionforOracle:
version5.4.1.0
Startingbackupat04-SEP-10
startingfulldatafilebackupset
specifyingdatafile（s）inbackupset
inputdatafilefilenumber=00002name=+ZGWANG/zgwang/sysaux02.dbf
inputdatafilefilenumber=00001name=+ZGWANG/zgwang/system01.dbf
inputdatafilefilenumber=00003name=+ZGWANG/zgwang/undotbs103.dbf
inputdatafilefilenumber=00005name=+ZGWANG/zgwang/undotbs205.dbf
inputdatafilefilenumber=00004name=+ZGWANG/zgwang/users04.dbf
startingpiece1at04-SEP-10
finishedpiece1at04-SEP-10
piecehandle=df_728809085_4_1tag=TAG20100904T065805comment=APIVersion2.0,MMSVersion5.4.1.0
backupsetcomplete,elapsedtime:
00:
05:
07
includingcurrentcontrolfileinbackupset
includingcurrentSPFILEinbackupset
piecehandle=df_728809393_5_1tag=TAG20100904T065805comment=APIVersion2.0,MMSVersion5.4.1.0
02:
23
Finishedbackupat04-SEP-10
releasedchannel:
如下图：
10.2、全备数据库
（包括spfile文件、数据文件、控制文件、归档日志文件）
脚本如下：
##BackupDatabaseFull
rmantarget/<
<
EOF_RMAN
run{
allocatechannelt1type'
parms'
ENV=（tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt）'
allocatechannelt2type'
allocatechannelt3type'
allocatechannelt4type'
allocatechannelt5type'
allocatechannelt6type'
backupfulltag'
dbfull'
dbfull_%t_%s_%p'
diskratio=0databaseincludecurrentcontrolfile;
sql'
altersystemarchivelogcurrent'
backupformat'
arch%t_%s_%p'
diskratio=0archivelogalldeleteinput;
releasechannelt1;
releasechannelt2;
releasechannelt3;
releasechannelt4;
releasechannelt5;
releasechannelt6;
}
EOF_RMAN
##DeleteOldBackups
rman<
connecttarget;
allocatechannelformaintenancetype'
crosscheckbackup;
crosscheckarchivelogall;
reportobsolete;
deletenopromptobsoleterecoverywindowof90days;
deletenopromptexpiredbackup;
releasechannel;
10.3、增量备份数据库
rmantarget/<
backupincrementallevel1tag'
dbincr'
%d_full_%s_%p'
filesperset5diskratio=0databaseincludecurrentcontrolfile;
10.4、查看已备份的数据
listbackup;
ListofBackupSets
===================
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
3Full1.23GSBT_TAPE00:
0304-SEP-10
BPKey:
3Status:
AVAILABLECompressed:
NOTag:
TAG20100904T065805
Handle:
df_728809085_4_1Media:
26
ListofDatafilesinbackupset3
升级会员 