Re: DBMS_REPAIR.CHECK_OBJECT

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 25 Apr 2010 14:29:39 -0700 (PDT)
Message-ID: <228cdf28-47ae-4a04-b976-e8e2f8ce05d5_at_x3g2000yqd.googlegroups.com>

On Apr 25, 11:57 am, zigzagdna <zigzag..._at_yahoo.com> wrote:

snip

> Only one block is corrupted. Oracle 11g provdies various health
> monitors and only one block is shown as corrupted. My export dump
> fails for one table. One can reterive dthat table from a prevous
> export backup, but that will require some loss in data.  I am trying
> to figure what is the value of dbms_repair.

How can a system that is not in production have a concern about a loss in data?

I would run an rman validate to double check on how many blocks.

You cannot repair something that you don't have a backup for. Received on Sun Apr 25 2010 - 16:29:39 CDT