Hi, On 3/5/2007 10:00 PM, Alan Davis wrote: > In order to possibly avoid another 6 days of backing up my archive that > errored out - > > What are my options for being able to start an incremental backup using > the file/job records that are already in the db and complete the backup > of the rest of the files in another job?
Hard question... Without lots of manual work - none. > There was no bootstrap file written and the job completion messages says > that 0 FD files were written and 0 SD files were written but 29 volume > names are listed. > > The database has 3,745,376 rows in the 'file' table for the jobid. > > The 'job' table has this entry: > > jobid;"job";"name";"type";"level";"clientid";"jobstatus";"schedtime";"st > arttime";"endtime";"realendtime";"jobtdate";"volsessionid";"volsessionti > me";"jobfiles";"jobbytes";"joberrors";"jobmissingfiles";"poolid";"filese > tid";"purgedfiles";"hasbase";"priorjobid" > > 291;"LiveArchiveJob.2007-02-26_17.16.43"; > "LiveArchiveJob";"B";"F";"3";"f";"2007-02-26 17:16:38"; > "2007-02-26 17:16:45";"2007-03-04 17:17:05"; > "2007-03-04 17:17:05";"1173046625";"64";"1170710685"; > "0";"0";"0";"0";"3";"17";"0";"0";"0" > > It's clear that the db record for the job doesn't get updated with the > number of files written, etc. > > Is it possible, given the other data that I have available, to > synthesize enough of the job record entry that it could be marked 'T' > (terminated normally) so it can be used as the basis for an incremental > job? Weeelll... possibly. I never tried that, and my first suggestion would have been to use bscan, but that would require to read all 29 tapes which I don't find very appealing. Anyway, you could try to set the status of the Job to Ok - that would be 'T'. Then, you'd have ensure all the remaining files are picked up at the next backup, which will be the really hard part. The easiest solution would be to touch all the files not backed up yet to a mtime after the job started. As you have the files backed up in the catalog, some scripting could do it. I'd also touch the last file from the job, because it seems likely that this one is not transferred completely. You'll lose some file metadata with this approach, so depending on your needs it would not be good choice. Alternatively, rename the original directory or directories you backed up to some new name, hardlink all the files not yet backed up to a new directory (structure) with the same name, and run an incremental on that. Since Bacula does not keep track of file deletions, that should work (now that much discussed weakness suddenly becomes a feature :-) > I know that there is some risk that one or more files aren't > accounted for, but the data that is on tape should be good. If I have to > later track down a file or two that's an acceptable trade-off. > > The pieces that seem to be missing are possibly the mediaid and > obviously the job records. I think these can be construced rather easily, but getting the other files into the backup will require much thought... I don't know if Bacula requires a "perfect" JobMedia table. It might be possible to only insert minimal records, at the cost of losing the ability to quickly position the tape. In my catalog, the StartBlock seems to always be zero, for example. I'd really suggest you wait if Kern or someone else with a better understanding of the catalog finds the time to answer :-) Arno > > ---- > Alan Davis > Senior Architect > Ruckus Network, Inc. > 703.464.6578 (o) > 410.365.7175 (m) > [EMAIL PROTECTED] > alancdavis AIM > > > > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
