Quickest Way To Recreate a Database

From: Michael Wehrle <michaelw436_at_gmail.com>
Date: Tue, 30 Jun 2009 15:37:55 -0400
Message-ID: <54b1f9980906301237n5fb62596n42830bbc2e9db6fd_at_mail.gmail.com>

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.

Michael Wehrle

Received on Tue Jun 30 2009 - 14:37:55 CDT

Original text of this message