Re: Copy 11g DB/Instance onto the same server

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: po04541@xxxxxxxxx
  • Date: Wed, 17 Mar 2010 20:05:30 +0100

Hello Patrick,

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

For step 4 you may issue an "ALTER DATABASE BACKUP CONTROLFILE TO TRACE;" on
the original DB and then copy the part you need and using this you will also
change the DB name.

Otherwise, as anyone will tell you, you can use the RMAN DUPLICATE feature,
check here:
1.
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmdupdb.htm
2.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm


Stefano

--
http://www.stefanocislaghi.eu

2010/3/17 patrick obrien <po04541@xxxxxxxxx>

> Good Day Oracle DBA's,
>
> 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.
>
> Any documents would be so greatly appreciated.
>
> Thank you very much,
> Patrick.
>
>
>

Other related posts: