tsm5.3安装配置.docx

1 【转】TSM5.3安装步骤2010/01/04BYMACLEAN LIU暂无评论2 安装步骤3 2.1 安装TSM服务器创建/usr/Tivoli/tsm 文件系统，大小1G左右放入安装介质，smit installp安装如下组件4 2.2 安装TSM备份归档客户机放入AIX client 安装介质，smit installp安装如下组件tivoli.tsm.client.api.64bit tivoli.tsm.client.api.jfs2 tivoli.tsm.client.ba.jfs2.base mon tivoli.tsm.client.ba.jfs2.image tivoli.tsm.client.ba.jfs2.nas tivoli.tsm.client.ba.jfs2.web5 2.3 安装ORACLE TDP放入tivoli data protection for oracle 安装介质，smit installp安装如下组件tivoli.tsm.client.oracle.aix51.64bittivoli.tsm.client.oracle.tools.aix51.64bit6 2.4 安装SAN Agent放入SAN Agent 安装介质，smit installp安装如下组件tivoli.tsm.StorageAgent.rtetivoli.tsm.devices.aix5.rte7 三、配置步骤8 3.1 配置TSM 服务端1 修改环境变量在TSMServer的.profile文件增加如下内容：exportDSMSERV_DIR=/usr/tivoli/tsm/server/binexportDSMSERV_CONFIG=/usr/tivoli/tsm/server/bin/dmserv.opt2注册license , register lic file=* number=20审核license audit lic3定义库以及库路径define library lib3582 libtype=SCSI SERial=AUTODetect AUTOLabel=no SHARED=yes RESETDrives=Yesdefine path tsm lib3582 srctype=server desttype=library device=/dev/smc0 online=yes4定义驱动器以及驱动器路径define drive lib3582 drv0 online=yes element=256define drive lib3582 drv1 online=yes element=257define path tsm drv0 srctype=server desttype=drive library=lib3582 device=/dev/rmt0 online=yesdefine path tsm drv1 srctype=server desttype=drive library=lib3582 device=/dev/rmt1 online=yes5定义设备类define devclass lto2dev library=lib3582 devtype=lto6 检入库卷label libvolume lib3582 search=yes checkin=scratch LABELSource=BarcodeOVERWRITE=yes VOLRange=zy9580,zy95997 定义TSM DB卷，并扩展define dbvolume /usr/tivoli/tsm/server/db1.dsm f=500extend db 5008 定义 TSM LOG卷，并扩展define logvolume /usr/tivoli/tsm/server/log1.dsm f=256extend log 5009 定义存储池define stgpool P5_FS_POOL lto2dev maxscratch=0define volume P5_FS_POOL zy9582define volume P5_FS_POOL zy9583define stgpool P5_ORA_POOL lto2dev maxscratch=0define volume P5_ORA_POOL zy9595define volume P5_ORA_POOL zy9596define volume P5_ORA_POOL zy9597define volume P5_ORA_POOL zy9598define volume P5_ORA_POOL zy959910 定义策略域define domain P5_FS_DOMAINdefine policyset P5_FS_DOMAIN P5_FS_SETdefine mgmtclass P5_FS_DOMAIN P5_FS_SET P5_FS_CLASSdefine copygroup P5_FS_DOMAIN P5_FS_SET P5_FS_CLASS standard type=backu destination=P5_FS_POOLassign defmgmtclass P5_FS_DOMAIN P5_FS_SET P5_FS_CLASSactivate policyset P5_FS_DOMAIN P5_FS_SETdefine domain P5_ORA_DOMAINdefine policyset P5_ORA_DOMAIN P5_ORA_SETdefine mgmtclass P5_ORA_DOMAIN P5_ORA_SET P5_ORA_CLASSdefine copygroup P5_ORA_DOMAIN P5_ORA_SET P5_ORA_CLASS standard type=backu destination=P5_ORA_POOL VERExists=1 VERDeleted=0 RETExtra=0 RETOnly=0assign defmgmtclass P5_ORA_DOMAIN P5_ORA_SET P5_ORA_CLASSactivate policyset P5_ORA_DOMAIN P5_ORA_SET11 注册客户机register node P570_FS p570_fs domain=P5_FS_DOMAIN backdelete=yes archdelete=yes passe=0register node P550_FS p550_fs domain= P5_FS_DOMAIN backdelete=yes archdelete=yes passe=0register node P570_TDPO p570_tdpo domain=P5_ORA_DOMAIN backdelete=yes archdelete=yes passe=0register node P550_TDPO p550_tdpo domain= P5_ORA_DOMAIN backdelete=yes archdelete=yes passe=012 定义管理调度DEFine SCHedule bkupdb Type=Administrative CMD=backup db type=full devclass=lto2dev volumenames=zy9580 scratch=no ACTIVE=yes STARTTime=12:00:00DEFine SCHedule delvolhist Type=Administrative CMD=DELete VOLHistory TODate=today-1 type=dbbackup ACTIVE=Yes STARTTime=11:50:0013 启动TSM 服务器 到/usr/tivoli/tsm/server/bin nohup dsmserv&9 3.2 配置TSM 客户端1 修改环境标量在TSMClient的.profile文件增加如下内容：exportDSM_DIR=/opt/tivoli/tsm/client/ba/binexportDSM_CONFIG=/opt/tivoli/tsm/client/ba/bin/dsm.optexportDSM_LOG=/opt/tivoli/tsm/client/ba/binexport DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm.optexport DSMI_DIR=/opt/tivoli/tsm/client/api/bin64export DSMI_LOG=/opt/tivoli/tsm/client/api/bin642修改/usr/tivoli/tsm/client/ba/bin 目录下的dsm.opt 以及dsm.sys 文件如下dsm.optdsm.sys3 用命令dsmc 启动命令行客户机，连接TSM 服务器看是否成功10 3.3 配置ORACLE TDP1修改tdpo.opt 如下：2 修改/usr/tivoli/tsm/client/api/bin64 目录下的dsm.opt 以及dsm.sys 文件如下：dsm.optdsm.sys3 生成密码文件tdpoconf password tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt4. 链接libobk.aln s /usr/lib/libobk.a $ORACLE_HOME/lib64/libobk.a链接完后重新启动数据库5 sbttest 测试是否TDP和ORACLE 链接成功$ORACLE_HOME/bin/sbttest test6 安装Catalog 数据库6.1为恢复目录单独创建表空间catalog_tbs，6.2创建恢复目录用户CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE catalog_tbs;6.3 为用户rcat_user 赋予角色GRANT connect,resource,recovery_catalog_owner TO rman;6.4 使用RMAN 连接恢复目录RMAN catalog=rman/rmanrman9i6.5 在RMAN 提示符下创建catalogcreate catalog tablespace catalog_tbs;6.5 使用RMAN 同时连接目标数据和恢复目录set ORACLE_SID=nc31RMAN target / catalog=rman/rmanrman9i6.6使用恢复目录注册数据库RMANRegister database;7如果sbttest 不成功 需要执行这一步7.1添加errorlogname /oracle/mytdpo.log 到DSMI_DIR下的 dsm.sys文件 7.2重新运行tdpo password 命令生成密码7.3进入/oracle 目录确认生成了mytdpo.log 文件7.4更改mytdpo.log 的权限，chmod 666 /oracle/mytdpo.logchown oracle:dba /oracle/mytdpo.log11 3.4 配置SAN Agent1 修改/usr/tivoli/tsm/StorageAgent/bin/dsmsta.opt 增加一行 DEVCONFIG devconfig.out2 使用如下命令 dsmsta setstorageserver myname=storagent mypassword=storagent myhladdress=2 servername=tsm serverpassword=tsm hladdress=1 lladdress=1500 这条命令在devconfig.txt 文件产生如下行： 这条命令在dsmsta.opt 产生如下行： SERVERNAME TSM3 在TSM server 上发出如下命令 set servername TSMset serverpassword tsmset serverhladdress 1set serverlladdress 1500set crossdefine on 设置完可以用q status 查看结果4 在TSM server 上为san agent 定义服务器define server storagnt serverpassword=storagnt hladdress=2 lladdress=1500 validateprotocol=all6 在TSMserver 上定义源服务器为storagnt 的驱动器路径define path storagnt drv0 srctype=server desttype=drive library=lib3582 device=/dev/rmt0define path storagnt drv1 srctype=server desttype=drive library=lib3582 device=/dev/rmt17 为启用lan-free 修改客户机的dsm.sys 文件增加 LANFREECOMMMETHOD TCPIP LANFREECOMMMETHOD SHAREDMEM LANFREETCPPORT 1500 LANFREESHMPORT 1510 enablelanfree yes8 启动san agentnohup dsmsta&12 四、TSM 策略域，存储池配置列表13 4.1 策略域概要配置Policy Domain NamePolicy SetManagement ClassDefault (Y/N)Backup Copy GroupArchive Copy GroupStorage PoolP5_FS_DOMAINstandardstandardYstandardstandardP5_FS_POOLP5_ORA_DOMAINstandardstandardYstandardstandardP5_ORA_POOL14 4.2 策略域详细配置策略域: P5_FS_DOMAIN备份副本组TypeBACKUP副本组的类型是备份.DESTINATIONP5_FS_POOL目标存储池是(请参考存储池定义表).FREQUENCY0可以立即备份刚刚备份过的文件VEREXISTS2在客户机文件系统上存在的文件最多保留的2个备份版本VERDELETED1在客户机文件系统上不存在的文件最多保留的1个备份版本RETEXTRA30当备份版本到期后30天删除.RETONLY60从客户机上删除的文件保留最新的版本60天MODEAbsolute不管上次备份的文件是否改变都进行备份SERIALIZATIONStatic备份没有正在被修改文件并仅尝试一次策略域: P5_ORA_DOMAIN备份副本组TypeBACKUP副本组的类型是备份.DESTINATIONP5_ORA_POOL目标存储池是(请参考存储池定义表).FREQUENCY0可以立即备份刚刚备份过的文件VEREXISTS1在客户机文件系统上存在的文件最多保留的2个备份版本VERDELETED0在客户机文件系统上不存在的文件最多保留的1个备份版本RETEXTRA0当备份版本到期后立即删除.RETONLY0从客户机上删除的文件保留最新的版本60天MODEAbsolute不管上次备份的文件是否改变都进行备份SERIALIZATIONStatic备份没有正在被修改文件并仅尝试一次15 4.3节点配置Node namepasswordPolicy domainnoteP550_FSp550_fsP5_FS_DOMAIN550文件系统备份P550_TDPOp550_tdpoP5_ORA_DOMAIN550 Oracle备份P570_FSp570_fsP5_FS_DOMAIN570文件系统备份P570_TDPOp570_tdpoP5_ORA_DOMAIN570 Oracle备份16 4.4存储池配置POOL nameVOLUMEP5_FS_POOLZY9582,ZY9583P5_ORA_POOLZY9595,ZY9596,ZY9597,ZY9598,ZY959917 五、Oracle 备份策略，调度和备份脚本18 5.1 备份策略和调度每周日凌晨1点增量0 备份，周4 凌晨1点增量1备份，周一，二，三，五，六凌晨1点做增量2备份 。每天每隔4个小时做一次归档日志的备份。每天凌晨5点删除15天以前的归档，每天凌晨6点删除15天前的DB备份。查看oracle 用户的调度 crontab l0 1 * * 0 /oracle/rmanscript/incr0.sh &0 1 * * 4 /oracle/rmanscript/incr1.sh &0 1 * * 1,2,3,5,6 /oracle/rmanscript/incr2.sh &0 5 * * * /oracle/rmanscript/dele_arch.sh &0 6 * * * /oracle/rmanscript/dele_tape.sh &0 4,8,12,16,20 * * * /oracle/rmanscript/arch.sh &19 5.2 备份脚本20 5.2.1 incr0.sh 增量0备份. /oracle/.profiletarget=target /rcvcat=catalog rman/rmanrman9i# Get the current time for constructing a fairly unique filename in /tmp:time=date +%m%d%H# Construct filenames using $time for uniqueness:cmdfile=/oracle/rmanscript/log/incr0_$time.rcvmsglog=/oracle/rmanscript/log/incr0_$time.logcat $cmdfilerun allocate channel sbt1 type SBT_TAPE; resync catalog; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1)； backup format cf_%s_%p (current controlfile); backup incremental level 0 filesperset 10 tag incr_level_0 format incr0_%u_%p_%c database; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1) release channel sbt1; EOFrman $target $rcvcat cmdfile $cmdfile msglog $msglogexit21 5.2.2 incr1.sh 增量1备份. /oracle/.profiletarget=target /rcvcat=catalog rman/rmanrman9i# Get the current time for constructing a fairly unique filename in /tmp:time=date +%m%d%H# Construct filenames using $time for uniqueness:cmdfile=/oracle/rmanscript/log/incr1_$time.rcvmsglog=/oracle/rmanscript/log/incr1_$time.logcat $cmdfilerunallocate channel sbt1 type SBT_TAPE;resync catalog; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1)； backup format cf_%s_%p (current controlfile); backup incremental level 1 filesperset 10 tag incr_level_1 format incr1_%u_%p_%c database; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1)； release channel sbt1; EOFrman $target $rcvcat cmdfile $cmdfile msglog $msglogexit22 5.2.3 incr2.sh 增量2备份. /oracle/.profiletarget=target /rcvcat=catalog rman/rmanrman9i# Get the current time for constructing a fairly unique filename in /tmp:time=date +%m%d%H# Construct filenames using $time for uniqueness:cmdfile=/oracle/rmanscript/log/incr2_$time.rcvmsglog=/oracle/rmanscript/log/incr2_$time.logcat $cmdfilerun allocate channel sbt1 type SBT_TAPE; resync catalog; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1)； backup format cf_%s_%p (current controlfile); backup incremental level 2 filesperset 10 tag incr_level_2 format incr2_%u_%p_%c database; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1) release channel sbt1; EOFrman $target $rcvcat cmdfile $cmdfile msglog $msglogexit23 5.2.4 arch.sh 归档日志备份. /oracle/.profiletarget=target /rcvcat=rcvcat rman/rmanrman9i# Get the current time for constructing a fairly unique filename in /tmp:time=date +%m%d%H# Construct filenames using $time for uniqueness:cmdfile=/oracle/rmanscript/log/arch_$time.rcvmsglog=/oracle/rmanscript/log/arch_$time.logcat $cmdfilerun allocate channel sbt1 type SBT_TAPE ; resync catalog; sql alter system archive log current ; backup filesperset 10 format arch_%s_%p (archivelog like /oradata/archivelog/% delete input channel sbt1); release channel sbt1;EOFrman $target $rcvcat cmdfile $cmdfile msglog $msglogexit24 5.2.5 del_arch.sh定期删除归档日志备份# Initialize default connect string variables:. /oracle/.profiletarget=target /rcvcat=rcvcat rman/rmanrman9itime=date +%m%d%H# Initialize filenames:obsolete_tape=/oracle/rmanscript/log/arch_tape_$time.log # list of obsolete tape backupscmdfile=/oracle/rmanscript/log/delete_arch$time.cmd # the generated RMAN commmand scriptdelete_log=/oracle/rmanscript/log/deleted_arch_$time.log # execution log from generated script# Get a list of obsolete tape files:rman msgno $target $catalog msglog $obsolete_tape /dev/nulllist backup of archivelog until time sysdate-15;exit;EOF# sed actions:del_bpiece=”-e /AVAILABLE/ s/(.* )(.*)$/change backuppiece 2 delete;/”#echo “allocate channel for delete type sbt_tape ;” $cmdfilegrep AVAILABLE $obsolete_tape | sed “$del_bpiece” $cmdfileecho “release channel;” $cmdfile# Execute the RMAN command file to delete the obsolete files:#rman msgno $target $rcvcat msglog $delete_log cmdfile $cmdfileexit25 5.2.6 del_tape.sh 定期删除数据库备份# Initialize default connect string variables:. /oracle/.profiletarget=target /rcvcat=catalog rman/rmanrman9itime=date +%m%d%H# Initialize filenames:obsolete_tape=/oracle/rmanscript/log/ob_tape_$time.log # list of obsolete tape backupscmdfile=/oracle/rmanscript/log/delete$time.cmd # the generated RMAN commmand scriptdelete_log=/oracle/rmanscript/log/deleted_$time.log # execution log from generated script# Get a list of obsolete tape files:rman msgno $target $catalog msglog $obsolete_tape /dev/nullreport obsolete redundancy=1 until time sysdate-15 device type sbt_tape;#report obsolete device type sbt_tape;exit;EOF# sed actions:del_bpiece=”-e /RMAN-06285/ s/(.* )(.*)$/change backuppiece 2 delete;/”echo “allocate channel for delete type sbt_tape ;” $cmdfilegrep RMAN-06285 $obsolete_tape | sed “$del_bpiece” $cmdfileecho “release channel;” $cmdfile# Execute the RMAN command file to delete the obsolete files:#rman msgno $target $rcvcat msglog $delete_log cmdfile $cmdfileexit26 六 FAQ27 1. 如何启动和停止TSM 服务器方法一：启动：进入/usr/tivoli/tsm/server/bin 目录输入命令 dsmserv 停止：在dsmserv 的提示符TSM:TSM下输入halt方法二：启动：进入/usr/tivoli/tsm/server/bin目录输入命令 nohup dsmserv&停止：ps ef | grep dsm 查看dsmserv 的进程号 kill 进程号tail f nohup.out 查看日志当机器重新启动时，TSM 服务器依靠/etc/inittab 中的自动启动28 2 如何启动管理命令行接口 直接在系统提示符下输入 dsmadmc 提示输入user id : 这里为admin 提示输入password 这里为 admin 然后进入TSM 管理命令行 若要更改admin的password 输入：update admin admin newpassword29 3如何启动WEB管理接口打开IE ，输入1:8041/ibm/console用户名：iscadmin口令 ：password如果打开页面无效进入/opt/IBM/ISC/PortalServer/bin 输入startISC.sh ISC_Portal30 4 如何进行文件系统的备份 直接在系统提示符下输入命令如： 备份/usr 目录及下面的子目录dsmc sel /usr/ -subdir=yes 单独备份/etc/host 文件 dsmc sel /etc/host31 5 如何查看备份 oracle连接rman rman target / catalog rman/rmanrman9i32 5.1概述可用的备份RMANlist backup summary;B 表示 backupF 表示 FULLA 表示 archive log0 1 表示 incremental backup33 5.2按备份类型列出备份RMANlist backup by file;按照 数据文件备份，归档日志备份，控制文件备份，服务器参数文件备份 列出34 5.3列出详细备份RMANlist backup；35 5.4列出表空间和数据文件备份list backup of tablespace 和list backup of datafile 输出和list backup 相似 如：list backup of tablespace user_tbs;list backup of datafile 3;36 5.5列出归档日志备份RMANlist archivelog all; 简要信息RMANlist backup of archivelog all; 详细信息37 5.6列出控制文件和服务器参数文件RMANlist backup of controfile;RMANlist backup of spfile;38 6如何进行数据库故障恢复如果安装配置了OEM 可以使用恢复向导进行恢复步骤1 startup mount2 restore database3 recover database4 alter database open resetlogs39 7 如何查看RMAN备份日志验证是否备份成功。rman 的备份日志放在/oracle/rmanscript/log 目录下，根据时间以及备份级别命名incr0_110915.log 表示11月9号15时做的增量0 备份查看日志如果日志结尾为Recovery Manager complete.表示该级别的备份成功如果日志包含如下：RMAN-00571: =RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =RMAN-00571: =表示有错误 需要更正。40 七 恢复当数据库出现故障 需要进行恢复，运行脚本restore.shsu oraclecd /rmanscript./restore.sh还原结束后，查看还原日志，看是否成功日志位于/oracle/rmanscript/log 目录下日志示例：Recovery Manager: Release .0 64bit ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database (not started)connected to recovery catalog databaseRMAN startup nomount;2 run3 4 allocate channel sbt1 type sbt_tape;5 restore controlfile;6 alter database mount;7 restore database;8 recover database;9 alter database open resetlogs;10 release channel sbt1;11 12Oracle instance startedTotal System Global Area 320308816 bytesFixed Size 742992 bytesVariable Size 285212672 bytesDatabase Buffers 33554432 bytesRedo Buffers 798720 bytesallocated channel: sbt1channel sbt1: sid=13 devtype=SBT_TAPEchannel sbt1: Tivoli Data Protection for Oracle: version Starting restore at 10-NOV-05channel sbt1: starting datafile backupset restorechannel sbt1: restoring controlfileoutput filename=/oradata/oratest/control01.ctlchannel sbt1: restored backup piece 1piece handle=oratestfull_03h3dd2p_1_1 tag=ORATEST_FULL params=NULLchannel sbt1: restore comple