First, unless you have just the right disk setup and/or a split mirrors capability using RMAN as Jeremiah suggests is probably faster and it is certainly easier unless you don't know RMAN. Second, if you were going to do the deed via copy or split you'd put the database (or sets of tablespaces at a time) in hot backup mode (also renamed online backup mode by marketing weenies who thought the word "hot" sounded dangerous). So the outage required would only be for the startup rename resetlogs of the copy. That would vary not by size of the database, but by the number of files. (And it won't take long.) So if for some reason you can't use RMAN, at least minimize your downtime. If you need the details look back in oracle-l a few years. From about 1988 until RMAN became reliable, that was the way to go. Regards, mwf _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeremiah Wilton Sent: Wednesday, March 17, 2010 3:36 PM To: s.cislaghi@xxxxxxxxx Cc: Oracle L Subject: Re: Copy 11g DB/Instance onto the same server Stefano, Why is copying the database cold faster than RMAN duplicate? In 11g we can duplicate from live DB. Jeremiah Wilton Blue Gecko, Inc. http://www.bluegecko.net On Mar 17, 2010, at 12:05 PM, Stefano Cislaghi wrote: IMHO there's a faster solution. If you're able to shutdown your DB for a while (it dependes about its own size) you may: 1. shutdown immediate 2. copy all datafiles and pfile to the new location 3. startup your original database 4. Recreate the controlfile for the duplicated one 5. Startup the new one 2010/3/17 patrick obrien <po04541@xxxxxxxxx> I want to copy my Oracle 18.104.22.168.0 DB/Instance on my AIX Server to the same server. The biggest obstacles I am having at the moment is the putting together the correct listener configuration and creating my CTL file.