Re: Quickest Way To Recreate a Database
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_at_gmail.com>wrote:
> What is the most efficient, quickest way to completely recreate the
> database to minimize downtime?
> The system architecture in question is 10.2.0.4 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.
> Michael Wehrle