征文：TSM For BA/Oracle的典型实施文档-存储专区

征文：TSM For BA/Oracle的典型实施文档

作者：ITPUB ziz1206 编辑：李隽 2009-06-01 16:02 来源：IT168�

第2章配置TSM Server

2.1、安装TSM Server

2.1.1、下载TS3584 for AIX驱动

下载链接为ftp://ftp.software.ibm.com/storage/devdrvr/

2.1.2、安装TS3584驱动
1. 执行smitty install 进行安装

2.1.3、安装TSM Server 5.5.0.0 for AIX
1. 执行smitty install 进行安装

2.2、更新TSM Server配置

2.2.1、更新TSM Server参数
1、设置服务器名称及密码：
set servername tsmserver
set serverpassword password

2、注册许可证：
reg lic file=*.lic number=100
执行q lic来查看

3、设置日志模式：
set logmode rollforward

4、设置密码过期时间：
set PASSExp 9999

5、设置通信及空闲延时：
Setopt commtimeout 3600
Setopt idletimeout 60

6、设置其他参数：
vi /opt/tivoli/tsm/server/bin/dsmserv.opt
BUFPOOLSIZE 524288
LOGPOOLSIZE 2048
LANGUAGE zh_CN
DEVCONFIG /tsm/files/devconfig.out
VOLUMEHISTORY /tsm/files/volhistory.out

2.2.2、定义新数据库卷和日志卷及其镜像、触发
1、定义db卷及其镜像
define dbv /tsmfs/dbvol/db01.dsm formatsize=1000 wait=yes
define dbv /tsmfs/dbvol/db02.dsm formatsize=1000 wait=yes
define dbv /tsmfs/dbvol/db03.dsm formatsize=1000 wait=yes

extend db 3000
执行q dbv f=d来查询

2、定义log卷及其镜像
define logv /tsmfs/logvol/log01.dsm formatsize=1000 wait=yes
define logv /tsmfs/logvol/log02.dsm formatsize=1000 wait=yes
define logv /tsmfs/logvol/log03.dsm formatsize=1000 wait=yes
extend log 3000
执行q logv f=d来查询

3、定义扩展db和log的触发
define spacetrigger db fullpct=75 spaceexpansion=25 expansionprefix=/tsmfs/dbvol/ maximumsize=1000
define spacetrigger log fullpct=75 spaceexpansion=25 expansionprefix=/tsmfs/logvol/ maximumsize=1000
执行q spacetrigger db f=d和q spacetrigger log f=d来查询

4、定义备份db的触发
define dbbackuptrigger devclass=LTOCLASS logfullpct=60
2.2.3、定义磁带库、磁带机及其路径
def library 3584lib libtype=scsi shared=yes
def path tsmserver 3584lib srctype=server autodetect=yes desttype=library device=/dev/smc0 online=yes

def drive 3584lib 3580A element=autodetect online=yes
def drive 3584lib 3580B element=autodetect online=yes
def drive 3584lib 3580C element=autodetect online=yes
def drive 3584lib 3580D element=autodetect online=yes
def drive 3584lib 3580E element=autodetect online=yes
def drive 3584lib 3580F element=autodetect online=yes

def path tsmserver 3580A srctype=server autodetect=yes desttype=drive library=3584lib device=/dev/IBMtape0 online=yes

def path tsmserver 3580B srctype=server autodetect=yes desttype=drive library=3584lib device=/dev/IBMtape1 online=yes

def path tsmserver 3580C srctype=server autodetect=yes desttype=drive library=3584lib device=/dev/IBMtape2 online=yes

def path tsmserver 3580D srctype=server autodetect=yes desttype=drive library=3584lib device=/dev/IBMtape3 online=yes

def path tsmserver 3580E srctype=server autodetect=yes desttype=drive library=3584lib device=/dev/IBMtape4 online=yes

def path tsmserver 3580F srctype=server autodetect=yes desttype=drive library=3584lib device=/dev/IBMtape5 online=yes

2.2.4、定义设备类
define devclass TBKCLASS library=3584lib devtype=LTO
define devclass LTOCLASS library=3584lib devtype=LTO

2.2.5、给磁带标号
label libvolume 3584lib search=yes labelsource=barcode checkin=scratch overwrite=yes
可以通过q libv来查询

2.2.6、定义TSM服务器自动管理
tsm server数据库备份：
define schedule backup_tsmdb_file type=administrative cmd="backup db devclass=TBKCLASS type=full " starttime=07:00 active=yes description="Database backup using files"

