We'd need a little more information before we can give any advice
(okay, this group gives advice on no information but..)
Some questions:
- 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.
- 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).
Received on Mon Oct 22 2001 - 07:52:01 CDT
