Loading....

Many DBA’s have to be familiar with TSM ( Tivoli Storage Manager) commands to backup files to tape or restore backups from tape.

To query backups – for example all compressed files with ‘.Z’ extension.

oracle:/u05/backup/test > dsmc q b -inactive ‘*.Z’

File

/u05/backup/TEST/20090702_0841.test_tables.dmp.Z

To Restore the file above –

dsmc restore -inactive /u05/backup/TEST/20090702_0841.ofsap_tables.dmp.Z

To backup permanently and retain for 2 years.

dsmc archive -archmc=RETAIN2YEARS -description=”test_remove” “/u05/backup/TEST/test_export.sh” -su=yes > test.log

The log for the output is written to test.log

To query all permanent archived backups under a particular directory –

dsmc query Archive -detail “/u05/backup/TEST/test_export.sh” -su=yes

To retrive the backup above

dsmc retrieve “/u05/backup/TEST/test_export.sh”

Retrieve function invoked.

— User Action is Required —
File /u05/backup/TEST/test_export.sh ‘ exists

Select an appropriate action
1. Replace this object
2. Replace all objects that already exist
3. Skip this object
4. Skip all objects that already exist
A. Abort this operation
Action [1,2,3,4,A] : 1
Action [1,2,3,4,A] : 1
Retrieving 472 /u05/backup/TEST/test_export.sh [Done]

Retrieve processing finished.

Please follow and like us:

Last Update: July 15, 2009  

July 15, 2009 110 Arjun Raja
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

,

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?