Hello Aleksey, the redo process reads the log - in your case from the log backup - and copies it to transaction specific files in the data area. This fills the data area in addition to your normal contents. Your data area is very small and in this case you can run in this problem and you solved it in the right way. If you would have sized your volumes for productive work the chance to run in space problems is very small but not zero.
Kind regards Uwe -----Original Message----- From: Krasnov Aleksey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 4:47 PM To: Hahn, Uwe Subject: RE: MaxDB 7.5 restore from log backup problem Hello Uwe, Thank you for your help. The recovery_replace works properly when I execute recovery_start with the right log number. But I have one more question. Before recover the database was about 75 % full. Database Manager showed about 15000Kb of used space. During recover procedure I used a recover_config command and left the data volume at the same size (20000Kb) as for old database. But after recover_ignore I got exception: dbmcli on TSTU>ERR -24988,ERR_SQL: sql error -900,Data area full and in the knldiag.err: 2004-01-27 07:09:42 0x754 ERR 18432 MESSAGES Event log is full, rc = 1502 2004-01-27 07:10:12 0x6FC ERR 5 Restart REDO: T781 (committed) redoresult: 3, TrError: 1402 2004-01-27 07:10:12 0x54C ERR 52012 RESTORE error occured, basis_err 1402 2004-01-27 07:10:12 0x54C ERR 8 Admin ERROR 'cancelled' CAUSED EMERGENCY SHUTDOWN After increasing data volume (to ~ 28000 Kb) the recover was successful and Database Manager showed approximately 15000Kb of used space. How much volume should I add to data devspace in such cases? Best regards Alexey. --- "Hahn, Uwe" <[EMAIL PROTECTED]> wrote: > Hello Aleksey, > > the log volume 001 doesn't seem to bet he rigth one. > > If you have the dbm.knl from the backup site then > you should look for your incremental backup and what > start sequence no is used there. You have to look > for this number in the dbm.knl and find the log > backup which contains this start sequence no. > > If you have further questions, please send me the > dbm.knl so I can show it by example. > > Kind regards, > Uwe > > -----Original Message----- > From: Krasnov Aleksey > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 11:00 AM > To: [EMAIL PROTECTED] > Subject: MaxDB 7.5 restore from log backup problem > > Hello, > To recover database (MaxDB 7.5.00.08; Windows 2000) > I > restored full backup, incremental backup, log backup > files and dbm.knl, dbm.mdf to their places. I have > no problem to recover from Database Manager but when > I > use dbmcli I can only recover full and incremental > backup and receive an error when trying to recover > from log. I do the following: > > util_connect > db_activate RECOVER data > medium_put incr D:\sdb\data\TSTU\incr FILE PAGES > medium_put auto D:\sdb\data\TSTU\autosave FILE AUTO > recover_start incr PAGES > recover_start auto LOG 001 > recover_replace auto D:\sdb\data\TSTU\autosave 002 > > When I execute recover_replace (according > http://www.mysql.com/products/maxdb/pdf/backint_eng.pdf > ) I get > > dbmcli on TSTU>ERR > -24988,ERR_SQL: sql error > -104,DBM command impossible at this time > > What's wrong with this command? > > Thanks in advance. > > Alexey. > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free web site building tool. > Try it! > http://webhosting.yahoo.com/ps/sb/ > > -- > 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] > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
