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

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 18 Mar 2010 00:20:58 -0400
Message-ID: <7478BBDE9AD045A495EABAD87D6A7D31_at_rsiz.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremiah Wilton
Sent: Wednesday, March 17, 2010 3:36 PM
To: s.cislaghi_at_gmail.com
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_at_yahoo.com>

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.    

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 17 2010 - 23:20:58 CDT