RE: Copy 11g DB/Instance onto the same server
Date: Thu, 18 Mar 2010 09:16:07 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F819B33056_at_sunmsx01.Corp.Acxiom.net>
Agreed, I use the duplicate feature on a regular basis
Lee
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Frits Hoogland
Sent: 17 March 2010 19:42
To: Oracle L
Cc: s.cislaghi_at_gmail.com; jwilton_at_bluegecko.net
Subject: Re: Copy 11g DB/Instance onto the same server
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 <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:
- shutdown immediate
- copy all datafiles and pfile to the new location
- startup your original database
- Recreate the controlfile for the duplicated one
- 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.
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 18 2010 - 04:16:07 CDT