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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
