Moving unix DB instance to NT DB instance

From: Dave Siddons <dave.siddons_at_capgemini.co.uk>
Date: Fri, 31 Jul 1998 16:41:15 +0100
Message-ID: <6psnrm$vjn$1@hagen.usenet.co.uk>

Basically whats the best of doing it. The first way I have tried is.

Shutdown the unix instance
Backup to trace, the controlfile (giving me a script to regenerate it).

Ftp'd the database files (all in one place) to appropriate place on NT machine.
Copied init.ora file to NT box.

Modified controlfile recreation script to point to NT directories Modified init.ora to point to correct NT directories.

Create service on NT box for this instance

ran svrmgr23

connect / as sysdba

tried to run controlfile re-creation script

Got an error indicatinf invalid header in system01.ora.

Any ideas ?

The other possibility was to create a new fresh database on the NT box and export from unix to import on NT. Would this be a better solution ?

Cheers for any help .... Dave. Received on Fri Jul 31 1998 - 10:41:15 CDT