Re: Copy Database

Shaochun Lin wrote:
>
> Please help! I want to find best way to dupliate a database, the basic
> idea in my mind is, create a new database and create exact size of
> tablespaces and doing full export and full import. Does someone can give
> me a advise and are there any hole in this procedure. Thanks, SC

You can do an offline backup of database, including tablespaces, redo log files, control files and parameter files. Install the database, shut it down, and restore the backup. You will have two identical databases.

This procedure can be used on different machines on the same platform, since the ORACLE_HOME must be same for both DBs.

Shashi Aadipudi
Independent Oracle DBA/Developer Received on Fri Jun 21 1996 - 00:00:00 CEST