Question & Answer
Question
Need steps to restore the Tivoli Storage Manager OffLine DB Backup per backup steps in knowledge item: http://www.ibm.com/support/docview.wss?uid=swg21668753
Cause
OffLine DB Backup have been taken. Need OffLine DB Restore steps
Answer
Overview of OffLine DB Backup steps:
From the instance owner login, do the following DB2 commands:
$ db2start
$ db2 backup db TSMDB1 to /tmp/dbbackup
Example messages:
Backup successful. The timestamp for this backup image is: 20100129142928
The DB backup image created for this example in the current directory: TSMDB1.0.tsminst1.NODE0000.CATN0000.20100129142928.001
RESTORE STEPS:
DB2 restore command:
$ db2 restore db TSMDB1 from /tmp/dbbackup taken at 20100129142928
Question before the restore:
SQL2539W Warning! Restoring to an existing database that is the same as the backup image database. The database files will be deleted.
Do you want to continue ? (y/n) y
Successful restore message:
DB20000I The RESTORE DATABASE command completed successfully.
$ db2 rollforward db TSMDB1 stop
SQL1032N No start database manager command was issued. SQLSTATE=57019
$ db2start
01/29/2010 14:58:48 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
Do the following command again and wait for successful message:
$db2 rollforward db TSMDB1 stop
Rollforward Status
Input database alias = TSMDB1
Number of nodes have returned status = 1
Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2010-01-29-22.29.51.000000 UTC
DB20000I The ROLLFORWARD command completed successfully.
At this time, start the Tivoli Storage Manager server.
A Query DB shows the last OnLine DB Backup (Last Complete Backup Date/Time:). The server is not aware of the OffLine DB Backup.
TSM:VENTANA>
q db f=d
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DB f=d
Database Name: TSMDB1
Total Size of File System (MB): 285,985
Space Used by Database(MB): 7,200
Free Space Available (MB): 278,264
Total Pages: 354,308
Usable Pages: 354,172
Used Pages: 347,516
Free Pages: 6,656
Buffer Pool Hit Ratio: 96.7
Total Buffer Requests: 70,361
Sort Overflows: 0
Lock Escalation: 0
Package Cache Hit Ratio: 86.4
Last Database Reorganization: 01/29/2010 16:16:29
Full Device Class Name: FILE
Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 01/29/2010 15:00:32
Related Information
Product Synonym
TSM IBM Spectrum Protect
Was this topic helpful?
Document Information
More support for:
Tivoli Storage Manager
Software version:
6.3, 7.1
Document number:
402721
Modified date:
17 June 2018
UID
swg21424631