Results 1 to 4 of 4

Threaded View

  1. #1
    Newcomer
    Join Date
    Jul 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default TSM Database backup and DR restore failures

    Hi,

    I am facing issues while trying to restore TSM (DR tests) database at DR location and would appreciate any help.

    My TSM server (version - 6.2.3.0) is installed on Aix 6.1. We are in the midst of moving away from tape library to a data domain. The primary site has a mix of tape library and data domain whilst the secondary just has a data domain (Non VTL in a NFS mode).

    This is my first ever attempt at a TSM database restore hence I do not know if I missed a step or two. I am listing out details of what I have done:

    At the DR location
    1. Install TSM version 6.2.3.0
    2. configure a new instance: /opt/tivoli/tsm/db2/instance/db2icrt -a SERVER -u tsminst1 tsminst1
    db2 update dbm cfg using dftdbpath /home/tsminst1

    /opt/tivoli/tsm/server/bin/dsmserv loadformat


    3. Create a snapshot database backup to fileclass at the primary location . Full backups generally go to tape device class.

    4. Copied the dsmserv.opt,volhist and devconf. Modified the devconf to include only the data domain NFS mounts and removed any references to tapes

    5. DataDomain async copies the database and the storage pools to the DataDomain at secondary. I took a snapshot and pointed the same to my new Aix server with mount points similar to that on the primary server. So now I have the database backup and volumes at the remote location

    6. Uninstalled the older version of TSM clients which comes default with TSM and installed versions similar to the one at primary.

    7. manually setup the /home/tsminst1/sqllib/userprofile file
    export DSMI_CONFIG=/home/tsminst1/tsmdbmgr.opt
    export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
    export DSMI_LOG=/home/tsminst1


    8. Updated dsm.opt,dsm.sys for both api and ba clients, is this step needed?

    9. Performed a database recovery which fails:

    su - tsminst1
    /opt/tivoli/tsm/server/bin/dsmserv -i /home/tsminst1 restore db todate=07/08/2012 totime=13:17:35 source=dbs

    :::
    :::
    ANR7811I Using instance directory /home/tsminst1.
    ANR4726I The Async I/O support module has been loaded.
    ANR4726I The ICC support module has been loaded.
    ANR1636W The server machine GUID changed: old value (), new value (d4.b5.71.c5
    .19.c4.11.e1.b6.7a.08.63.0n.72.b4.f7).
    ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
    1500.
    rm: 0653-611 Directory /tsm/tsm_archive_log is not empty.
    mkdir: 0653-358 Cannot create /tsm/tsm_archive_log.
    /tsm/tsm_archive_log: Do not specify an existing file.
    ANR4916I Starting point-in-time database restore snapshot to date 07/18/12
    13:17:35.
    ANR4620I Database backup series 273 operation 0 device class DD_FILECLASS_DB_B
    ACKUP.
    ANR8340I FILE volume /tsm/datadomain/db_backup/42613860.DSS mounted.
    ANR1363I Input volume /tsm/datadomain/db_backup/42613860.DSS opened (sequence
    number 1).
    ANR1364I Input volume /tsm/datadomain/db_backup/42613860.DSS closed.
    ANR8340I FILE volume /tsm/datadomain/db_backup/42627357.DSS mounted.
    ANR1363I Input volume /tsm/datadomain/db_backup/42627357.DSS opened (sequence
    number 1).
    ANR1364I Input volume /tsm/datadomain/db_backup/42627357.DSS closed.
    ANR4638I Restore of backup series 273 operation 0 in progress.
    ANR0498W Session 1 refused for SERVERXX because restore DB is in progress.
    ANR2969E Database restore terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 136.


    Have I missed any of the steps?

    What could be wrong here I checked IBM codes but couldn't find any ref for the sqlerrmc?

    To try and fix this error, I even tried running DSMAPIPW on the DR test server but it failed with authentication failure and communication failure -50 tcpip.

    I guess it failed because of wrong password as I have never started the instance before I do not know of the current password!

    Thanks,
    Anito
    Last edited by anitosam; 07-19-2012 at 07:14 PM.

Similar Threads

  1. Majority of Backup Failures
    By chad_small in forum Backup / Archive Discussion
    Replies: 16
    Last Post: 12-13-2011, 06:28 PM
  2. Different Types of Backup Failures
    By ddjm in forum Backup / Archive Discussion
    Replies: 2
    Last Post: 02-26-2009, 07:10 AM
  3. Oracle Backup Failures
    By jkslider in forum TSM Client
    Replies: 2
    Last Post: 12-17-2008, 10:23 AM
  4. Scheduled backup failures for win2k3
    By jimperrin in forum Administrative Client
    Replies: 9
    Last Post: 06-30-2008, 12:04 PM
  5. Replies: 3
    Last Post: 03-11-2003, 03:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •