Re: Block Corruption in empty pages in Oracle 11g
From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Sat, 7 Aug 2010 01:51:09 +0200
Message-ID: <4c5c9fef$0$4506$e4fe514c_at_dreader26.news.xs4all.nl>
zigzagdna wrote:
> 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.
Date: Sat, 7 Aug 2010 01:51:09 +0200
Message-ID: <4c5c9fef$0$4506$e4fe514c_at_dreader26.news.xs4all.nl>
zigzagdna wrote:
> 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.
-- JeroenReceived on Fri Aug 06 2010 - 18:51:09 CDT