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