problem with ontape level 0 archives 
Author Message
 problem with ontape level 0 archives

Hi ,

I did a check on my level 0 ontape archieve  with archecker
 (archecker -tdsv)

The Archieve is giving errors like below ;

ERROR: Table baan:ttfgld418400 partnum 0x0040001F missing physical page
0x009C2FFC
ERROR: Error(13) opening find file ./find_file
ERROR: Unable to add to ./find_file
ERROR: Page 0x009c303f not found in bitmaps

And at the end,   archive status is like below.  What is wrong with my
database or tables ??

STATUS: Table checks FAILED
STATUS: BLOBChunk checks PASSED
TIME: [11/01/2002 10:34:20] Checking Completed
STATUS: Tables/Fragments validated:            16086
STATUS: Tables with missing data:                155
STATUS: Total missing pages:                   38961
Archive Validation Failed.

Thanks Caner,



Wed, 20 Apr 2005 13:42:57 GMT
 problem with ontape level 0 archives

Is the problem with archecker or with the archives?
Have you restored an archive?  Can you restore either on this or another
machine?

MW

Quote:
-----Original Message-----


Sent: Monday, 4 November 2002 7:55 p.m.

Subject: YNT: problem with ontape level 0 archives

Hi ,
Here is a output of oncheck -pT   where can I get the logid NUM .
It is getting worst because I made 4 checks with archecker and all are
failed.
Caner,

TBLspace Report for baan:baan.ttfgld418400

    Physical Address               400022
    Creation date                  05/18/2002 16:11:58
    TBLspace Flags                 802        Row Locking
                                              TBLspace use 4 bit bit-maps
    Maximum row size               215
    Number of special columns      0
    Number of keys                 3
    Number of extents              9
    Current serial value           1
    First extent size              999998
    Next extent size               320000
    Number of pages allocated      4769997
    Number of pages used           4661366
    Number of data pages           1765481
    Number of rows                 15541518
    Partition partnum              4194335
    Partition lockid               4194335

    Extents
         Logical Page  Physical Page        Size
                    0         700003      999997
               999997         425541      125000
              1124997         450d27      125000
              1249997         926fdc      640000
              1889997         a00003      960000
              2849997         b00003      320000
              3169997         b566bf      640000
              3809997         c00003      640000
              4449997         e00003      320000

TBLspace Usage Report for baan:baan.ttfgld418400

    Type                  Pages      Empty  Semi-Full       Full  Very-Full
    ---------------- ---------- ---------- ---------- ---------- ----------
    Free                 215847
    Bit-Map                1157
    Index               2787512
    Data (Home)         1765481
                     ----------
    Total Pages         4769997

    Unused Space Summary

        Unused data slots                            309307
        Unused bytes per data page                       49
        Total unused bytes in data pages           86508569

    Home Data Page Version Summary

                 Version                                 Count

                       0 (current)                    1765481

Index Usage Report for index tfgld4184001abaan on baan:baan.ttfgld418400

                    Average    Average
    Level    Total No. Keys Free Bytes
    ----- -------- -------- ----------
        1        1       11       1732
        2       11       46        728
        3      508       33       1071
        4    17204       30       1154
        5   531871       29       1172
    ----- -------- -------- ----------
    Total   549595       29       1171

Index Usage Report for index tfgld4184002abaan on baan:baan.ttfgld418400

                    Average    Average
    Level    Total No. Keys Free Bytes
    ----- -------- -------- ----------
        1        1       17        988
        2       17       17        875
        3      305       14       1086
        4     4451       14       1060
        5    66709       14       1061
        6   998568       15       1008
    ----- -------- -------- ----------
    Total  1070051       15       1011

Index Usage Report for index tfgld4184003abaan on baan:baan.ttfgld418400

                    Average    Average
    Level    Total No. Keys Free Bytes
    ----- -------- -------- ----------
        1        1       17       1036
        2       17       16       1029
        3      277       16       1034
        4     4477       16       1035
        5    72283       15       1099
        6  1090811       14       1136
    ----- -------- -------- ----------
    Total  1167866       14       1133

-----?zgn Ileti-----


Tarih: 02 Kasym 2002 Cumartesi 19:13


Konu: AW: problem with ontape level 0 archives

Hi,
please make this checks of you DB:

oncheck pt tabname >file             --> Write into a File (tabname here
is: baan:ttfgld418400)
Then take a look on this File: check for logid NUM !
After this, please make:
oncheck -pp <logid> (pt) 0        -->(logid you got before)
Now you get a Bit-Map of your Pages: c=data 8=index 4= halfused pages !!!!
Check if the Page you got from arcchecker is filled !!!

mit freundlichen Gr?en

Marc Dominik H?ller
Systemadministrator IT-Services
EDS Mid-market Solutions GmbH
Ludwig-Erhard-Str. 5
56073 Koblenz
Phone          : +49(0) 261/8099-650
Phone(BaaN):+49(0) 261/8099-660
Fax             : +49(0) 261/8099-383

WEB:    www.eds-midmarket.de

-----Ursprngliche Nachricht-----

Gesendet: Samstag, 2. November 2002 06:43
An: informix comp.
Betreff: problem with ontape level 0 archives

Hi ,

I did a check on my level 0 ontape archieve  with archecker
 (archecker -tdsv)

The Archieve is giving errors like below ;

ERROR: Table baan:ttfgld418400 partnum 0x0040001F missing physical page
0x009C2FFC
ERROR: Error(13) opening find file ./find_file
ERROR: Unable to add to ./find_file
ERROR: Page 0x009c303f not found in bitmaps

And at the end,   archive status is like below.  What is wrong with my
database or tables ??

STATUS: Table checks FAILED
STATUS: BLOBChunk checks PASSED
TIME: [11/01/2002 10:34:20] Checking Completed
STATUS: Tables/Fragments validated:            16086
STATUS: Tables with missing data:                155
STATUS: Total missing pages:                   38961
Archive Validation Failed.

Thanks Caner,



Sat, 23 Apr 2005 04:04:51 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. YNT: problem with ontape level 0 archives

2. How do I check the validy of a level 0 Archive (ontape)

3. Resolution..Ontape Level 0 Archive Aborts Itself...

4. Ontape Level 0 Archive Aborts Itself....

5. Problem archive > 2Go with ontape on disk

6. Archive problem with ontape & onLine 7.1

7. Level-1 backup after level-0 using ontape

8. Informix OnBar archive level 1 problem

9. Severe level 0 archive problem

10. problem with multitape level 0 archive

11. Extract a database from an ontape archive

12. Large ontape archives to disk


 
Powered by phpBB® Forum Software