Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    New York
    Thanked 0 Times in 0 Posts

    Default Restore DB question

    So this weekend, I had major issues with my TSM server (5.5.3 on Windows 2008R2), that caused the system to halt.
    I couldn't pinpoint the cause because every time I think I found it, another error would surface.

    Turns out that initially, the logs may have filled, because starting the server in the foreground gave indications that the logs were overcommitted. I typically have safeguards for this in place, because even though I am still learning Tivoli on a daily basis, even I know better.

    So I then try to extend DB, but am now getting another error about not being able to read the .dsk file.

    After much troubleshooting and discovering more errors than solutions, I put in a PMR to IBM. After many hours and a multitude of trc logs and try this-try that, send me this and send me that. I was finally told that the only solution would be a db restore.

    So, turns out that my logs were corrupt, db pages were corrupt, and the for the finale, the volhist.out file was a) only a partial b) unusable.

    Performed db restore to previous date that was in the volhist, only a day and a half prior to failure, and it went without a hitch.
    I have mirrored db so once the server restarts after restore, the database resynchs to mirror, notices data has been added to db (via newer backup) and performs db backup at that time.

    So here's the question. Since everything is now back up to-date as of last actual backup schedules due to db mirror resynch, do I actually need to perform any type of "audit vol" as stated in the documentation, or can I just do a quick barcode scan on the library and go from there? Shouldn't everything be ok now and not need this audit? I didn't do a dumpdb, loaddb or anything like that, facilitating any severe changes.

    Am I correct in these assumptions??

    Thanks in advance for any advice

  2. #2
    Moderator Harry_Redl's Avatar
    Join Date
    Dec 2003
    Czech Republic
    Thanked 100 Times in 99 Posts

Similar Threads

  1. Another DB restore question...
    By epeterson in forum TSM Database
    Replies: 1
    Last Post: 10-13-2011, 02:46 PM
  2. solaris restore question
    By tsmhelum in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 04-19-2011, 10:22 AM
  3. Odd NTFS restore behaviour, and restore timing question
    By james.dean in forum Restore / Recovery Discussion
    Replies: 4
    Last Post: 11-24-2009, 05:45 PM
  4. Oracle DB restore question
    By itcsge in forum Restore / Recovery Discussion
    Replies: 0
    Last Post: 06-03-2009, 06:46 AM
  5. Image restore question
    By stroke4 in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 03-06-2006, 12:26 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