Database OS migration

[did02]

Hi all,

I have to determin the best way to copy a 200 Gb data running on Solaris 8 /Oracle 8.1.7 on a W2K / Oracle 8.1.7 plateform.

I'm trying to know the used options on the source config (32/64b, MTS, parallele server) and come back as soon as possible.

Any help would be appreciated.

Regards,
Did02

 

[alexhu]

The only way is a full export from Solaris server and import it into the Windows server

Alex

 

[DBAwhosaysNIE]

don't you still have to create the physical enrivonment 1st (tablespaces/datafiles)? also, you probably want to pump this through a fifo instead of staging the whole thing on a filesystem (even w/split, etc.).

at the risk of asking the obvious why in the world are you converting off solaris to windoze? 8.1.7 runs fine on linux and you don't have to reboot your server all the time for the security patch du jour.

 

[matrixcd]

DataGuard is good option. The OS does not have to the same only the version of the database. After the database is replicate all have to do is just switch the user point at that instance and still have fail backup any thing go wrong.