Re: Copy Database under Windows NT

In order to copy an existing database to another instance.....

SVRMGR> alter database backup controlfile to trace;

Will generate an ASCII version of the controlfile in the trace directory. You will
need to copy this along with all the database files including rollbacks, online
redo-logs, system, temp etc, to the new database directory structure.

Create a new SID for the second database and copy the INIT.ORA file making the
necessary alterations.

Edit the controlfile backup to point at the new directory structure and change
the name of the database.

Startup the new database SID with the NOMOUNT option.

From the Server Manager prompt, execute the modified controlfile to create the new
database.

If you need to access the database from SQL*Net you need to make the necessary
alterations to LISTENER.ORA and SQLNET.ORA

Hope that helps

Graham.

Merlin Team wrote in message <3715e350_at_news.jakinternet.co.uk>...
>Hi,
>
>Is it possible to copy an existing database to another database for use in
>testing. Both database will reside on the same NT Server, but ideally use
>different instances.
>
>Any help appreciated
>
>Paul
>paul_merlin_at_hotmail.com
>
>
Received on Fri Apr 16 1999 - 07:53:39 CDT