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/[EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
