Quickest Way To Recreate a Database
- From: Michael Wehrle <michaelw436@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- 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.
Thanks,
Michael Wehrle
Other related posts: