Re: Correct backup ?

From: martyn molnar (molnarm) <molnarm_at_SEQUENT.COM>
Date: Thu, 25 Jan 1996 08:56:08 -0500
Message-Id: <9601251956.AA21787@alice.jcc.com>

Pisano

There is also a strong Oracle recommendation that CONTROL Files are backed up first. I have been chewing this over with a number of DBAs over the last month or so. Would be interested in a definitive on this. The only reason I can think of is for consistency purposes.

Martyn Molnar

---

From: owner-oracle-l
To: Multiple recipients of list ORACLE-L Subject: Re: Correct backup ?
Date: 24 January 1996 08:51

Hi Chris Larson,

Please Send me Disaster Recovery Plan document Please.

Thanks in advance

 --Ch. Srinivas
  CMC Limited
  Hyderabad
  INDIA
  email: chsrini_at_tc4hq.cmc.stph.net

>
> If I understand you correctly you want to use on-line backups (Hot
backups,
> Warm backups, or whatever you want to refer to them as) as well as
off-line.
> I would STRONGLY suggest you backup all of your tablespaces and
> corresponding datafiles as well as logs and control files in both online
and
> offline mode.
> Depending on the importance of your data (I assume VERY important) I would
> suggest incremental exports as well.
>
> The more thorough your backup plan the better chance of up to the minute
> recovery.
> I have written a Disaster Recovery Plan that documents all these things
> using real life disasters. IF you would like a copy as well as a copy of
my
> online backup script let me know and I'd be glad to share them with you.
>
> HTH!
> Chris Larson
> Oracle DBA
> Control Data Systems
> Christopher.D.Larson_at_cdc.com
>
>
>
> >Hi Oracle Gurus,
> >I am also interested in this situation. Please reply to me also
> >Regards
> >A.Lim
> >
> >On Tue, 23 Jan 1996, Pisano Fiore wrote:
> >
> > Hello Oracle friends.
> >
> > I am writing a backup procedure that consist of following step:
> >
> > a) take on-line backup of this tablespace
> >
> > a1) system
> > a2) temp
> > a3) tool
> > a4) user
> > a5) rbs
> > a6) mytablespace
> >
> > b) make a copy of archived redo log files
> >
> > c) make a copy of control file
> >
> > I think to use this procedure every night by cron.
> > My questions are:
> >
> > 1) Is this all to recovery every problem ?
> >
> > 2) If I use for my application only "mytablespace" I need to backup
> > tools ,temp,user tablespace ?
> >
> >
> > Thanks in advance!
> > Pisano Fiore
> > e-mail address <pisano_at_solaria.bsav.bull.it>
> > phone 0-825-764388
> > Bull Sud HN
> > (Avellino) Italy
> >
>
Received on Thu Jan 25 1996 - 14:56:53 CST