List:MaxDB« Previous MessageNext Message »
From:Timo Denis Date:May 12 2004 3:05pm
Subject:Recovery Question
View as plain text  
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.
Thread
Recovery QuestionTimo Denis12 May
Re: Recovery QuestionTimo Denis12 May
RE: Recovery QuestionUwe Hahn12 May
RE: Recovery QuestionUwe Hahn13 May