RE: Backup Strategy

Hi Rachel ,

      Thanks a lot for your response ...Here are some details : (1)ost of our systems are of kind OLTP.There are some heavy hours of data processing transactions during the business hours ( Between 2 hours)....

(2) The issue is that our Dump files are some how too big and we have to care about resource utilization ....Normally we do a backup every weekend ....

Regards

> -----Original Message-----
> From: Rachel Carmichael [SMTP:wisernet100_at_yahoo.com]
> Sent: Monday, October 22, 2001 5:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Backup Strategy
>
> We'd need a little more information before we can give any advice
> (okay, this group gives advice on no information but..)
>
> Some questions:
>
> 1) during the business hours, do you add critical data that you can't
> afford to lose to your database? If so, you should be in archivelog
> mode. The cold backups will suffice if you have the archived logs.
>
> 2) cold backups (or hot backups for that matter) allow you to recover
> the whole database, but if you lose a table, or accidentally delete
> data from a single table, it is difficult to use the backups to
> retrieve the information. If your export dump files are not too large
> and you have the disk space to store them, I'd do a full database
> export daily as well. This does two things: allows you to recover a
> single table or some of its data easily and documents the structure of
> your database.
>
> Rachel
>
>
> --- Ahmed Gholam Hussain <ahussain_at_gisqatar.org.qa> wrote:
> > Dear all,
> >
> > I want your suggestions regarding our firm's backup strategy...
> >
> > Our business starts from 7.00 AM and ends at 2.00 PM ..We can not
> > afford
> > down times during our business period ....
> >
> > Normally , we are doing a cold backup every day using scheduled cold
> > backup
> > scripts .Is this backup good enough for any future failure ? Do we
> > need to
> > change our backup strategy ?
> > How often do we need to make exports ?
> >
> > Any suggestions would be appreciated ...
> >
> >
> >
> > Regards
> > Gholam
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ahmed Gholam Hussain
> > INET: ahussain_at_gisqatar.org.qa
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ahmed Gholam Hussain
  INET: ahussain_at_gisqatar.org.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).