Dbv-00102

OK,

Then the question is whether
a) Your SYSTEM tablespace datafile is really corrupt OR b) Something is wrong with dbv.

To check a) you can do the following :

1. View the alert log for info.
2. execute "analyze table <table-name> validate structure cascade" for all tables in SYSTEM tablespace. That will show if any (used) blocks are corrupt.
3. Make a full export of the DB. If it completes succesfully, you can save your DB this way, because then the (possible) damaged blocks were not in use.

Regarding b), I have no other idea than dbv is known not to work on raw devices on some platforms.

• Kenneth Koenraadt

mkoster <member_at_dbforums.com> wrote in message news:<2326186.1041162357_at_dbforums.com>...
> they give no error .
>
> >>>>>
> example:
> DBVERIFY: Release 8.1.7.0.0 - Production on Fri Dec 27 11:40:41 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> DBVERIFY - Verification starting : FILE =
> /dbaU1/oradata/NTEL/ts_users04.dbf
>
>
> DBVERIFY - Verification complete
>
> Total Pages Examined : 256000
> Total Pages Processed (Data) : 1166
> Total Pages Failing (Data) : 0
> Total Pages Processed (Index): 65
> Total Pages Failing (Index): 0
> Total Pages Processed (Other): 2
> Total Pages Empty : 254767
> Total Pages Marked Corrupt : 0
> Total Pages Influx : 0
> <<<<<
>
> marcus
Received on Sun Dec 29 2002 - 15:03:04 CST