Re: DB Version upgrade with CreateDB/Import "Risky"???

Hello James

In the last 2 years I did about 5-6 migrations from 7.3.4 to 8.1.6.0 and 10-12 from 8.1.6.0 to 8.1.6.3.4.
All done on NT with upgrades.
No scratch and rebuild. No problems at all.

Sorry to disappoint you.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Sunday, May 05, 2002 6:23 PM

> Hello fellow Oracle DBAs,
>
> I really need your opinion on this matter:
>
> I routinely do upgrades of Oracle software and databases on all types of
> systems: Compaq Unix, Netware, Linux, etc. (as do we all from time to
time).
> On one Windows/NT 4 system where I am presently doing an upgrade from a
> lower version of Oracle 8 to 8.1.7, I am dealing with a particular System
> Administrator for the NT box who knows a little about Oracle, but that is
> obviously laboring under some misconceptions.
>
> He strongly believes that the ONLY way one should upgrade a database (once
> the software has been upgraded) is to do a "migration" (presumably as
> detailed in the Oracle Migration manual) and he is URGING me to do it this
> way.
>
> On small databases (i.e. less than 10G) where downtime is not an issue,
the
> way I have always done it and the way I intend to do it this case is:
>
> (1) Take a full database "export" under the old version
> (2) Install the Version 8.1.7 software
> (3) Recreate from scratch the database under the new software
> (4) Do a full database "import" to the new database.
>
> For our systems, I as the DBA believe and have found this to be a fully
> reliable, quick, and clean method and the preferable way to do it, rather
> than go through the migration procedure. He on the other hand believes
that
> NOT doing it via the "migration" route is very "risky".
>
> Without going into a long spiel with him about what an upgrade IS as far
as
> the database itself is concerned (i.e. the data dictionary objects being
> brought up to the new version), and why the way I intend to do it with a
> full import is perfectly acceptable to accomplish this, I'd like to just
> offer this person the opinions of some of you out there in ORACLE-L List
> Land where the Oracle DBA expertise is highly respected for its stature,
> I.E. so he doesn't have to believe me.
>
> In other words, I don't want to try to convince him against his
> will......I'd rather have impartial competent experts give him unbiased
> testimony. Thus I humbly solicit your opinion on this matter. I believe
that
> my above procedure is a simple and fully reliable way of bringing the
> database up to the new software level......or perhaps it is ***I*** that
am
> laboring under the misconception??? May I please have your take on
> this.....
>
> Much appreciate,
>
> JDamiano
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: James Damiano
> INET: jadam_at_nhes.state.nh.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adaryechiel_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).