How slow/fast did upgrade go?
- From: Michael Thomas <mhthomas@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 8 May 2004 17:40:35 -0700 (PDT)
Just curious, a couple upgrade related questions. I'm
on 9.2.0.4 and RHEL3ASu1, after upgrading.
Question 1)
Approximately how long did it take to upgrade one DB
from 9.2.0.1 (or even 8.x) to 9.2.0.z? (assume z=3+).
I'm guessing an upgrade to 9.2.0.3+ might also be a
requirement for upgrade from 9.2.0.1 to 10g.
With me, from 9.2.0.1 patching to 9.2.0.4, once you
run 'STARTUP MIGRATE', you get to run catpatch.sql,
and wait....
...wait...
...done. What was that? Mine was about an hour.
Question 2)
Has anyone run 'STARTUP DOWNGRADE' on an 10g instance
to 9.0.x and how long does that process take?
Assuming you started with 9.0/9.2.0.1 then you might
have to upgrade to 9.2.0.3+ first (see Question 1
above) just to get to 10g (see link below). Not good.
Then you could only go back to 9.0.3 plus. Sounds like
trouble if you can't use the backups. You have to run
some @d<oldrelease>.sql and @catrelod.sql, and I don't
know how long they take either.
link:
http://download-west.oracle.com/docs/cd/B13789_01/
server.101/b10763/downgrade.htm#sthref693
I don't think I like the idea of downgrading.
----------
In the future, if an upgrade is going to take a long
time, then Oracle will not be able to market 15 minute
installation times on 10g (with the latest patches,
whenever that occurs). This may be a marketing trend,
install in 15 minutes (and upgrade in <...fill in the
blank...>), done. ;-)
Oh well, maybe your upgrades went faster and you are
glad. Please say so. :-)
Regards,
Mike Thomas
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
