You could also try using the unix dd command to see if it can read all
the blocks in the datafile.
plovmand_at_mail-online.dk (Kenneth Koenraadt) wrote in message news:<25fb645f.0212291303.3bbc112d_at_posting.google.com>...
> 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 Mon Dec 30 2002 - 15:19:43 CST
