Re: Ghost Data

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

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: