RE: Backup Strategy

Anmed - I would encourage you to carefully research the exact reason you can't run in archivelog mode. Besides providing up-to-the-minute recovery, it can minimize downtime under many other failure modes.

        Also, you need to discuss this with your users until everyone is satisfied what the risk is. People react better if they are forewarned. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, October 22, 2001 1:25 PM
To: Multiple recipients of list ORACLE-L

Hi Kimberly ,  

   Thanks a lot for your response .....

   Due to some resource limitation , we can not afford running our database on archive log always ...
What we are doing now is daily cold backups with weekend based exports ... Most of our systems are OLTP .. Are we on good track ?

Regards

> -----Original Message-----
> From: Kimberly Smith [SMTP:kimberly.smith_at_gmd.fujitsu.com]
> Sent: Monday, October 22, 2001 7:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Backup Strategy
>
> Why export at all? As long as your database is in archive log
> mode you should be ok. Do your cold backup to disk and always
> have the latest on disk. That way you reduce your recover time
> by not having to go to tape for your backup. I have all our OS
> backups scheduled to go after the backup for Oracle and that way
> I get the backup files off to tape just in case I have a really
> horrible failure.
>
> Make sure that your archive logs are on a different disk then your
> database files. You increase your chance of being able to fully
> recover.
>
> You may also want to consider running a standby database in case
> of failure during business hours. I don't run one here but I run
> with ServiceGuard instead.
>
> -----Original Message-----
> Sent: Monday, October 22, 2001 3:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> It will depend on how much data you can afford to lose (in terms of time)?
>
> may be you can do
> exp at 8, 9, 10, 11, 12, 13
> Cold backup at 14
>
> or perhaps you want to consider RMAN
>
>
> Sinardy
>
>
>
> -----Original Message-----
> Gholam Hussain
> Sent: Monday, 22 October 2001 6:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinard Xing
> INET: sinardyxing_at_bcs-ach.com.sg
>
> 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: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).