totally agree with jeremiah: the duplicate feature allows cloning/duplication with very little manual intervention needed. frits On Mar 17, 2010, at 8:36 PM, Jeremiah Wilton wrote: > 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 11.2.0.1.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. >> >