RE: DB Movement from Sun to AIX ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, "Thomas Day" <tomday2@xxxxxxxxx>
- Date: Wed, 24 Aug 2005 16:20:33 +0530
MY QUESTIONS IN CAPITALS BELOW ARE STILL UNANSWERED.
Additionally
1) Is there any V$ View etc which shows Status of Refresh (Running, %
Complete, FULLY Complete etc)?
2) Any Good Docs, Links on Materialized Views?
(I am looking at metalink, google though)
Thanks again for all the previous responses
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: Monday, August 22, 2005 8:48 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: Thomas Day
Subject: RE: DB Movement from Sun to AIX ?
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 PRODUCTION 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" MEANS/PROCESSES(e.g. thru
transportable Tablespaces) TO MOVE DATA/DATABASE FROM SUN INTO 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***
Other related posts:
