| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
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 - 10:19:34 CDT
 |
 |