Re: Copy 11g DB/Instance onto the same server
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Mon, 22 Mar 2010 08:08:54 -0500
Doesnt rman cloning work in 11gr2? If so, all you need to do is create a
tnsnames entry for your source db, and follow the instructions for rman
cloning, it would work something like this (assume that oracle_sid and home
are set to your destination instance). Its usually simplest to create your
destination database using dbca, shut it down, delete the files, and start
it up nomount. DBCA makes sure all the file locations are created, tnsnames
entries are available, and the spfile is created, which saves quite a bit of
time:
rman target sys/<whatever>@sourcedb auxiliary /
run {
set until time("to_date...");
set newname for datafile 1....; (if necessary,
duplicate target database to destdb;
switch datafile all;
}
On Mon, Mar 22, 2010 at 7:09 AM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:
> You can create a new database and then use IMPDP with NETWORK to copy
> directly to the new db while the source is active.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> patrick obrien wrote:
>
> 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.
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
