RE: scripted log backup/recovery

Hello Raimund,

>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.

Best regards
Tilo Heinrich
SAP Labs Berlin

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