RE: DB Movement from Sun to AIX ?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <tomday2@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 25 Jul 2005 13:49:24 -0400
Thomas,
Man! That's an interesting idea!
Did it work well for you? Any downsides?
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
Sent: Monday, July 25, 2005 1:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: DB Movement from Sun to AIX ?
How about materialized views?
Create your tables on the AIX box and then create materialized views
using those tables to replicate the Sun data.
When everything's up to speed, cut your users off, do one last
refresh, and drop the materialized views on the AIX box. The
underlying tables will remain with their data. Change the entry in
ONAMES and your users start up in the AIX box right where they left
off on the Sun.
It's not quite as simple as that. Spend about 2 months planning it
and rehearse it at least twice.
We used it to migrate an 80G database to AIX. User downtime was 15
minutes.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
