Methods to clone large production database

From: lara nichols <laranichols_at_hotmail.com>
Date: Mon, 26 Mar 2007 14:34:01 -0700
Message-ID: <BAY101-DAV7DB101ED4932D90496E07AD6F0@phx.gbl>
Message-ID: <001501c76fee$780e6f60$7eb84181@cpcalpoly.edu>

I am attempting to clone a production oracle database that is 760G to a new partition on the same host.
I would like to be able to do the clone without having any production outages.
Does anyone have any opinions of what the best way to accomplish this? The ideas I've come up with are RMAN duplicate, RMAN image copy, or put the database in backup mode and do OS copy commands. However, I've tried RMAN duplicate and because of the size of the database, and the thus the time it takes to clone the database, this doesn't seem to be the best method.

Anyone else have any better ideas?

Lara Nichols
Cal Poly State University
805-756-6214
nichols_at_calpoly.edu

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

Received on Mon Mar 26 2007 - 16:34:01 CDT