Tivoli Storage Manager simple restore

Sample restore from command line Tivoli Storage Manager. Run as root.

1ps -ef | grep dsm  #here look to see if 'optfile' is set
2cd /mydir
3dsmc -optfile=/opt/tivoli/tsm/client/ba/bin/dsm-ora.opt
4tsm> restore /mydir/*.dbf -inactive -pick
5tsm> 1   #here choose which file number you want
6tsm> 2   #choose another file if needed
7tsm> o   #o='ok'
8tsm> quit

You should specify an ‘optfile’ at line 3 only if you saw it in the output of line 1.

Other useful options:

List backup files:

`1`	`tsm>q backup` `"/opt/fc-lun1/*"` `-inactive -subdir=yes`

Restore (note how second mention directory name is shorter):

`1`	`tsm> restore` `"/opt/fc-lun1/MYDB/mydb/*"` `/ORA_DISK/MYDB/infprod/ -subdir=yes` `–pick`

Select all files:

`1`	`tsm> +` `# to select all files`

October 28, 2010
Posted in Linux, Rman

Andrew Fraser DBA

Oracle and SQL Server DBA

Tivoli Storage Manager simple restore

Leave a Reply