Methods to clone large production database

  • From: "lara nichols" <laranichols@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Mar 2007 14:34:01 -0700

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


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


Other related posts: