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

On 21 Sep, 22:48, Michael <mbulch... (AT) gmail (DOT) com> wrote:
What version of Oracle? What O/S?

Anyway, certainly in 10g RMAN has the functionality to duplicate
databases:

http://download.oracle.com/docs/cd/B...2.htm#i1006532

I suggest that you read up on the subject and then most people will be
quite happy to answer your questions.

HTH

-g

On Sep 22, 5:28*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
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 --