Difference between revisions of "TSM"
From dbawiki
(→Query the archive to see if a file is available in TSM) |
(→Query the archive to see if a file is available in TSM) |
||
| Line 10: | Line 10: | ||
dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*" | dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*" | ||
</pre> | </pre> | ||
| − | Query all the files sent to the monthly node | + | Query all the files sent to the monthly node since start of FEB 2013 (displaying dates in YYYY-MM-DD format) |
<pre> | <pre> | ||
dsmc q ar -date=3 -fromdate=2013-02-01 -subdir=yes -se=SO_U_`uname -n`_ORX_M_BAX "/oracle/export/*"</pre> | dsmc q ar -date=3 -fromdate=2013-02-01 -subdir=yes -se=SO_U_`uname -n`_ORX_M_BAX "/oracle/export/*"</pre> | ||
Revision as of 15:26, 14 February 2013
Contents
Tivoli Storage Management
Send a file to TSM
dsmc archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_201301030007_01.dmp"
Query the archive to see if a file is available in TSM
dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
Query all the files sent to the monthly node since start of FEB 2013 (displaying dates in YYYY-MM-DD format)
dsmc q ar -date=3 -fromdate=2013-02-01 -subdir=yes -se=SO_U_`uname -n`_ORX_M_BAX "/oracle/export/*"
List all export jobs on this TSM node
cd /oracle/export dsmc q ar -subdir=yes -se=SO_U_UBENOA26_ORX_D_BAX "expdp*"
Retrieve file from TSM
dsmc retrieve -pick -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
This opens an interactive window listing all files that match the file query (note the wildcard)
Files can be toggled on and off for recovery by pressing the number associated with the file then recover with the letter O.
