Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB Movement from Sun to AIX ?

Re: DB Movement from Sun to AIX ?

From: Jamie Kinney <oracledude_at_gmail.com>
Date: Tue, 26 Jul 2005 09:11:25 -0700
Message-ID: <478114105072609111e587b8f@mail.gmail.com>


I'm currently in the middle of a Oracle 9i cross-platform migration using the materialized view approach. I also recommend that you try this method. I also recommend that you take a look at DDL Wizard, a free tool available at http://www.ddlwizard.com/ which can be used to easily generate and batch modify the DDL for your new system. I used this tool to generate DDL scripts with new schema names and storage characteristics.

The only painful part of the process is the initial complete snapshot refresh of VERY large tables. Prior to 10g, this data is moved serially, which means that tables might take a day or more to instantiate. Be sure to set undo_retention appropriately and give enough space to your undo_tablespace.

-Jamie

On 7/25/05, Thomas Day <tomday2_at_gmail.com> wrote:
> 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 Tue Jul 26 2005 - 11:13:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US