Re: upgrade oracle 8.1.7 to 9.2, with backup filesystem

yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0407252209.1dccea75_at_posting.google.com>...
> Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.07.25.17.27.26.661959_at_sbcglobal.net>...
> > On Sun, 25 Jul 2004 03:41:28 -0700, yls177 wrote:
> >
> > > hi, i am in the midst of doing an oracle update as suggested by my
> > > subject post. In addition, i am thinking of
> > > doing a copy of all my sapdata, /oracle/SID and related files,
> > > directories to another place. This is so that when
> > > my upgrade fails, i can always copy these "copied stuff" back and i
> > > get my oracle 8.1.7 back instantly.
> > >
> > > what is your opinion?
> >
> > Jesus saves and so should you. Do backups. My opinion is that if you
> > started upgrading database before having a full cold backup, you're in
> > trouble.
>
> absoultely.... i will do a backup. but will my proposed solution be
> sufficient enough?

No. It is not only insufficient, it is outright dangerous. You propose taking a copy of an open database, and you think that is a valid backup. If you would need to use those copies, you would need to do recovery, and likely you can't because your copies are inconsistent, as you didn't take the normal hot backup precautions (ie placing a tablespace in backup mode)
Hopefully your regular backup doesn't use this approach. Don't even try to know better. Follow up Mladen's advice or be up for nasty surprises and a trip to the unemployment office.

Sybrand Bakker
Senior Oracle DBA Received on Mon Jul 26 2004 - 06:43:31 CDT