RE: how to clone database to different DB name use RMAN (No duplicate or exp/imp)

  • From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
  • To: "Mayen.Shah@xxxxxxxxxx" <Mayen.Shah@xxxxxxxxxx>, "andrejs.kaulins@xxxxxxxxx" <andrejs.kaulins@xxxxxxxxx>
  • Date: Wed, 6 Jul 2011 13:41:47 +0000

RMAN is the best option these days (though it can be frustrating at times), and 
you can change the database name easily (we don’t have any databases with the 
exact same name). If you want a different DBID (because you’re doing it by 
hand) then use the nid utility

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mayen.Shah@xxxxxxxxxx
Sent: Wednesday, July 06, 2011 6:45 AM
To: andrejs.kaulins@xxxxxxxxx
Cc: mccdba1@xxxxxxxxx; oracle-db-backup-l@xxxxxxxxxxxxxxxxxxxx; 
oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
Subject: Re: how to clone database to different DB name use RMAN (No duplicate 
or exp/imp)

AFAIK Recreating control file or opening database with reset logs will not 
change DBID.

Easiest method will be RMAN duplicate database. What is the reason you can not 
use RMAN duplicate command?

Thanks
Mayen





From:        "Andrejs Kaulins" 
<andrejs.kaulins@xxxxxxxxx<mailto:andrejs.kaulins@xxxxxxxxx>>
To:        "mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>" 
<mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>>
Cc:        
"oracle-db-backup-l@xxxxxxxxxxxxxxxxxxxx<mailto:oracle-db-backup-l@xxxxxxxxxxxxxxxxxxxx>"
 
<oracle-db-backup-l@xxxxxxxxxxxxxxxxxxxx<mailto:oracle-db-backup-l@xxxxxxxxxxxxxxxxxxxx>>,
 "oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>" 
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Date:        07/06/2011 06:23 AM
Subject:        Re: how to clone database to different DB name use RMAN (No 
duplicate or exp/imp)
Sent by:        
oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
________________________________



Hi,

If you have consistent backup (cold backup), you could recreate control file 
with setting new db name, and defining new locations for data files. Opening 
database with reset logs will do the rest (dbid will be changed in data file 
headers).
Otherwise you need recovery, so db needs to be mounted at least with the same 
name as original name.

Andrejs Kaulins,
Senior DBA at SOLABS

Sent from my iPad

On 2011. gada 5. jūl., at 23:01, dba1 mcc 
<mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>> wrote:

>
>
> We have ORACLE 10Gr2 and 11GR1
> databases.  We plan to clone database to other server
> and also rename it using "nightly backup".  This nightly backup may be 
> several weeks ago.  In this case we can NOT use rman "duplicate" command or 
> EXP/IMP.
>
> I know I can use RMAN restore to same database name then
> rename it.   Does there has other way can do it?
>
> Thanks.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
--
http://www.freelists.org/webpage/oracle-l



Other related posts: