Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Check for database corruption?
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
![]() |
![]() |