Re: Online Backups...

From: Shabbir Ali <ashabbir_at_sdt.com>
Date: 1997/08/19
Message-ID: <33F92886.601D7284@sdt.com>#1/1

John P. Higgins wrote:

> 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

  I do agree with John and Rich. Want to make an addition, if possible and if you have enough space, I will recommend to have export also with online backup. If possible once everyday or atleast once a week. Sometime it saves a lot of recovery time. Backup and recovery book from Oracle press is an excellent book to have.

--
Shabbir Ali
Database Administrator
The SABRE Group (SCS DBMS Tech)
E-mail: ashabbir_at_sdt.com
Opinion: My own

Received on Tue Aug 19 1997 - 00:00:00 CDT