Hi Stephen,
for the db_activate you do not need (must not use) the user&password.
db_activate RECOVER completeFile
is enough.
If this isn't the fault, please send me the file dbm.utl
from your failed recovery and if possible, the file dbm.utl
of your main system, which contains the result of the backup-
command.
regards, Martin
> -----Original Message-----
> From: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 29, 2003 7:20 PM
> To: Hahn, Uwe; [EMAIL PROTECTED]
> Subject: RE: MaxDB 7.5.0.5 Restore problems - no data after restore
>
>
> 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]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
