Re: Who to copy complete database

Hi,

If you want an actual copy of the database then do the following:-

1. take a cold backup of the production database.
2. issue the command alter database backup controlfile to trace
3. copy the cold backup of the production database to the test server
4. edit the trace file produced from 2 so that the initial line = something like CREATE CONTROLFILE REUSE set DATABASE "test_instance_name" RESETLOGS
5. can't rememer off of the top of my head the rest but you're almost there now, probably alter database open.

PS not sure about the resetlogs but you can experiment with a test database.

Glenn.

Ullrich wrote in message <72hcro$nce$1_at_news.LF.net>...
>Dipl. Biochem. Jonas Ullrich
>Eberhardstr. 11, D-72072 Tübingen
>T: +49 70 71 35 74 6, F: +49 70 71 35 71 8
>E-mail: Jonas.Ullrich_at_tuebingen.netsurf.de
>
>Please help me.
>
>We use a Oracle 7.0 database on a "production" server. We connect normally
>to another "development" server, to test our applications. In the meantime
>the data in this database are not compatible to our "production" database.
>I have no administration experience. What to do, to copy the complete
>"production" database to the "development" server. Is it necessary to
create
>a new database and import the *.dmp-Files or is there any easier way, for
>example copy complete directories via network?
>
>
Received on Thu Nov 26 1998 - 13:36:23 CST