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: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 26 Jul 2005 22:44:01 +0530
Message-ID: <B5587533FCBD4344ADB8290B3EDDA122073ED937@kecmsg14.ad.infosys.com>

Jamie

Thanks indeed for the advice

Some Questions here:-

  1. What is UNDO's significance in the refresh process? Any advisable guiding principle for sizing undo_retention parameter appropriately?

Regards

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jamie Kinney Sent: Tuesday, July 26, 2005 9:41 PM
To: tomday2_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: DB Movement from Sun to AIX ?

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

**************** 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***
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 26 2005 - 12:18:18 CDT

Original text of this message

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