Tim, if you really don't have more log backups after 340 (I ask because your sript seems to replace until 999) then -8020 is OK and you have to recover_ignore this message.
The redo process does not know the end of the log because your log volume was cleared by INIT CONFIG otherwise the end of log volume determines the end of the log and all attemtps to ignore missing log backups are prevented with an error message. regards, Uwe >-----Original Message----- >From: Timo Denis [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 12, 2004 5:06 PM >To: [EMAIL PROTECTED] >Subject: Recovery Question > > >Hi, > >I finally started to recover a huge database via > >/* > db_admin > util_connect > util_execute INIT CONFIG > medium_put data /space/data file data > medium_put logs /space/log file log > recover_start data data > recover_start logs log 010 > recover_replace logs /space/log.010 > [...] > recover_replace logs /space/log.999 > recover_ignnore > db_online >*/ > >DB command 'recover_start data data' runs fine and returns 0, >so recover > of data file is ok. DB commands for 'recover_replace logs' returns >-8020 and 'Page Count' is bigger than 'Pages Transferred', e.g. > >/* > Returncode -8020 > Date 20040512 > Time 00082326 > Server dc03 > Database IEEINT > Kernel Version Kernel 7.4.3 Build 031-121-060-910 > Pages Transferred 1848 > Pages Left 0 > Volumes 1 > Medianame logs > Location /space/log.340 > Errortext > Label LOG_00340 > Is Consistent > First LOG Page 150248035 > Last LOG Page 150267515 > DB Stamp 1 Date 20040504 > DB Stamp 1 Time 00163346 > DB Stamp 2 Date 20040504 > DB Stamp 2 Time 00170125 > Page Count 19480 > Devices Used 1 > Database ID db03:db_prod_20030811_191932 > Max Used Data Page >*/ > >My questions are: a) Is return code -8020 OK and b) what about the >difference between 'Page Count' and 'Pages Transferred' ? > >Kind regards, Timo > >-- >Timo Denis, IT department >DBA / Developer / Administrator [LPIC1] > >IEE S.A. International Electronics & Engineering >Zone Industrielle, L-6468 Echternach, Luxembourg >Phone +(352)72 89 89-6801, Fax +(352)72 89 89-6109 > >This e-mail may contain trade secrets or privileged, undisclosed >or otherwise confidential information. If you are not the intended >recipient and have received this e-mail in error, you are hereby >notified that any review, copying or distribution of it is strictly >prohibited. Please inform us immediately and destroy the original >transmittal from your system. Thank you for your co-operation. > >-- >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]
