Re: Quickest Way To Recreate a Database

  • From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
  • To: michaelw436@xxxxxxxxx
  • Date: Tue, 30 Jun 2009 22:25:02 +0200

Can you explain what this ghost data is and why it is that you have ended up
with sensitive data in system?
In theory you should be able to just move all objects to a new TS and drop
the old one together with the datafiles. You would not be able to remove the
system data files, but that tablespace should only have data dictionary and
not actual data that may be sensitive.

How do you plan on removing the sensitive data? Even a delete on the files
leaves the data on the disks and available to be recreated.

As for a fast way to recreate a two node rac, I'll leave that for the rac
experts. I'd be surprised if this is very common...


On Tue, Jun 30, 2009 at 9:37 PM, Michael Wehrle <michaelw436@xxxxxxxxx>wrote:

> What is the most efficient, quickest way to completely recreate the
> database to minimize downtime?
> The system architecture in question is running on Sun SPARC 64-bit
> Solaris. This is a 2-node RAC system, using ASM for datafile storage.
> The background need for doing so is the production database has old "ghost
> copies" or "ghost data" that is of a sensitive nature in all of the
> datafiles including the system datafiles, and Oracle has not provided a way
> to clean this up besides complete database recreation.
> Thanks,
> Michael Wehrle

Other related posts: