原版：TSM 6.1版本数据库备份与恢复步骤（Linux平台）

对于TSM 6.1来讲，与之前V5.5的备份和恢复方式是基本上是类似的，但为了使大家更加清晰的理解，以下给出了TSM 6.1基于linux平台上TSM数据库备份和恢复详细步骤，发给大家，做为参考！

1、Install TSM Server 6.1 based on linux platform
2、Config TSM Instance，startup
Instance name为tsminst1
[root@test sqllib]# /opt/tivoli/tsm/server/bin/dsmserv
ANR7800I DSMSERV generated at 13:15:25 on Aug  5 2009.

Tivoli Storage Manager for Linux/x86_64
Version 6, Release 1, Level 2.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2009.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR7801I Subsystem process ID is 15814.
ANR0900I Processing options file /tsm/inst1/dsmserv.opt.
ANR7814I Using instance directory /tsm/inst1.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR1380I The buffer pool monitor switch is enabled.
ANR1637W Error (Write error) occurred initializing the server machine GUID.
ANR2100I Activity log process has started.
ANR4726I The NAS-NDMP support module has been loaded.
ANR1794W TSM SAN discovery is disabled by options.
ANR0984I Process 1 for EXPIRE INVENTORY (Automatic) started in the BACKGROUND
at 12:46:31 AM.
ANR0811I Inventory client file expiration started as process 1.
ANR2803I License manager started.
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
1500.
ANR0167I Inventory file expiration process 1 processed for 0 minutes.
ANR0812I Inventory file expiration process 1 completed: processed 0 nodes,
examined 0 objects, deleting 0 backup objects, 0 archive objects, 0 DB backup
volumes, and 0 recovery plan files. 0 objects were retried and 0 errors were
encountered.
ANR0985I Process 1 for EXPIRE INVENTORY (Automatic) running in the BACKGROUND
completed with completion state SUCCESS at 12:46:32 AM.
ANR2560I Schedule manager started.
ANR0993I Server initialization complete.
ANR0916I TIVOLI STORAGE MANAGER distributed by Tivoli is now ready for use.
TSM:TEST>
ANR2841W Server is NOT IN COMPLIANCE with license terms.
3、Database defined information
TSM:TEST>
q db f=d
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DB f=d

                 Database Name: TSMDB1
Total Size of File System (MB): 47,520
    Space Used by Database(MB): 448
     Free Space Available (MB): 33,961
              Page Size(Bytes):
                   Total Pages: 32,776
                  Usable Pages: 32,504
                    Used Pages: 24,084
                    Free Pages: 8,420
         Buffer Pool Hit Ratio: 97.3
         Total Buffer Requests: 51,797
                Sort Overflows: 0
               Lock Escalation: 0
       Package Cache Hit Ratio: 55.0
  Last Database Reorganization:
        Full Device Class Name:
  Incrementals Since Last Full: 0
Last Complete Backup Date/Time:


TSM:TEST>
q dbspace
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DBSPACE

                      Location: /tsmdb001
Total Size of File System (MB): 47,519.80
Space Used on File System (MB): 13,494.71
     Free Space Available (MB): 16,980.54

                      Location: /tsmdb002
Total Size of File System (MB): 47,519.80
Space Used on File System (MB): 13,494.71
     Free Space Available (MB): 16,980.54



TSM:TEST>
q log
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY LOG

    Total          Used          Free
Space(MB)     Space(MB)     Space(MB)
---------     ---------     ---------
    2,048          2.68      2,037.32

TSM:TEST>
q log f=d
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY LOG f=d

               Total Space(MB): 2,048
                Used Space(MB): 2.68
                Free Space(MB): 2,037.32
          Active Log Directory: /tsmlog
          Mirror Log Directory:
Archive Failover Log Directory:
         Archive Log Directory: /tsmarchlog


4、TSM server option file informaton
[root@test inst1]# more dsmserv.opt
* --------------------------------------------------------------- *
* This file was created by the TSM Instance Configuration Utility *
* --------------------------------------------------------------- *
COMMMethod    TCPIP
TCPPort 1500
DEVCONFIG     devconf.dat
VOLUMEHISTORY volhist.dat
LANGUAGE AMENG
TCPADMINPort 1500
ACTIVELOGDirectory    /tsmlog
ARCHLOGDirectory    /tsmarchlog







5、create file device  class for using database backup
TSM:TEST>
q dev filedev
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DEVCLASS filedev

