Re: upgrade oracle 8.1.7 to 9.2, with backup filesystem

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0407260343.5ae97586_at_posting.google.com>...
> 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

agreed with what u wrote. when i meant "copy the existing filesystem to another filesystem" i am doing the either of the below 1) shutdown my oracle and copy the filesystem or 2) issue "begin backup" of my datafiles

what do u think now? Received on Mon Jul 26 2004 - 20:22:11 CDT