Re: Migrating DB Unix->Windows NT

Ron Reidy <rereidy_at_indra.com> wrote:

>Rick Denoire wrote:
>>
>> Hello
>>
>> I have a working DB (Oracle 8.1.7, Solaris 7) and am trying to use the
>> init.ora file, the edited "alter database backup controlfile to
>> trace"-file as a new db creation script, and the full dump to
>> reinstall a new DB on Windows NT from scratch.
>>
>Did you create your target instance? If not, how do you expect to start
>it using oradim, even with your init file and the trace file from 'alter
>database ...'? You need to create at a minimum all the data files,
>because when you recreate your control file using the trace file, the
>data files had best be there, or the instance will not start.

I am not trying to physically clone the DB. As I said, the trace file was edited to make a "CREATE DATABASE" file of it, not to recreate the controlfile. So I don't need the DB files, since I am trying to use the dmp file. Hey, cloning a DB is easy compared to a logical copy via export/import! (In any case, I doubt that one can physikally clone the DB across different platforms).

As far as I know, using oradim is the way to go in order to set up an instance from the command line (Windows). So I don't understand how I should already have the instance beforehand.

>Here is my suggestion.
>
>1. Create your NT instance.
>2. Create some named DB links in your Solaris instance to point to your
>NT instance's tables.
>3. Pump all the data into NT via PL/SQL code.

This is a good idea, but the goal is not just to have a copy, but to get it using export/import. COPYING the DB is important in this case, not the DB COPY itself.

What do you mean precisely with "Create your NT instance"?

Thanks,
Rick Received on Wed Feb 27 2002 - 16:05:25 CST