Re: Analyze question - data corruption

From: rob van laarhoven <rob_at_dsdelft.nl>
Date: 2000/03/28
Message-ID: <954248769.773829@newsreader2.wirehub.nl>#1/1

Doug,

sorry for sending this message to your email account. My mistake...

> - To check for block corruption try running the DBVERF command against
> the tablespaces. The tablespace must be offline for this.
>
> - To check for block corruption try running the DBVERF command against
> the tablespaces. The tablespace must be offline for this.
>

On Unix the utility is named :
dbv
and it can be use for all datafiles while the database is open. ;-)

An extra test for datablock corruption is to make a full export of the database. For performance use /dev/null as output file. Check the logfile for errors.

Rob. Received on Tue Mar 28 2000 - 00:00:00 CST