Device       Device        Storage    Device       Format     Est/Max     Mount
Class        Access           Pool    Type                   Capacity     Limit
Name         Strategy        Count                               (MB)   
---------    ----------    -------    ---------    ------    --------    ------
FILEDEV      Sequential          0    FILE         DRIVE        400.0        20

TSM:TEST>

6、use "backup db" command to implement backup database
TSM:TEST>
backup db type=full dev=filedev
ANR2017I Administrator SERVER_CONSOLE issued command: BACKUP DB type=full
dev=filedev
ANR4559I Backup DB is in progress.
ANR0984I Process 3 for DATABASE BACKUP started in the BACKGROUND at 12:59:59
AM.
ANR2280I Full database backup started as process 3.
TSM:TEST>
ANR0406I Session 3 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (Tcp/Ip
127.0.0.1(33434)).
ANR8340I FILE volume /vol/55539599.DBV mounted.
ANR0511I Session 3 opened output volume /vol/55539599.DBV.
ANR1360I Output volume /vol/55539599.DBV opened (sequence number 1).
ANR1361I Output volume /vol/55539599.DBV closed.
ANR0514I Session 3 closed volume /vol/55539599.DBV.
ANR0403I Session 3 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
ANR2841W Server is NOT IN COMPLIANCE with license terms.
ANR0406I Session 4 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (Tcp/Ip
127.0.0.1(33435)).
ANR8340I FILE volume /vol/55539627.DBV mounted.
ANR0511I Session 4 opened output volume /vol/55539627.DBV.
ANR1360I Output volume /vol/55539627.DBV opened (sequence number 1).
ANR1361I Output volume /vol/55539627.DBV closed.
ANR0514I Session 4 closed volume /vol/55539627.DBV.
ANR0403I Session 4 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
ANR2841W Server is NOT IN COMPLIANCE with license terms.
ANR4550I Full database backup (process 3) completed.
ANR0985I Process 3 for DATABASE BACKUP running in the BACKGROUND completed with
completion state SUCCESS at 01:00:27 AM.


7、use "query volhistory" command to query  backup information
TSM:TEST>
q volh
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY VOLHISTORY

                             Date/Time: 10/15/2009 12:59:59 AM
                           Volume Type: BACKUPFULL
                         Backup Series: 1
                      Backup Operation: 0
                            Volume Seq: 1
                          Device Class: FILEDEV
                           Volume Name: /vol/55539599.DBV
                       Volume Location:
                               Command:
               Database Backup ID High: 0
                Database Backup ID LOW: 1,026
         Database Backup Home Position: 0
                   Database Backup HLA: /NODE0000/
                   Database Backup LLA: FULL_BACKUP.20091015005959.1
Database Backup Total Data Bytes (MB) : 328.64
Database Backup total Log Bytes (MB) : 4.03
        Database Backup Block Num High: -1
         Database Backup Block Num Low: -1

                             Date/Time: 10/15/2009 12:59:59 AM
                           Volume Type: BACKUPFULL
                         Backup Series: 1
                      Backup Operation: 0
                            Volume Seq: 2
                          Device Class: FILEDEV
                           Volume Name: /vol/55539627.DBV
                       Volume Location:
                               Command:
               Database Backup ID High: 0
                Database Backup ID LOW: 1,027
         Database Backup Home Position: 0
                   Database Backup HLA: /NODE0000/
                   Database Backup LLA: FULL_BACKUP.20091015005959.2
Database Backup Total Data Bytes (MB) : 328.64
Database Backup total Log Bytes (MB) : 4.03
        Database Backup Block Num High: -1
         Database Backup Block Num Low: -1


TSM:TEST>


8、backup device configuration by using "backup dev" command
TSM:TEST>
backup devconfig file=/vol/devconfig.out
ANR2017I Administrator SERVER_CONSOLE issued command: BACKUP DEVCONFIG
file=/vol/devconfig.out
ANR2393I BACKUP DEVCONFIG: Server device configuration information was written
to /vol/devconfig.out.

8、backup volume history file by using "backup volhistory" command
TSM:TEST>
backup volh file=/vol/volhist.out
ANR2017I Administrator SERVER_CONSOLE issued command: BACKUP VOLHISTORY
file=/vol/volhist.out
ANR2462I BACKUP VOLHISTORY: Server sequential volume history information was
written to /vol/volhist.out.
TSM:TEST>收起