Re: upgrade oracle 8.1.7 to 9.2, with backup filesystem

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0407271640.1eaac8e2_at_posting.google.com>...
> yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0407261722.37b52537_at_posting.google.com>...
> > 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?
>
> Not sure what you mean by ..SID and related directories. What
> platform are you on? If windows, you will have registry issues. If
> unix, you should have separate oracle_homes and follow OFA. You
> should understand what your data, redo and control files are and what
> they do. For a major upgrade you want to have (probably multiple)
> cold backups.
>
> jg

/usr/sap/SID
/sapmnt/SID
/oracle/SID
/oracle/SID/sapreorg
/oracle/SID/sapdata6
/oracle/SID/sapdata5
/oracle/SID/sapdata4
/oracle/SID/sapdata3
/oracle/SID/sapdata2
/oracle/SID/sapdata1
/oracle/SID/saparch
/oracle/SID/origlogB
/oracle/SID/origlogA
/oracle/SID/mirrlogB
/oracle/SID/mirrlogA

These are what i meant by SID? so basically, these are the existing oracle filesystems. I was posting that if we have a backup of all these, then if something went amiss while upgrading, then i could have them back without a restore, though a restore will do the same.

what is your opinion? Received on Wed Jul 28 2004 - 21:34:21 CDT