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

From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Wed, 6 Jul 2011 13:41:47 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C3B82A1F2_at_COPDCEXMB08.cable.comcast.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mayen.Shah_at_lazard.com Sent: Wednesday, July 06, 2011 6:45 AM
To: andrejs.kaulins_at_gmail.com
Cc: mccdba1_at_yahoo.com; oracle-db-backup-l_at_Groups.ITtoolbox.com; oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org 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_at_gmail.com<mailto:andrejs.kaulins_at_gmail.com>>
To:        "mccdba1_at_yahoo.com<mailto:mccdba1_at_yahoo.com>" <mccdba1_at_yahoo.com<mailto:mccdba1_at_yahoo.com>>
Cc:        "oracle-db-backup-l_at_Groups.ITtoolbox.com<mailto:oracle-db-backup-l_at_Groups.ITtoolbox.com>" <oracle-db-backup-l_at_Groups.ITtoolbox.com<mailto:oracle-db-backup-l_at_Groups.ITtoolbox.com>>, "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>
________________________________

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_at_yahoo.com<mailto:mccdba1_at_yahoo.com>> 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




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

Received on Wed Jul 06 2011 - 08:41:47 CDT