Re: Moving to new Server and upgrading Oracle

I agree with you Bob.
In fact, it's my final call, and I think I will put my foot down on this one :-). I'm comfortable with either, but feel the export import is the best option in our situation.
Our current largest database is only around 30GB, (The largest table is around 40 Million rows).
We are a 24X7 shop, so the downtime allowed is basically as little as possible, thus the incremental export.
I feel the export import option gives us a better deal overall -- the move of the data, the upgrade to 8.0.6 and the defragmentation (not horrible amounts of fragmentation, but a small amount which will be fixed with the new sizing after the move :-)). Plus it's better to start of on a clean slate.

Additionally, our overall datafile layout and directory naming is going to change, so moving the datafiles would cause more headaches.

Currently I'm exporting to pipe anyhow to save disk space as well as because of the size of our databases.

Thanks for your post and suggestions.

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 Sun Jun 18 2000 - 00:00:00 CDT