Re: upgrade oracle 8.1.7 to 9.2, with backup filesystem

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0407301421.66dc50dc_at_posting.google.com>...
> yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0407281834.11008fdc_at_posting.google.com>...
> > 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?
>
> My opinion is that is ok as long as you understand when to restore
> control files and redologs, since that is what I see most often messed
> up by those who don't understand how things work. Also, be sure you
> understand the difference between restoration and recovery. I don't
> understand the difference between what you are proposing and a cold
> backup and am assuming there is none, so I also say listen to Mladen.
>
> jg

you wrote "when to restore control files and redologs, since that is what I see most often messed up by those who don't understand how things work"

could u share what you have seen....? Received on Sat Jul 31 2004 - 04:11:42 CDT