Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup Strategy - Informal Survey
An export with data will probably cause more headaches than it solves in
large DBs.
A logical export without data will also have limited use. It is quick to do and small but I suggest may be invaluable for various tasks.
Mike Jenner
Database Administrator
-----Original Message-----
Sent: 20 September 2002 15:53
To: Multiple recipients of list ORACLE-L
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" <Robert_Freeman_at_csx.com> 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: Robert_Freeman_at_csx.com
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: 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 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: 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: Jenner Mike
INET: M.Jenner_at_southampton.gov.uk
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: 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 Fri Sep 20 2002 - 10:38:32 CDT
![]() |
![]() |