Check for database corruption?

From: Aaron <asentell_at_my-deja.com>
Date: Fri, 08 Dec 2000 21:30:30 GMT
Message-ID: <90rjtm$6pc$1@nnrp1.deja.com>

I'm fairly new to Oracle but not to database administration. As a Sybase DBA, I made sure that I ran a database consistency check on all my production databases at least once a week. From what I've read and seen thus far, however, this same level of precaution is not necessarily required for Oracle, although I'm quite sure this is not Oracle's official position.

I want to get some input from DBAs who are out there in the trenches and have experience with this. Is it worth the time to run "analyze table...verify structure cascade" on a regular basis in production databases? Note that we perform a full export every night in addition to database backups.

Thank you,
Aaron

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 08 2000 - 15:30:30 CST