tsm server重要文件备份：
define schedule backup_devconfig type=administrative cmd="backup devconfig filenames=/tsm/dbbackup/devconfig.new" starttime=09:00 active=yes description="backup devconfig using files"

define schedule backup_volhistory type=administrative cmd="backup volhistory filenames=/tsm/dbbackup/volhistory.new" starttime=09:30 active=yes description="backup volhistory using files"

tsm server 卷历史信息删除：
define schedule delete_volhistory type=administrative cmd="delete volhistory TODate=today-2 type=dbbackup" starttime=07:30 active=yes description="Volhistory backup"

tsm server 卷空间回收操作：
define schedule expire_inventory type=administrative cmd="expire inventory" startt=08:00 description="Inventory expiration"

2.2.7、定义TSM服务器自动加载服务和rman catalog db备份调度（待定）
1、 rman catalog db的备份：
crontab -e
##############TSM CLIENT SCHEDULE###########################################################
0 19 * * * /opt/oracle/scripts/exprman.sh>/dev/console 2>&1 #Export rman catalog at 19:00 everyday
0 21 * * * /tsm/script/fullfs.sh>/dev/console 2>&1 #FullBackup Files at 21:00 everyday

脚本exprman.sh内容
exp rman/rman owner=rman file=catalog_full.dmp log=catalog_full.log buffer=102400

脚本fullfs.sh内容
nohup /tsm/script/exprman.sh &
export LOGFILE=/tsm/log/`date +%m%d.%H%M`file_full.log
dsmc selective /tsm/dbbackup/ -subdir=yes>$LOGFILE
dsmc selective /opt/oracle/catalog_full.dmp>>$LOGFILE
nohup rm -rf /opt/oracle/catalog_full.dmp &

2.2.8、定义存储池
define stgpool FILE_TAPE_POOL LTOCLASS maxscratch=nolimit
define stgpool TAPE LTOCLASS maxscratch=nolimit

2.2.9、定义备份oracle和file的策略域
define domain FILE_DOMAIN descr="BACKUP WIN FILES"
define domain ORACLE_DOMAIN descr="BACKUP ORACLE FILES"

2.2.10、定义备份oracle和file的策略集
define policyset FILE_DOMAIN standard
define policyset ORACLE_DOMAIN standard

2.2.11、定义备份oracle和file的管理类
define MGMTCLASS FILE_DOMAIN standard standard SPACEMGTECHNIQUE=NONE AUTOMIGNONUSE=0 MIGREQUIRESBKUP=YES

define MGMTCLASS ORACLE_DOMAIN standard standard SPACEMGTECHNIQUE=NONE AUTOMIGNONUSE=0 MIGREQUIRESBKUP=YES

定义备份oracle和file的副本组
define COPYGROUP FILE_DOMAIN standard standard DESTINATION=FILE_TAPE_POOL FREQUENCY=0 VEREXISTS=2 VERDELETED=1 RETEXTRA=90 RETONLY=180 MODE=MODIFIED SERIALIZATION=SHRSTATIC

define COPYGROUP ORACLE_DOMAIN standard standard DESTINATION=TAPE_POOL FREQUENCY=0 VEREXISTS=5 VERDELETED=1 RETEXTRA=90 RETONLY=180 MODE=MODIFIED SERIALIZATION=SHRSTATIC

2.2.12、分配备份oracle和file的默认管理类
assign defmgmtclass FILE_DOMAIN standard standard
assign defmgmtclass ORACLE_DOMAIN standard standard

2.2.13、激活备份oracle和file的策略集
activate policyset FILE_DOMAIN standard
activate policyset ORACLE_DOMAIN standard
activate policyset ORA-DBPOLICY standard

2.2.14、定义客户端备份调度（oracle的完全备份）
2.2.15、定义调度与节点的关联
2.2.16、定义客户端调度服务
2.2.17、注册节点
reg node P570NODE password domain=FILE_DOMAIN passexp=0 backdelete=yes maxnummp=10
reg node DELLNODE password domain=FILE_DOMAIN passexp=0 backdelete=yes maxnummp=10
reg node P51ANODE password domain=FILE_DOMAIN passexp=0 backdelete=yes maxnummp=10
reg node ORACLENODE password domain=ORACLE_DOMAIN passexp=0 backdelete=yes maxnummp=10

第1页：第1章环境准备第2页：第2章配置TSM Server 第3页：第3章配置TSM Client 第4页：第4章配置TDPO FOR ORACLE 第5页：第5章 Oracle增量备份

关注我们