Re: Moving to new Server and upgrading Oracle

Well, just got a high level explanation of their plan to migrate our databases.

This involves:

1. Copy the 8.0.5.2 Oracle binaries over.
2. Move the datafiles over (with the identical data structure that we have on our E4500's even tho it's changing to an OFA compliant structure with a recommended 14 Luns vs. 5 Luns current). Recover the database.
3. Test the current configuration environment of the 8.0.5.2 software .
4. Change the Lun configuration on the new E10K's to reflect the new environment wanted. Move the datafiles to their new location.
5. Update the Oracle control files to reflect the new data structure environment
6. Upgrade the Oracle software to 8.0.6
7. Bring over the archive logs from the running instance on the old server, and roll forward.
8. Test the new environment.

Am I missing something here, or is this the most bizarre plan I have ever heard of.

Bob Fazio wrote:

> Actually I would expect that Sun would suggest the import export over the
> datafile move. How big/ how long do you expect it to take. I am not sure
> of why you need the incremental. Also, I have actually be quite successful
> doing an export to a pipe, and importing. This eliminates the time for the
> export. I would say, what ever you are move comfortable doing, do.
>
> --
> Robert Fazio, Oracle DBA
> rfazio_at_home.com
> remove nospam from reply address
> http://24.8.218.197/
> "A" <A_at_yahoo.com> wrote in message news:394B16F2.73F79DEE_at_yahoo.com...
> > We are currently running Oracle 8.0.5.2 on Solaris 2.7 on a Sun E4500.
> > Because of rapid growth, we are moving to an Oracle HA/Clustered
> > environment on an E10000, and will be running Oracle 8.0.6 (not all of
> > our apps run on 8i :-(( ).
> > Currently our databases are not large enough to rule out an
> > export/import to accomplish the move and upgrade. (One would involve a
> > full export/import, and then an outage with incremental export/import,
> > all others could be accomplished with just an outage and full
> > export/import).
> > However, I am not sure if that is the approach that will be recommended
> > by Sun Professional Services.
> >
> > Can anyone provide their views on the pros and cons of just installing
> > 8.0.6 on the new E10000 and doing an export/import of the data (which
> > would definitely help with some
> > tablespace fragmentation on a couple of the db's) , vs. moving the
> > datafiles over with an Oracle 8.0.5 install and upgrading?
> >
> > I would prefer the export/import option, but would like to see others
> > views.
> >
> > TIA
> >
> >
> >
Received on Tue Jun 20 2000 - 00:00:00 CDT