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 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

--
http://www.freelists.org/webpage/oracle-l

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

This message: [ Message body ]
Next message: Rajesh Rao: "DB2 9.7 - Oracle Compatibility"
Previous message: S. Anthony Sequeira: "Re: utl_file and listener"
Next in thread: Rajesh Rao: "DB2 9.7 - Oracle Compatibility"
Reply: Rajesh Rao: "DB2 9.7 - Oracle Compatibility"
Reply: Mathias Magnusson: "Re: Quickest Way To Recreate a Database"
Maybe reply: Michael Wehrle: "Re: Quickest Way To Recreate a Database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message