Re: Quick migration question

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Wed, 7 Jul 2004 02:00:15 +0300
Message-ID: <005b01c463ad$008959f0$7ea423d5@porgand>

The upgrade speed doesn't really depend on how much actual data you got in your tables.
The most time-consuming job in an upgrade like this, is the migration of data dictionary and recompilation of objects. Other changes, like changing controlfiles, datafile headers, logfiles and rollback segments, will usually take little time.

Oracle will NOT go through any datafile to change or reformat any datablocks during the upgrade (it didn't do so even when the data block format changed fundamentally between version 7.3 and 8, it just reformatted required blocks later on, "on the fly").

So if you don't have much more objects and PL/SQL in your current system than the last one upgraded (and don't have tens of thousands of datafiles), you should be able to complete your upgrade about in the same timeframe than the last one.
I'd say in less than couple of hours without any tweaks or tricks, given than you could recompile your PL/SQL & other objects in parallel.

It's possible to get the upgrade process very fast - but this means unsupported parameters & techniques.

Tanel.

Original Message ----- From: "Diego Cutrone" <diegocutrone_at_yahoo.com.ar> To: "Oracle List" <oracle-l_at_freelists.org> Sent: Wednesday, July 07, 2004 4:41 AM Subject: Quick migration question

> Hi list,
> Based on your experience, how much time you think it may take to migrate a
2.1 TB database from 8.1.7 to 9.2
> by using "startup migrate" procedure. The database is in a HP Superdome
with 16CPUs 64GB Ram.
> I know the time depends on many other factors but I'd just like to have a
rough estimation....that's all.
>
> I have used this procedure in a much smaller database and didn't take a
long time to complete,
> I wonder how much it will take in a much bigger database. Had anyone
performed a migration like this?
>
> Thanks in advance.
> Regards
> Diego.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 06 2004 - 17:56:58 CDT