Re: Ghost Data

  • From: Michael Wehrle <michaelw436@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Jul 2009 16:18:53 -0400

Also, we confirmed with Oracle that this ghost data issue is indeed a bug
that they have patched and will be fixed in a forthcoming CPU

On Wed, Jul 22, 2009 at 2:11 PM, Michael Wehrle <michaelw436@xxxxxxxxx>wrote:

> All, for your information, we have recently figured out a way to clean up
> this ghost data besides an export / import. We have found that if you do an
> RMAN backup with the COMPRESSED option, once you perform a restore on the
> datafile, it will then be clean. I have tested this on individual datafiles
> with success.
>
>
> On Mon, Jul 6, 2009 at 12:19 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx
> > wrote:
>
>>  Karl, thanks for the interesting pointer, but that doesn’t explain the
>> scenario I saw and reproduced in both 8i and 10g where there was unexpected
>> data inserted into the blocks of a brand new tablespace.
>>
>>
>>
>> Regards,
>>
>> Brandon
>>
>>
>>
>> *From:* Karl Arao [mailto:karlarao@xxxxxxxxx]
>>
>>
>>
>> You may want to check the TDE FAQ, which I think answers your question.
>>
>>
>> http://www.oracle.com/technology/deploy/security/database-security-10g/transparent-data-encryption/tde_faq.html#A11072
>>
>>
>>
>>
>> ------------------------------
>> Privileged/Confidential Information may be contained in this message or
>> attachments hereto. Please advise immediately if you or your employer do not
>> consent to Internet email for messages of this kind. Opinions, conclusions
>> and other information in this message that do not relate to the official
>> business of this company shall be understood as neither given nor endorsed
>> by it.
>>
>
>

Other related posts: