TSM

Tivoli Storage Manager

Check

To view session information...

As root

dsmc query session

To get more detailed information about the configuration use...

dsmc query systeminfo

To view information about the next scheduled TSM backup...

dsmc query schedule
Note that TSM Server time may not be the same as your server time (especially true for servers in Amsterdam where TSM server time is CET but database server time is generally GMT)You can also see this information in the dsmsched.log file.On Windows this is in C:\Program Files\Tivoli\TSM\baclient

To view information about the most recent TSM backup...

dsmc query fi

For more detailed information about a specific file, use something like one of these examples... Note, in particular, the way a trailing slash changes the output...

dsmc query ba /flashrecovery/DBNAME/backupset/2018_05_15
dsmc query ba /flashrecovery/DBNAME/backupset/2018_05_15/o1_mf_annnn_TAG20180515T180002_fhp4jlw1_.bkp
dsmc query ba /flashrecovery/DBNAME/backupset/2018_05_15/
dsmc query ba /flashrecovery/DBNAME/backupset/

Note that wildcards can be used, but must be enclosed in quotes...

dsmc query ba /flashrecovery/DBNAME/backupset/"*"/
dsmc query ba "/flashrecovery/DBNAME/backupset/*/"

If you use the -detail option, you get more information...

dsmc query ba /flashrecovery/DBNAME/backupset/2018_05_15/ -detail

To view Exclusion information...

dsmc query inclexcl

Files to exclude (Oracle)

/u02

This filesystem contains the live database files. It is pointless backing these files up whilst the database is open as it will be impossible to bring the database to a consistent state using these files. To restore a database use the database backup and archived redo log files from tape and /fra.

/redoX

This filesystem contains online redo log files.

"The best way to back up the contents of the current online log is to archive it, then back up the archived log. Oracle recommends you do not copy a current online log, because when you do so, and then restore that copy, the copy will appear as the end of the redo thread. However, additional redo may have been generated in the thread. If you ever attempt to execute recovery supplying the redo log copy, recovery will erroneously detect the end of the redo thread and prematurely terminate, possibly corrupting the database."

https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch2.htm#424081


Downloads

  • Standard AIX Client - ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/client/v7r1/AIX/BA/v716/
  • TDP Oracle AIX - ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/tivoli-data-protection/oracle/aix/v552/