Tivoli Storage Manager: Virtual Node Restore

Recently one of my colleague asking how to restore backup from client A to client B using TSM Virtual Node. I think I just wrote working guide here so the others can read as well.

SENARIO:
Restore all sys*.dat files under directory /u02/oradata/ on ORAPROD (Client A) to directory /staging/proj04/oradata/ on ORADEVE (Client B). Backup need to be restore from 20/10/2007 until 26/10/2007

Client A = ORAPROD
Client A's Backup Server = TSM_SERVER_US <----- Get from dsm.opt file under ORAPROD

Client B = ORADEVE
Client B's Backup Server = TSM_SERVER_EU <----- Get from dsm.opt file under ORADEVE

Note:
dsm.sys - the file defines all TSM Backup Server client configuration option required.
dsm.opt - this file contain/determine which TSM Backup Server should client contact or backup to.

1. Check backup on ORAPROD (client A) either exist or not (this case within certain period):
   
   dsmc q b -fromdate=10/20/07 -todate=10/26/07 -inactive "/u02/oradata/sys*.dat"
   
   
2. Confirmed backup available, get which TSM backup server ORAPROD (client A) backup to and get all the TSM Backup Server client configuration option.
   
   # grep -i servername dsm.opt
   SERVERNAME TSM_SERVER_US
   
   # cat dsm.sys
   SERVERNAME TSM_SERVER_US
   COMMMETHOD TCPIP
   TCPPORT 1500
   TCPSERVERADDRESS tsm-us.palo-alto.com
   PASSWORDACCESS generate
   SCHEDMODE prompted
   COMPRESSION on
   SCHEDLOGRETENTION 14
   SCHEDLOGNAME /var/log/tsm/schedule.log
   ERRORLOGNAME /local/log/tsm/error.log
   TCPBUFFSIZE 512
   TXNBYTELIMIT 25600
   INCLEXC /opt/tivoli/tsm/client/ba/bin/inclexcl
   RESOURCEUTILIZATION 4
   TCPNODELAY Yes
   
   
3. Then login to ORADEVE (client B) and add above ORAPROD's TSM Backup Server client configuration option to dsm.sys on ORADEVE (client B).
   
   # cat dsm.sys
   SERVERNAME TSM_SERVER_US
   COMMMETHOD TCPIP
   TCPPORT 1500
   TCPSERVERADDRESS tsm-us.palo-alto.com
   PASSWORDACCESS generate
   SCHEDMODE prompted
   COMPRESSION on
   SCHEDLOGRETENTION 14
   SCHEDLOGNAME /var/log/tsm/schedule.log
   ERRORLOGNAME /local/log/tsm/error.log
   TCPBUFFSIZE 512
   TXNBYTELIMIT 25600
   INCLEXC /opt/tivoli/tsm/client/ba/bin/inclexcl
   RESOURCEUTILIZATION 4
   TCPNODELAY Yes
   
   
4. On ORADEVE (client B), log on Tivoli Client using ORAPROD (client A) credential by issuing below virtual node option:
   
   dsmc -servername=TSM_SERVER_US -virtualnodename=ORAPROD
   
   
5. Restore desire ORAPROD (client A) backup files /u02/oradata/sys*.dat to specific directory /local/IOPLPR1/arch/ on ORADEVE (client B):
   
   restore -fromdate=10/28/2007 -todate=10/29/2007 -inactive "/u02/oradata/sys*.dat" /staging/proj04/oradata/
   
   
6. TARAAA!!!