Re: Copy Database under Windows NT

Forgot to remind that after backing up the controlfile, the primary database MUST be shutdown before trying to copy the datafile. Yeah, I know it's obvious, but it's also 7:58AM and I havn't had any caffeine yet :)

Graham

Graham C Thornton wrote in message <7f7bt8$ap3_at_news.abbott.com>...
>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:59:36 CDT