RE: DB Movement from Sun to AIX ?

"Firewire" is just the cable hardware -- not software.

Should have elaborated better, sorry...

What I did in the previously mentioned migration was present the external drives (physically connected via Firewire on my laptop) as NFS-mounted filesystems  on the target system.

Since you are converting platforms, you can't just copy the physical datafiles. So, I generated some scripts to use the Oracle "exp" utility to export (via UNIX named pipes) through the UNIX "compress" command to place compressed export "dumps" on the NFS file-systems. Yes, NFS is slow, but if you pass fewer bytes through it, then things go faster.

So, unloading the source database involved generating compressed export dumps down to NFS. Then, disconnect everything, travel to the location of the target database, reconnect everything, and use the Oracle "imp" utility to import from the compressed dump files from the NFS file-systems.

The database I last did this with was Oracle Apps R11.00, where the database itself (i.e. datafiles) sized around 400Gb. The compressed export dumps came to about 180Gb, which easily fit on a single Maxtor "OneTouch" Firewire external drive, which cost less than $200 at CompUSA.

On Mon, 22 Aug 2005 21:30:59 +0530, VIVEK_SHARMA wrote
> 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_at_evdbt.com]
> Sent: Monday, August 22, 2005 9:20 PM
> To: VIVEK_SHARMA; oracle-l_at_freelists.org
> 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***
> > --
> > http://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***

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