RE: DB Movement from Sun to AIX ......?
- To: <tim@xxxxxxxxx>, <rjamya@xxxxxxxxx>
- Date: Mon, 22 Aug 2005 21:36:20 +0530
Hope I am Not flooding as I received Delivery failure
-----Original Message-----
From: VIVEK_SHARMA
Sent: Monday, August 22, 2005 9:31 PM
To: 'tim@xxxxxxxxx'; 'rjamya@xxxxxxxxx'
Cc: Thomas Day; oracle-l@xxxxxxxxxxxxx
Subject: RE: DB Movement from Sun to AIX ?
Tim, Raj
Am unable to follow.
Do you mean OS Copy Cold Datafiles from SUN to "firewire Drives" at source
location & reverse Copy from "firewire Drives" to AIX at Target Location?
Is firewire some new technology that allows the above?
Some details please?
Thanks so much
-----Original Message-----
From: Tim Gorman [mailto:tim@xxxxxxxxx]
Sent: Monday, August 22, 2005 9:20 PM
To: VIVEK_SHARMA; oracle-l@xxxxxxxxxxxxx
Cc: Thomas Day
Subject: 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***
> --
> //www.freelists.org/webpage/oracle-l
**************** 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***
--
//www.freelists.org/webpage/oracle-l
Other related posts: