Re: Duplicate database

From: Mark D Powell <>
Date: Tue, 22 Sep 2009 06:32:38 -0700 (PDT)
Message-ID: <>

On Sep 22, 5:28 am, gazzag <> wrote:
> On 21 Sep, 22:48, Michael <> wrote:
> > I am trying to duplicate a database, but before i do it - I want to
> > make sure the init.ora I copied from production is changed to include
> > a new controlfile name so that it does not overwrite the existing
> > control file in product -. Is that correct and I do not need to copy
> > the physical control files from production to the tarfget database?
> > Thanks in advance,
> > Michael
> What version of Oracle?  What O/S?
> Anyway, certainly in 10g RMAN has the functionality to duplicate
> databases:
> I suggest that you read up on the subject and then most people will be
> quite happy to answer your questions.
> -g

Michael, it is always a good idea to include the Oracle rdbms software version in your post. Even though the rman duplicate command has existed since at least version 9.2 your options with it have imporved with 10g and 11g. 11g includes additional set newname extentions to make automatically file name conversions easier. With version 9 you have to use a backup set to perform the duplicate command. By version 11 you can use the current source database rather than a backup set. Minor details but these details can be important depending on your goal.

If using rman is not an option for some reason then if you are changing platforms you will likely have to use the export/import process: Install software, build database, export from source, transfer file, and import on target. If 10g+ you can potentially import via a database link.

If on a fully compatiable platform you can duplicate a database using manual file copies and the database renameing utility but rman duplicate would likely be easier and safer. You really do not want to duplicate the database on the same server. If you duplicate manually you will want to re-create the control files.

I would search the Oracle support web site for a document on how to manually duplicate a database before doing so. I am pretty sure Oracle has published a couple of these papers in the past. Even if Windows specific such a paper would help. But again, rman duplicate, is the recommended method.

HTH -- Mark D Powell -- Received on Tue Sep 22 2009 - 08:32:38 CDT

Original text of this message