From oracle-l-bounce@freelists.org Wed Jul 7 13:14:52 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67IEbG18815 for ; Wed, 7 Jul 2004 13:14:47 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i67IEQ618788 for ; Wed, 7 Jul 2004 13:14:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E14B372CF07; Wed, 7 Jul 2004 12:55:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14145-30; Wed, 7 Jul 2004 12:55:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB81472CFED; Wed, 7 Jul 2004 12:54:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 12:52:42 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C55772CF6E for ; Wed, 7 Jul 2004 12:52:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13700-01 for ; Wed, 7 Jul 2004 12:52:39 -0500 (EST) Received: from hotmail.com (bay2-f17.bay2.hotmail.com [65.54.247.17]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 762C072C658 for ; Wed, 7 Jul 2004 12:52:19 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 7 Jul 2004 11:15:32 -0700 Received: from 165.89.84.88 by by2fd.bay2.hotmail.msn.com with HTTP; Wed, 07 Jul 2004 18:15:31 GMT X-Originating-IP: [165.89.84.88] X-Originating-Email: [rafiq9857@hotmail.com] X-Sender: rafiq9857@hotmail.com From: "M Rafiq" To: oracle-l@freelists.org Subject: Re: Quick migration question Date: Wed, 07 Jul 2004 14:15:31 -0400 Mime-Version: 1.0 Content-type: text/plain Message-ID: X-OriginalArrivalTime: 07 Jul 2004 18:15:32.0223 (UTC) FILETIME=[641040F0:01C4644E] X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4582 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rafiq9857@hotmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Diego, If you have java objects installed then you may add atleast around 1 hour 30 minutes more than normal migration time. I have migrated 7/8 databases from 8.1.7.4 to 9.2.0.X in 1 to 3 hours including recompilation of objects. If you are talking about Oracle Financials database, it depends on much modules you have installed. Just recompilation of invalids might take around 3 to 4 hours depending upon power of your server. Regards Rafiq From: "Diego Cutrone" Reply-To: oracle-l@freelists.org To: Subject: Re: Quick migration question Date: Wed, 7 Jul 2004 09:29:52 -0700 Tanel, Thank you very much for the insight, it's been very useful for me. Regards Diego. ----- Original Message ----- From: "Tanel Põder" To: Sent: Tuesday, July 06, 2004 4:00 PM Subject: Re: Quick migration question > 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" > To: "Oracle List" > 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@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@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@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 ----------------------------------------------------------------- _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------