Re: Online Backups...

Rich Woods wrote:
>
> Phil Harris wrote:
>
> > I am looking at implementing a backup strategy for our db (7.3...).
> >
> > It is running 24 * 7 and therefore I need to make online backups.
> >
> > I have just attended the BR7, and they say that it is fine. Just set
> > the
> > table space to backup mode, the do an operating system copy. The
> > actual
> > backup may be inconsistent, but when you apply the redo logs, it'll
> > iron
> > it all out...
> >
> > Does anyone have any advice for me. Is it really as easy (and as
> > reliable) as the bloke made out, or is it a real nighmare???
> >
> > Thanks in advance...
> > --
> > Phil Harris
>
> Phil,
>
> Relax. It isn't that difficult once you understand the process.
>
> I strongly suggest you get a copy of the Backup & Recovery Handbook from
> Oracle Press. It will walk you through step-by-step how to setup hot
> backups and how to recover various components of a database from a hot
> backup.
>
> --
> Rich Woods
> Technical Field Support Specialist, Oracle Corporation, USA
> The above statements and opinions are my own and do not
> necessarily represent those of Oracle Corporation.

I agree with Rich. Been there, done that. We have been using hot backups for ~5 years. If you do the backups right (alter tablespace begin backup -- backup -- alter tablespace end backup) recoveries work -- both complete and point in time.

Do use a SQL script to create your backup script on-the fly. That way it adjusts to added/dropped tablespaces/files.

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own