On 11g you can actually now do live duplicates (no pre-existing-backup needed). I think that's what Jeremiah was referring to. ( http://www.colestock.com/blogs/2008/01/new-in-11g-active-database-duplication.html). I haven't used it yet but it looks nifty. On Wed, Mar 17, 2010 at 12:42 PM, Stefano Cislaghi <s.cislaghi@xxxxxxxxx>wrote: > Jeremiah, > > Yep you're right. Sorry I didn't explain myself correctly... if you've a > backup already configured RMAN is certain the faster solution. > Many times RMAN and backup are not already configured and if your db is not > in production yet you may copy datafiles. > > > > Stefano > > -- > http://www.stefanocislaghi.eu > > 2010/3/17 Jeremiah Wilton <jwilton@xxxxxxxxxxxxx> > > 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. >>> >> >> >> >