Tivoli Storage Manager Server

Query TSM Schedule for node :

q sch * n=*<NODENAME>*
q sch * <SCHEDULENAME> f=d

Create TSM Schedule :

define schedule TSM_DOMAIN HOT_BACKUP description="Hot backup" starttime=18:45:00 duration=4 period=1
define schedule TSM_DOMAIN DAILY_BACKUP description="Backup run every night" starttime=00:00:00 duration=4 period=1
define schedule TSM_DOMAIN NOON_BACKUP description="Backup at 12:00 (laptops etc.)" starttime=12:00:00 dayofweek=weekday duration=4 period=1
 
define association TSM_DOMAIN HOT_BACKUP tsmsrv01

Assign new volume in storage pool :

q stgpool
def vol backuppool G:\backuppool\bk1.dsm f=10000
def vol archivepool I:\archivepool\arc1.dsm f=10000
q stgpool

Create new policy domain,policy set, management class for DB backups (Oracle/DB2) :

define domain DB2PD DESCription="DB2 policy domain"
define policyset DB2PD DB2POL description="DB2 policy"
define mgmtclass DB2PD DB2POL DB2BKPCLASS1 description="DB2 Backups"
assign defmgmtclass DB2PD DB2POL DB2BKPCLASS1
 
define copygroup DB2PD DB2POL DB2BKPCLASS1 destination=BACKUPPOOL verexists=1 verdeleted=0 retextra=0 retonly=0
define copygroup DB2PD DB2POL DB2BKPCLASS1 type=archive destination=ARCHIVEPOOL retver=nolimit
 
validate policyset DB2PD DB2POL
activate policyset DB2PD DB2POL

Register node for DB (Oracle/DB2) :

register node DB2ASN01_DB2INST1 broodi1 domain=DB2PD archdelete=yes backdelete=yes

API Settings :

export DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm_db2inst1.opt
export DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
export DSMI_LOG=/home/db2inst1/ibm_dba/logs

/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt :

***************************************************************************
* IBM Tivoli Storage Manager for Databases
*    Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************

DSMI_ORC_CONFIG    /opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG           /opt/tivoli/tsm/client/oracle/bin64

TDPO_FS            /ORADEV01ORA
TDPO_NODE           ORADEV01
TDPO_OWNER         root
TDPO_PSWDPATH      /opt/tivoli/tsm/client/oracle/bin64

TDPO_DATE_FMT      1
TDPO_NUM_FMT       1
TDPO_TIME_FMT      1

*TDPO_MGMT_CLASS_2   mgmtclass2
*TDPO_MGMT_CLASS_3   mgmtclass3
*TDPO_MGMT_CLASS_4   mgmtclass4

/opt/tivoli/tsm/client/api/bin64/dsm.opt :

Servername TSMSRV01_ORACLE

/opt/tivoli/tsm/client/api/bin64/dsm.sys :

SErvername  TSMSRV01_ORACLE
   COMMMethod         TCPip
   TCPPort            1500
   TCPServeraddress   tsmsrv01-bck
   Nodename	      ORADEV01
   Passwordaccess     prompt

Create password file and verify TDP environment :

/opt/tivoli/tsm/client/oracle/bin64/tdpoconf passw
/opt/tivoli/tsm/client/oracle/bin64/tdpoconf SHOWENVironment

Selective backup of FS :

dsmc selective /path/to/be/backed/* -subdir=yes

Restore FS :

dsmc restore /path/to/be/restored/* -subdir=yes