Re: Block Corruption in empty pages in Oracle 11g
From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Fri, 6 Aug 2010 16:22:51 -0700 (PDT)
Message-ID: <15731cab-e3bd-4d50-867d-248e5f3fbc8b_at_q35g2000yqn.googlegroups.com>
On Aug 5, 9:51 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Aug 5, 12:59 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
>
>
> > Yes, tis query shows some block corruptions but it does not tell you
> > corrupted blocks are empty. When I run dbv
> > it does not show any corruption in data or indexes. So I am assuming
> > that corruption is in empty pages.
>
> You don't have to assume, just dump the block reported by RMAN as
> being corrupt.
Date: Fri, 6 Aug 2010 16:22:51 -0700 (PDT)
Message-ID: <15731cab-e3bd-4d50-867d-248e5f3fbc8b_at_q35g2000yqn.googlegroups.com>
On Aug 5, 9:51 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Aug 5, 12:59 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
>
>
> > Yes, tis query shows some block corruptions but it does not tell you
> > corrupted blocks are empty. When I run dbv
> > it does not show any corruption in data or indexes. So I am assuming
> > that corruption is in empty pages.
>
> You don't have to assume, just dump the block reported by RMAN as
> being corrupt.
Soory, don't undestand why do you mean by dump the block. Received on Fri Aug 06 2010 - 18:22:51 CDT