Re: dbv Output - Pages Failing (Data)

Hello,

I believe you are using the dbv on
Solaris 8
on the datafile of
Solaris 6

My experience has been that dbv
acts 'very funny' in these type of scenarios in fact what you are encountering is
'expected behaviour'

However, don't be surprised if dbv runs 'successfully' for ALL datafiles
except system ,rollback and temp tablespaces' datafiles

Thanks

Cyril
On Fri, 16 Nov 2001 VIVEK_SHARMA wrote :
>
> The Problem Occured upon Extracting on Solaris 2.8 the
> Cold Backup of a
> Database existing in Solaris 2.6 for Oracle ver 7.3.4.5
>
> $ uname -a
> SunOS SF2A 5.8 Generic_108528-10 sun4u sparc SUNW,
> Sun-Fire
>
> Qs. Are there Any O.S./Oracle Patches which Should be
> Applied when Doing
> Such an Extract ?
>
>
> - Running dbv Utility for SOME of the Datafiles Giving
> the Following
> Error :-
>
> $ dbv file=/mis/data3/ACCT_MASTER_bby01_13.dbf
> blocksize=8192
>
> DBVERIFY: Release 7.3.4.5.0 - Production on Thu Nov 15
> 13:46:03 2001
>
> Copyright (c) Oracle Corporation 1979, 1996. All
> rights reserved.
>
> DBVERIFY - Verification starting : FILE =
> /mis/data3/ACCT_MASTER_bby01_13.dbf
> kdbchk: row locked by non-existent transaction
> table=0 slot=20
> lockid=56 ktbbhitc=5
> Page 55366 failed with check code 1
> kdbchk: row locked by non-existent transaction
> table=0 slot=68
> lockid=56 ktbbhitc=1
> Page 104550 failed with check code 1
>
>
> DBVERIFY - Verification complete
>
> Total Pages Examined : 115200
> Total Pages Processed (Data) : 114430
> Total Pages Failing (Data) : 2
> Total Pages Processed (Index): 0
> Total Pages Failing (Index): 0
> Total Pages Empty : 769
> Total Pages Marked Corrupt : 0
> Total Pages Influx : 0
> $
>
> Qs. What can be Done About the "Total Pages Failing
> (Data) : 2" Pages
> ?
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infy.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet access
> / Mailing Lists
> ---------------------------------------------------------
> ------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information (like
> subscribing).
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril  Thankappan
  INET: cyril_thank_at_rediffmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).