Re: Duplicate Oracle 8.Windows NT Instance

I have done this by just copying all the database files (ctrl, redo, datafiles) to another NT server (after they has been shutdown!). On the new server you just have to create the instance/services (oradim80.exe) and then startup the database. If you are in the same network and are using global_names=TRUE you shoul now
rename the new DB (alter database rename global_name to <newdbname.domain>).

You only has to be aware of the fact that if you copy snapshots these will not be registered at the master site
and you must tak action on this (evt. recreate all snapshots).

/Lars Bo

Dick Weisinger wrote in message <6rifbt$c1h$1_at_news.tokyo.att.ne.jp>...
>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 - 02:32:14 CDT