Re: DBMS_REPAIR.CHECK_OBJECT

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 25 Apr 2010 03:06:56 -0700 (PDT)
Message-ID: <8a76cb22-17bf-4972-a202-9e4614f9e5e2_at_z11g2000yqz.googlegroups.com>

On Apr 23, 10:02 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:

snip

> I am using Oracle 11.1.0.7.1 on HP UNIX 11.23. To my surprise, I find
> that
> a block has been corrupted. My export dump backups fail when reading
> corrupt blocks.
> I cannot repair from a backup, this system is not a production system,
> no rman backups were taken.

Can you drop the tablespace and recreate it?

Can you run rman backup to disk and at least get rman to tell you how many bad blocks you have? Received on Sun Apr 25 2010 - 05:06:56 CDT