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

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <jwilton@xxxxxxxxxxxxx>, <s.cislaghi@xxxxxxxxx>
  • Date: Thu, 18 Mar 2010 00:20:58 -0400

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.







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




Why is copying the database cold faster than RMAN duplicate?  In 11g we can
duplicate from live DB.


Jeremiah Wilton

Blue Gecko, Inc.


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 DB/Instance on my AIX Server to the same
The biggest obstacles I am having at the moment is the putting together the
correct listener configuration and creating my CTL file. 



Other related posts: