Re: Upgrade 9 to 11 & Big Endian to Little Endian

From: orcl <orcl_at_att.net>
Date: Thu, 02 Sep 2010 21:10:38 -0400
Message-ID: <4C804B0E.4010201_at_att.net>



Hi, we need as straightforward, (fewest moving parts) repeatable method to do this. So the mviews... and all that is going to be much too messy - we have about 50 databases > 500gb, the outage could be several hours... ie how fast files can be transferred across the network - ie as would the rman convert technology.

In the past we have done multi terabyte conversions - but the source databses we all 10g, now they want to do it from 9...

If it was a few databses then it could be more hands on method, but this is a larger scale.

Thanks
Bob

Leyi Zhang (Kamus) wrote:
> Hi orcl
>
> 1. Maybe you should know RMAN CONVERT will be a long time operation,
> I'm not sure which is faster compared to a well tuned exp+imp work.
>
> 2. What is your database outage time window? several hours or several minutes?
>
> 3. You can use exp+imp for the initial step, then create material view
> log on every important table in 9i database, and create material view
> refresh ON PREBUILT TABLE in 10g database, when finally 10g data
> synchronized with 9i data, then plan an database outage time (will be
> very small. like several minutes) and drop the mv in 10g but leave the
> tables, switch 10g database to production.
>
> --
> Kamus<kamusis_at_gmail.com>
>
> Visit my blog for more : http://www.dbform.com
> Join ACOUG: http://www.acoug.org
>
>
>
> On Fri, Sep 3, 2010 at 5:01 AM, orcl<orcl_at_att.net> wrote:
>
>> All - We have a bunch of databases on Solaris 9.2 (big endian) that need to
>> be upgraded to 11.2 on Linux (little endian).
>>
>> Since 9i doesnít have an rman convert datafile, what are the options to make
>> the move in one shot?
>>
>> Im pretty sure imp/exp can do the smaller databases but most of them are
>> large, so that wonít be an option.
>>
>> I bet another suggestion is to upgrade first to 10... then use rman convert,
>> I donít think management will support a "two hop" upgrade. (double work,
>> double outage, double testing)
>>
>> Does anyone have firsthand experience of the hard and fast options for this
>> situation?
>>
>> I did some initial research and its all saying imp/exp or go to 10 first.
>>
>> Im looking for other options. (if any)
>>
>> Much Appreciated
>>
>> Bob
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 02 2010 - 20:10:38 CDT

Original text of this message