I have sent the script file I use with the exact commands. You have verified yourself they are correct, as they are not even documented for 7.5.0.
Can someone else at SAP / MySQL help with this? I notice you aren't even testing with the production release! 7.5.0.5 is the version I reported the problem against, but your sample below shows 7.5.0.9 - is it not possible that you have already fixed this bug? Do you not see your "Build 009" does not match the version I reported the bug against? And even the MySQL web site only shows "build 008" in alpha form. Stephen Gutknecht -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:46 AM To: 'Stephen Gutknecht (SAPDB)'; [EMAIL PROTECTED] Subject: AW: MaxDB 7.5.0.5 Restore problems - no data after restore Hi Stephen, [snip] The correct example would look like this and it shows the extended initialization coupled with data recovery. [snip] 2003-12-23 10:32:42 3FE80BB70001 0006 TAP KERNEL VERSION.... Kernel 7.5.0 Build 009-003-059-738 [snip] Please verify that the correct commands are used. So you cannot find your data until it is really recovered. Kind regards Uwe -----Urspr�ngliche Nachricht----- Von: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] Gesendet: Montag, 22. Dezember 2003 18:39 An: Hahn, Uwe; [EMAIL PROTECTED] Betreff: RE: MaxDB 7.5.0.5 Restore problems - no data after restore I responded to Uwe in a private thread with copies of my entire wrk directory. However, I want to correct the outdated subject on this public post. At first I had a problem with logs due to syntax changes in 7.5. Got past that. The current issue now is more with the restore not working (no data), despite no syntax errors. To review. We are backing up with these commands on Windows 2000 Service Pack 4: dbmcli -n localhost -d MYDB1 -u DBM,** medium_put completeF c:\MaxDB-servermy1-bk000.data FILE DATA 0 8 YES dbmcli -n localhost -d MYDB1 -u DBM,** -uUTL -c backup_start completeF MIGRATION Then restoring with this script on a Windows XP Service Pack 1 system: http://www.IPCoast.com/MaxDB-Restore02.txt The script runs without error - but after completion the 'info state' shows only 2MB of data when the restore file and source database is 9GB. The data is also not there when tests are performed with client SELECT. The backup source is a SAPDB server that started life as 7.4 and was upgraded to MaxDB 7.5 and is working perfectly fine otherwise. Of course, we currently have no way to recover this MaxDB 7.5 database if it corrupts or crashes - so we are anxious to get attention on this matter. Good news is that we run parallel hosting sites and only upgraded one site to MaxDB 7.5. We are still replicating INSERT/UPDATE statements with our second site running SAPDB 7.4 and backup/restore works fine on SAPDB 7.4 server. Stephen Gutknecht Full time traveler, currently in Lake Havasu City, Arizona USA Spending New Years in Las Vegas with my wife, always wanting to meet people! -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 1:27 AM To: 'Stephen Gutknecht (SAPDB)'; [EMAIL PROTECTED] Subject: AW: MaxDB 7.5.0.5 Restore problems - log file not created Hello Stephen, could you please send me the dbm.utl and dbm.knl and dbm.prt from your restored instance, because the output.txt and knldiag does not give any usefull hint in this case. I need the information what was really restored to your database. Uwe -----Urspr�ngliche Nachricht----- Von: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 6. Dezember 2003 22:46 An: Hahn, Uwe; [EMAIL PROTECTED] Betreff: RE: MaxDB 7.5.0.5 Restore problems - log file not created Uwe (and anyone else who can help), I foolishly assumed that because I got OK on all steps and ONLINE status.. that the data was there. However, this weekend I sat down to do some work with the data and it is missing! None of my tables are actually restored, and 'info state' shows only 2MB of consumed pages where the backup source datbase and backup file is 9GB! This is from MaxDB 7.5.0.5 to 7.5.0.5 on Windows 2000 to Windows XP Professional. Can you review my restoration steps again and see if there is some error? dbmcli -n localhost -d MYDB1 -u DBM,** medium_put completeF c:\MaxDB-servermy1-bk000.data FILE DATA 0 8 YES dbmcli -n localhost -d MYDB1 -u DBM,** -uUTL -c backup_start completeF MIGRATION Script I am using for restore: http://www.ipcoast.com/MaxDB-Restore02.txt I am ONLY using the data file, I am not concerned with the LOG files. I just need a snapshot. Thankfully we left one of our systems at 7.4.3.027 and are replicating our INSERT/UPDATE statements. I am not having problems with 7.4.3.027 to 7.4.3.027 backup and restore. Stephen Gutknecht -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 12:44 AM To: 'Stephen Gutknecht (SAPDB)'; [EMAIL PROTECTED] Subject: AW: MaxDB 7.5.0.5 Restore problems - log file not created I have included a few changes. Uwe [...] rem ########################################################## rem ### startup database rem ########################################################## dbmcli -d %SID% -u %uDBM%,%uDBMPW% db_admin echo . echo *** echo *** Just completed db_admin echo *** :Skip1 echo *** echo *** Next step is to start restore! echo *** pause echo medium_put completeFile %restoreFile% FILE DATA 0 8 YES >> param.tmp echo util_connect > param.tmp echo db_activate recover completeFile >> param.tmp echo db_online >> param.tmp type param.tmp | dbmcli -d %SID% -u %uDBM%,%uDBMPW% echo *** echo *** Did the database go warm? Next step is to load system tables. echo *** pause rem look at the state - is it ONLINE ? dbmcli -d %SID% -u %uDBM%,%uDBMPW% db_state rem load database system tables dbmcli -d %SID% -u %uDBM%,%uDBMPW% load_systab -u %uDBA%,%uDBAPW% -ud domain [...] -----Urspr�ngliche Nachricht----- Von: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 4. Dezember 2003 09:01 An: Hahn, Uwe; [EMAIL PROTECTED] Betreff: RE: MaxDB 7.5.0.5 Restore problems - log file not created Hello Uwe, I tried doing it in several places, not making progress. Getting various errors. Including the following when I put it after db_start: dbmcli on TEST4>ERR -24988,ERR_SQL: sql error -101,Message not available Can you pretty please review my script and tell me where to insert db_activate with RECOVER option? http://www.IPCoast.com/MaxDB-Restore01.txt Any other things you notice missing / incorrect in my script? I seem to have the worst luck with syntax changes to the restore process. Thank you. Stephen Gutknecht -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
