Re: DB Movement from Sun to AIX ?

VIVEK_SHARMA wrote:
> MY QUESTIONS IN CAPITALS BELOW ARE STILL UNANSWERED.
[...]
> 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?
>

[...]
>
> 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.
> NOTE AIX Storage Box is external to the machine & respective DB Machine
> is of Very High Configuration.
>

[...]
>
> 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?
[...]
> 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

What is a "hybrid database"? What is a "Very High Configuration"?

Your main issue is not the physical distance between servers. If your management has decided not to use a network connection, then you have already received several suggestions on how to physically transport the data.

(Just out of curiousity, if your end users can use both the old and the new databases, how can there not be any network connectivity available between the two sites? Are all the end users going to physically relocate 20 km along with the database?)

Your biggest problem is that you are moving across OS platforms and major versions of Oracle. It would be foolish in the extreme to not conduct extensive testing of your application prior to moving your production database in this situation. The changes between 8i and 9i are many and non-trivial, starting with init.ora. This is why Oracle publishes extensive release and migration notes.

A quick check of the Oracle on-line documentation will inform you that cross-platform transportable tablespaces are only available in version 10g. Then, your test runs will clue you in as to exactly how long the export/import will take using your hardware.

Why are you asking about materialized views? If you had network connectivity between old and new sites, you could implement Advanced Replication (with plenty of testing) as a possible means of speeding up the switchover, but you don't.

-- 
Mark Bole
http://www.bincomputing.com



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