Re: Duplicate Oracle 8.Windows NT Instance

Hi,

All u have to do is copy all the necessary files: ( datafiles + control files + redo log files, init.ora, etc...)

U should have an excat physical copy of the first database in exactly the same directories and drive letters.

After u copy all the files u should create the instance using oradim80 the same way u created it on the first instance.

change the listener.ora & tnsnames.ora as necessary.

After that the database should start exactly the same as the first one.

I tried it before and it works fine!

                                     Shaul

Dick Weisinger wrote:

> We'd like to be able to move an Oracle 8.x instance running on Windows NT4.0
> to another PC with Oracle 8.x and Windows NT4.0.
> Is there a fast way to do this?
> Our plan is to copy the data and admin directories and files for the
> instance on the source machine to the target machine. Then modify oratab,
> tnsnames.ora and listener.ora to refer to the new instance.
> What else do we need to do?
> Thanks for your help.
Received on Fri Aug 21 1998 - 13:22:09 CDT