Yes, all replace commands must return with -8020 because only you can tell the database where to stop the log recovery because the log volume was cleared. So this is ok.
"page count" is the difference between "First LOG Page" and "Last LOG Page" and this is _not_ the amount of physical log pages. The important value is "pages_left" which is and must be 0. The explanation for the misunderstandung name "page count" is that in releases < 7.4 we had a 1to1 relation between logical log page number and physical representation. In that case the difference really describes the page count. The two labels above "first" and "last" are called since 7.4 IO-Sequences and a logpage can be written more then once onto a physical position in the log volume. Everytime a logical log page is written onto a physical offset ist IO-Sequence is incremented. The difference between the logical numbers is in most cases greater then the amount of pages they were written to. Uwe >-----Original Message----- >From: Timo Denis [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 12, 2004 5:37 PM >To: Hahn, Uwe >Cc: [EMAIL PROTECTED] >Subject: Re: Recovery Question > > >Ok, > >logs are from 335 to 351 and all recover_replace logs command >show -8020 >and also a bigger page count then pages transferred. > >Timo > >Hahn, Uwe wrote: > >>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/maxdb?>[EMAIL PROTECTED] >>> >>> >>> > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
