Tuesday, April 2, 2013

TSM_101 for DBA's

 Some handy commands to deal with storage management layers.

TSM
  • To query if a particular backup file or a regular file on server has been backed up to TSM backup server >>>>>>>> dsmc q b "location/filename"
  • To query if a particular archivelog on server has been backed up to TSM backup server >>>>>>>>> dsmc q ar "location/archivelogname"
  • To restore backups from TSM backup server >>>>> dsmc restore "location/filename"
  • To restore backups from TSM backup server to a different directory >> dsmc restore "source_directory_location" "destination_directory_location"
  • To restore archivelogs from TSM backup server >>>>> dsmc ret "location/archivelogname"
  • To restore from Older backups from TSM backup server  >>> dsmc  restore -inactive -pick -subdir=yes "location/*" -- It lists a series of files, just type the line number & enter O, it will restore.
  • To query older backups from TSM backup server >>> dsmc q b -ina -subdir=yes "locationondisk"
  • Say a file sample.txt has been backed on server lnx101 & we would like to restore this on server lnx202, there are two approaches
    • One is to restore it on lnx101 & scp those files to lnx202
    • Second is to restore it on lnx202 directly from tsm backup server, for this from lnx202 connect to tsm command line
    • dsmc -se=ip_of_tsmbackupserver vitrualnode=lnx101                                                          here ip_of_tsmbackupserver can be found in dsm.opt file
    • at tsm command line we can use the following commands                                             tsm>restore -ina -subdir=yes "location_on_source" "location_where_we_want_on_target"

No comments:

Post a Comment