| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> How slow/fast did upgrade go?
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
-- 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 Sat May 08 2004 - 19:37:34 CDT
 |
 |