Re: How clone a database using import/export in a clean way?

Yes, there's a standard way of truly cloning a database described on my website (amongst other places), under the Tips, Basic Administration link.

It involves a clean shutdown of the source, a copy of everything bar the control files to a destination, and a bit of jiggery-pokery with the 'backup controlfile to trace' script.

That method will give you a true, 100% clone. The export method will only ever get you something that looks like the original database (ie, the data contents will be the same, but (as a for instance) the log sequence numbers will all be different, as will the object numbers and so forth. Import also recreates all the indexes, so they are rebuilt, and are not in the same state as they are in the source. And so on. In short, it's not a "clone" at all, but merely a 'facsimile' of the source database.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Captain Blight" <cptnblight_at_nexgo.de> wrote in message
news:a0o07g$915$1_at_newsread1.arcor-online.net...


> I tried to clone a complete database this way:

>

> 1) exported  the database to a dumpfile (with option FULL=Y) on machine1

> 2) on machine2 created a new database by help of the 'database

configuration


> assistant'

> 3) on machine2 imported the dumpfile (with option Full=Y)

>

> The import ends up successfully - but - with a lot of warnings (i.e Tables

> of user SYSTEM cannot be REcreated). The thing seems to work. But I ask

> whether there is a clean way to clone, that doesn't cause any warning

> messages.

>

> Thanks for your help

>

>

>