TSM
From dbawiki
Contents
Tivoli Storage Management
Query the archive to see if a file is available
dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
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 then recover.
Store a file to TSM
dsmc archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_201301030007_01.dmp"