Re: Is my database OK?

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:Xns967FCB106298DSunnySD_at_68.6.19.6...
> "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.

That's really good to know. The documentation is ambiguous. In one sentence it states that dbv is used to check an "offline database" and in the next sentence it states that dbv can be used to check "online files"...
Huh?!?!
No wonder Oracle is so complex. You spend half the day trying to figure out if the documentation is accurate!

Unfortunately, I don't have access to meta link; expired subscription and all, and boss being too short sighted to upgrade.

-- 
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