Re: PIT from incomplete backup

==> On Fri, 2 Sep 2005 10:31:16 -0500, fred johanson <fred AT UCHICAGO DOT EDU> 
said:

> We lost a large WinNT machine, :f alone is 838 Gb 90%+ full.  There was a
> complete backup on Friday night, but the Monday night backup never finished
> before the box died.  My thought was to restore to the last complete backup
> and let the users (actually, their admins) restore individually the lost
> work from Monday.  About 600 Gb restored over a two day span.  But now it's
> been suggested that we restore to Monday instead.  So what happens with all
> those files already restored?  Will TSM regard them as already on disk and
> ask to bypass them?  Or will TSM want to start over from scratch?


> We have a long restore window over the weekend, so any thoughts will be
> much appreciated.

What you want to do is prevent TSM from doing all the comparison math in its'
database.  You can only start the second restore after the first completes, so
take the time between now and then to figure out which files you need.

If you run a 'Q backup' redirected to a file, you can dump a list of the
active bits.

# dsmc q backup ./ -subdir=yes
Tivoli Storage Manager
Command Line Backup/Archive Client Interface - Version 5, Release 1, Level 7.0
(C) Copyright IBM Corporation 1990, 2004 All Rights Reserved.

Node Name: FS-HOME02
Session established with server INT: AIX-RS/6000
  Server Version 5, Release 2, Level 2.1
  Server date/time: 09/02/05   20:01:47  Last access: 09/02/05   20:01:34

             Size      Backup Date        Mgmt Class A/I File
             ----      -----------        ---------- --- ----
         1,274  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/43packagelist
         7,279  B  07/05/05   17:18:25    DEFAULT     A  
/export/home02/asr/tmp/4446.1.1.html
       185,344  B  07/05/05   17:18:25    DEFAULT     A  
/export/home02/asr/tmp/4446.1.2.msword
       230,515  B  07/05/05   17:18:25    DEFAULT     A  
/export/home02/asr/tmp/4446.1.3.jpeg
           222  B  07/05/05   17:18:25    DEFAULT     A  
/export/home02/asr/tmp/4446.1.4.html
           657  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4521.1.1.html
           611  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4652.1.plain
         3,903  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4652.3.plain
           108  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4665.1.plain
         2,490  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4897.1.1.html
           886  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4936.1.1.html
        22,016  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4936.2.msword
         2,057  B  09/13/04   15:10:22    DEFAULT     A  
/export/home02/asr/tmp/4938.1.html

[...]

Then pick out the files which have a backup date on monday.  These are the
overlay you're going to need to restore.

Cut out the filenames, stick them in a file, and then your second restore is

dsmc restore -filelist=/where/ever -replace=all


I've found that doing the file selection math outside TSM can dramatically
speed things up.



- Allen S. Rout