I realize you have a problem with resource utilization, but what will
cost more: buying disks so you can keep the backups and archived logs
or losing the data because you only have a cold backup from a week ago?
Again, if you can deal with losing a day's worth of data, your cold
backups are fine. If not, then you need to be in archivelog mode and
keep the archived logs.
- Ahmed Gholam Hussain <ahussain_at_gisqatar.org.qa> wrote:
> 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).
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).
Received on Mon Oct 22 2001 - 13:31:37 CDT
