Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Correct backup ?

Re: Correct backup ?

From: GurPratap Singh <aviion_at_HCLIND.HCLC-GGN.HCLA.COM>
Date: Thu, 25 Jan 1996 08:56:27 -0500
Message-Id: <9601251957.AA06269@alice.jcc.com>


>
> 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
> >
>
 I would like to hv that copy...

 e-mail at:aviion_at_hclind.hcla.com

 thanx Received on Thu Jan 25 1996 - 14:57:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US