Robert - My info:
Oracle 8.1.7 E.E.
Largest DB is 900gb
Hot Backups 2x week
Cold Backups 1x month
Export Backups 1x week on selective schemas
I do export backups for creation of test db's, recover data validation blunders, i.e.
single object restores.
Future plans are RMAN, RMAN, RMAN on 9i. I need incremental backups fast :)
Gene
[EMAIL PROTECTED] 09/20/02 10:53AM
Robert,
I don't do exports of our large production systems mainly due to the fact
that I'd have to export them to tape and getting that much quite time, so as not
to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is
impossible. Consequently two hot backups a week are the norm around here we
guard out archived redo logs very well.
Now I do take exports of selected tables before they get modified or mass
changed so that we have a point in time to go back to if all hell breaks loose.
Dick Goulet
Reply Separator
Author: Freeman; Robert [EMAIL PROTECTED]
Date: 9/20/2002 6:13 AM
I'd like to pose a question to you all and get your response. If you are
running a database that is larger than 250GB, what place in your backup
strategy does a logical export have? Do you do logical exports at all, and
if so with what frequency? Do you feel that logical exports are an important
part of your backup/recovery strategy?
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
The avalanche has begun, It is too late for the pebbles to vote.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
