Link to home
Create AccountLog in
Avatar of oraclescsa
oraclescsa

asked on

Migration of oracle 10g from AIX 5.3L to Windows 2003 or 2008

Dear All ,
 
We are planning to migrate or deploy  Oracle 10g from AIX 5.3L to Windows 2003 or 2008 for testing purpose.  In short an exact copy of the database on Windows Server.
My database size is 99 GB .

AIX Version 5.3L
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 64bit

I know that it can be done using datapump or imp/exp. I need step by step information to migrate from aix to windows.
ASKER CERTIFIED SOLUTION
Avatar of Rich Olu
Rich Olu
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
What kind of disk system do you have for the Windows server?  You should *NOT* use only local SCSI or SATA disks that are all in one RAID5 array!  Oracle on Windows will perform *MUCH* better if you have some RAID1 (or RAID10) disks for the system, undo, data and index tablespaces as well as the on-line redo logs.  The temp tablespace, the Windows swapfile and archived redo logs could (or should) be on RAID0 or a non-RAID disk.  The Windows and Oracle executables can be on RAID5 if you like.
Avatar of oraclescsa
oraclescsa

ASKER

Dear Markgeer,

We are using RAID 1 system. There is no issue with the performance as this system is going to be a testing system. I am trying to follow the above methods which was suggested by above experts.
OK, you should be fine then.  One other thing you may want to check or change is the archivelog mode in the new Windows database.  Set that to "noarchivelog" while you do the intial database configuration and the import.  Then if you want it in archivelog mode after that, do a shutdown and a backup and switch the archivelog mode.  But having archivelog mode on while you do the import will slow down the import considerably.