> -----Urspr�ngliche Nachricht----- > Von: Michael Bierenfeld [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 3. Juni 2004 14:47 > An: [EMAIL PROTECTED] > Betreff: Error recovering an incremental backup > > > Hi there, > > we are trying to restore a sapdb 7.3.0.28 with the following script : > > #/bin/sh > DBMUSER=user > DBMPASS=password > SID=E01 > dbmcli -d $SID -uUTL $DBMUSER,$DBMPASS -u $DBMUSER,$DBMPASS << EOF > db_start > util_connect $DBMUSER,$DBMPASS > util_execute init config > util_connect $DBMUSER,$DBMPASS > recover_start completeF > recover_start incrF > db_online > dbwarm > EOF > ret=$? > if [ $ret -ne 0 ] ; then > echo "Return status $ret failure" > exit $ret > fi > > The recover of the complete backup is fine but the > incremental backup fails with > -24988,ERR_SQL: sql error > -111,Message not available > > the medium definition for completeF and incrF is as follows : > > medium_put completeF $COMPLETE_BACKUP_FILENAME FILE DATA 0 8 YES > medium_put incrF $INCR_BACKUP_FILENAME FILE PAGES 0 8 YES > > Does anybody has an idea what I am doing wrong > > Kind Regards > > Michael
Hi, As you can see in the documentation (http://dev.mysql.com/doc/maxdb/) the error -111 means incompatible incremental backup. In Release 7.3 you have to supply all incremental backups from the last complete backup. E.g. you made the following backups: complete C incremental I1 incremental I2 incremental I3 Then you cannot recover C and I3 but only C,I1,I2,I3. Maybe thats the error reason. Otherwise have a look into the backup-history or use the dbmcli (resp dbmgui) to find out which backups you have to recover in which order. HTH, Martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
