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

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> 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