Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is my database OK?
"Andreas Sheriff" <spamcontrol_at_iion.com> wrote in
news:gE0ve.3292$8o.3276_at_fed1read03:
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:014pb11eo4us57h5l3fmu204j7e850rr05_at_4ax.com...
>> On Fri, 24 Jun 2005 14:48:20 -0700, "Andreas Sheriff" >> <spamcontrol_at_iion.com> wrote: >> >>> >>>Use: >>>ANALYZE (TABLE | INDEX | CLUSTER) table_name VALIDATE STRUCTURE; /* >>>Etc... */ >>> >>>Oracle won't tell you there's block corruption till you try to read >>>from that block. >>>Do this when database activity is at a minimum because this procedure >>>can be >>>very time consuming. >> >> The OP would obviously better use the dbverify utility instead of >> this cumbersome method. But I guess dbverify is not included in the >> OCP. Also, I never ever experienced block corruption, and I have >> survived quite a few crashes. >> >> >> -- >> Sybrand Bakker, Senior Oracle DBA
From: http://downloadwest.
oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch09.htm#1936
DBVERIFY is an external command-line utility that performs a physical data structure integrity check on an offline database. It can be used against
backup files and online files (or pieces of files). -----------------^^^^^^^^^^^^
I run it weekly via cron against my 24x7 DB. Received on Fri Jun 24 2005 - 21:57:42 CDT