Re: scripted log backup/recovery

Heinrich, Tilo wrote:

hello!

> > now, is it correct that the approach is this: scan the output of 
> > backup_history_list for the last log id that was succefully imported. 
> > then identify all logbackup-files with an extension that is 
> > numerically 
> > higher than this and recover_start <medium> <extension of 
> > file> for each 
> > of them.
>
>
> If you end log restores in between individual log files with
> recover_cancel, it might be needed to reapply one or more log backups
> more than once. So if you use recover_cancel in your script, you should
> use the "Used LOG Page"-value of db_restartinfo and the 8-th and 9-th
> column of backup_history_list and backup_history_listnext to find the
> log backup needed for continuing the log restore. The "Used LOG
> Page"-value must be in the interval given of 8-th and 9-th column of
> backup_history_list/next.

this shiver that went down my spine makes me never use recover_cancel. 
my script just wont support that :)

thank you very much again,
        Raimund

--
7. RedDot Anwendertagung der RedDot Usergroup e.V. am 31.1.2005
Pinuts präsentiert neue Entwicklung, http://www.pinuts.de/news

Pinuts media+science GmbH                 http://www.pinuts.de
Dipl.-Inform. Raimund Jacob               Raimund.Jacob@xxxxxxxxx
Krausenstr. 9-10                          voice : +49 30 59 00 90 322
10117 Berlin                              fax   : +49 30 59 00 90 390
Germany


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx