Re: Is my database OK?

"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

I just thought of something on my drive home.

What about putting each tablespace in backup mode using:

ALTER TABLESPACE table_space_name BEGIN BACKUP; host dbv file=name_of_each_datafile_for_tablespace ...
ALTER TABLESPACE table_space_name END BACKUP;

And restore/recover any datafiles that were damaged.

I've never tried it, but I can't see why it wouldn't work on an online database.
I've only put tablespaces in backup mode to backup datafiles manually. Same principle.

Any thoughts?

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