RE: DB Movement from Sun to AIX ?

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 25 Jul 2005 13:49:24 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FA81@EXCNYSM0A1AJ.nysemail.nyenet>

Thomas,

Man! That's an interesting idea!

Did it work well for you? Any downsides?

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: Monday, July 25, 2005 1:44 PM
To: oracle-l_at_freelists.org
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.
--

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

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 25 2005 - 12:51:22 CDT