Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dbverify and analyze table difference

dbverify and analyze table difference

From: Sven Tieste <sven.tieste_at_sw-hb.de>
Date: Tue, 5 Nov 2002 11:28:14 +0100
Message-ID: <aq86fu$lha$1@f40-3.zfn.uni-bremen.de>


Hello,
we have a problem comparing dbverify (dbv) vs analyze table output. At first we are using Oracle 8.1.7.3 on a Alpha 1000/400 Cluster with OpenVMS 7.1-1.
We received an error during dbv a archived .DBS-file. A similar error was found with analyze table (which was found with the page output of dbv). So, we export the table, dropped it and import it. After that analyze table gives
no error. We create a online backup. But with dbv we got the same error as before (analyze table has been tested again and runs with no error again) What's wrong? Is there an error or not?
Thanks in advance for help.
greetings,
Sven Tieste

DBVerify output:
DBVERIFY: Release 8.1.7.3.0 - Production on Di Nov 5 07:06:36 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = ora_user_bst.dbs Block Checking: DBA = 37751597, Block Type = KTB-managed data block kdbchk: the amount of space used is not equal to block size

        used=1615 fsc=289 avsp=186 dtl=1952 Page 2861 failed with check code 6110

DBVERIFY - Verification complete

Total Pages Examined         : 30720
Total Pages Processed (Data) : 2888
Total Pages Failing   (Data) : 1
Total Pages Processed (Index): 1840
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 42
Total Pages Empty            : 25950
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Received on Tue Nov 05 2002 - 04:28:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US