scripted log backup/recovery

hello, *!

i'm still playing around with log backups and recovery of them in a 
standby instance. i now have a little script that triggers a log backup 
and can tell if it worked, an error occured or no backup was required.

now i want to write script that (given a directory with log backups) 
decides which to recover.

first question: this sounds like a script that everyone needs. is one 
available somewhere?

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.

i'd be glad to share the resulting scripts in case anyone wants them.

thanks again for advice,
        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