Re: Quickest Way To Recreate a Database
Date: Tue, 30 Jun 2009 23:02:59 +0200
Message-ID: <8580d4110906301402r706d3ae3od012d4da5e707c6b_at_mail.gmail.com>
OK. So a block data has moved from may still have the data if you had not encrypted the data at the time it was put there. What sensitive data is in the system tablespace?
I don't see how exp/imp would be faster than a move object. To move you will have to read and write and doing that with a little conversion as possible ought to be the fastest. To save downtime, maybe online redefinition of the table could be used?
Still what will you do about the fact that data can probably be restored on the disks where the files are now?
Mathias
On Tue, Jun 30, 2009 at 10:45 PM, Michael Wehrle <michaelw436_at_gmail.com>wrote:
> Mathias, Oracle explains what this ghost data is here...
>
>
> http://www.oracle.com/technology/deploy/security/database-security/transparent-data-encryption/tde_faq.html#A15032
>
> Also at that link Oracle's recommendation is to do as you recommended in
> theory. New TS, Move Segments into new TS, drop old TS. We are looking at
> the best way to accomplish that with minimal downtime. We have talked about
> the possibility of exp/imp, doing exactly as Oracle described above, maybe
> use Streams, anything is a possibility here if it will save downtime.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 30 2009 - 16:02:59 CDT