"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1119671845.542030_at_yasure...
> IANAL_VISTA wrote:
>> "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
>>>
>>>Of course they taught it. Don't be silly.
>>>
>>>Question: Does dbverify work with online datafiles?
>>>
>>>Not!
>>>
>>>RE: 8.1.7 documentation heading for dbverify:
>>> "DBVERIFY: Offline Database Verification Utility"
>>>
>>>The OP is online. He's already started up his database and, I'm
>>>assuming, it's already in production?
>>>
>>>Do you suggest that he take each of his datafiles offline and run
>>>dbverify against them? Perhaps when he was testing whether or not the
>>>database was ok he should have used dbverify. And if he wishes to
>>>still use dbverify, then he'll have to come in early in the morning,
>>>take each datafile offline, and run dbverify against it.
>>>
>>>And just because you've never been to outer space doesn't mean it
>>>isn't there, or have you...
>>>
>>
>>
>> From: http://download-
>> west.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.
>
> And in 10g one can either run the stand-alone DBV executable or the
> internal DBMS_DBVERIFY package. And surely no one is running a
> package owned by SYS with a database that isn't open.
>
> I wonder where anyone got the idea you couldn't run DBV with an open
> database?
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
I stand, or rather, sit corrected.
--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---
WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup
Received on Fri Jun 24 2005 - 23:06:15 CDT
