Quickest Way To Recreate a Database
Date: Tue, 30 Jun 2009 15:37:55 -0400
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.