RE: DB Movement from Sun to AIX ?

This may sound a bit minimalist, but you can buy a 300Gb-512Gb firewire drive 
for $300-$500 or so.  Make it into NFS mounted volumes presented from a 
laptop.  Copy files to it, pack up the laptop and the drive(s) and then just 
drive to the other facility, repeat process in reverse.

Sound far-fetched?  I did exactly this with a 200Gb "secret" government 
database last year, except I had to fly between data centers (won't explain 
almost getting cavity-searched at the airport for booking a one-way ticket on 
short notice!).  Overall, this worked faster and better than all of the other 
more elaborate plans involving temporary T1 lines, rented/loaner storage 
arrays, etc...

Keep it simple.


On Mon, 22 Aug 2005 20:47:49 +0530, VIVEK_SHARMA wrote
> Folks
>  
> Need to migrate a big production Hybrid database from Oracle 8.1.7 
> on Sun to 9.2 on AIX.
> 
> Main issue is that Source & Target DB Boxes/Machines being Located 
> 20 KMs apart there is NO connectivity between them currently NOR 
> being planned.
> 
> Existing Options:-
> 
> NOTE AIX Storage Box is external to the machine & respective DB 
> Machine is  of Very High Configuration.
> 
> 1) Connect temporarily a Smaller AIX Box/machine with the required 
> external storage Box(which is going-to-become production) at the 
> location of the source SUN Server. After using suitable methods for 
> Data transfer e.g. DB Link, Materialized views, exp/imp thereafter 
> disconnect the external Storage, physically transport/shift it to 
> the Target location & connect it to the High End AIX machine.
> 
> Qs Since this is an IO intensive Operation, how will a smaller Box 
> with a few CPUs impact the speed of Data transfer from the SUN Server?
> 
> 2) If Above is NOT possible, fire export(exp) of those Larger 
> History Tables which do NOT get updated for past data, transport exp 
> dump manually to target machine & import into Target DB. Thereafter 
> insert incremental records which are added.
> 
> 3) Is it possible to use some unsupported parameters to move the 
> Data/Database (e.g. thru transportable Tablespaces) from SUN into 
> the AIX Target machine? Thereafter data can be moved from this 
> unsupported DB into Another NEWLY created Database on the same 
> Server using conventional means e.g. DB Link, CTAS etc?
> 
> Miscellaneous info:-
> 
> AIX box is going to be a NEW installation.
> 
> It is also NOT possible to physically re-locate the production SUN 
> server to the Location of the AIX Box.
> 
> Source Database is on Sun with Oracle 8.1.7
> Target DB needs to go to AIX on Oracle 9.2
> DB size - 600 GB
> Application - Online Hybrid Banking Application
> Num of Users - a few thousand Bank Staff users
> Application is NOT on the internet. Hence can be brought down for 
> about 6-8 hours   Any advice is welcome.
> 
> Thanks
> 
>  
> 
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION 
> intended solely for the use of the addressee(s). If you are not the 
> intended recipient, please notify the sender by e-mail and delete 
> the original message. Further, you are not to copy, disclose, or 
> distribute this e-mail or its contents to any other person and any 
> such actions are unlawful. This e-mail may contain viruses. Infosys 
> has taken every reasonable precaution to minimize this risk, but is 
> not liable for any damage you may sustain as a result of any virus 
> in this e-mail. You should carry out your own virus checks before 
> opening the e-mail or attachment. Infosys reserves the right to 
> monitor and review the content of all messages sent to or from this 
> e-mail address. Messages sent to or from this e-mail address may be 
> stored on the Infosys e-mail system. ***INFOSYS******** End of 
> Disclaimer ********INFOSYS***
> --
> http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Other related posts: