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:timo.denis@stripped]
>>Sent: Wednesday, May 12, 2004 5:06 PM
>>To: maxdb@stripped
>>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?unsub=1
>>
>>
>>
