RE: DB Movement from Sun to AIX ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracledude@xxxxxxxxx>
- Date: Tue, 26 Jul 2005 22:44:01 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jamie Kinney
Sent: Tuesday, July 26, 2005 9:41 PM
To: tomday2@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
--
//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***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
