Re: Ghost Data
Date: Wed, 22 Jul 2009 16:18:53 -0400
Message-ID: <54b1f9980907221318s5194cd12ofe91b4252215914_at_mail.gmail.com>
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_at_gmail.com>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_at_oneneck.com
> > 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_at_gmail.com]
>>
>>
>>
>> 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.
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 22 2009 - 15:18:53 CDT