| 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 of large databases
Ed,
We have a 180 Gig database on Sun Solaris 2.6, version 8.0.4 of Oracle.
We use RMAN and Veritas to back up to tape. Archiving is turned on.
Full hot backups are done once a week. Incremental backups are done at mid-week. It takes about eight hours to do the full backup to tape.
We used to run an hourly RMAN job that would back up our archive files
to tape and then delete them from disk. We found that with the few
recoveries
that we've had to do, the part that took the most time was the robot
finding and mounting
the tapes that contained the archive files. Our goal is to decrease the
number
of archive files that we have to get off of tape, thereby decreasing our
mean time to recover.
We requested additional disk in order to be able to keep a weeks
worth of archives on hand. The reality is that we have occasssional
peaks of activity that have frequently caused us to run through most of
our archive directory in a single day. We're still trying to tweak the
interval
between archive backup jobs.
Our agreement with the users of this database is that we will complete a database recovery within 12 hours. To this point, we've been successful in doing so with the three recoveries that we've had to do.
We've told the users that if they want a faster recovery time, we will need to implement BCVs (we have EMC disk) or some other, more expensive solution.
We also do a weekly logical backup using export piped to split UNIX files.
We have not had to do a logical recovery on this database yet. Since it
is a data warehouse, it is probably faster for them to reload a day's worth
of
data than it us for us to truncate some of the larger tables and re-import
the
data from a dump.
We also do a daily export of just the structure of the data objects without
the
rows of data.
We do not do cold backups on this database.
Cherie Machler
Oracle DBA
Gelco Information Network
"Ed Lewis"
<eglewis_at_hotma To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
il.com> cc:
Sent by: Subject: backup of large databases
root_at_fatcity.c
om
10/26/01 01:51
PM
Please respond
to ORACLE-L
Hello,
I'm curious how people handle the backups for large/very large databases; 200gb or greater.
My questions are not targeted towards any specific hardware platform, but we are using Oracle 8.1.7. I'm assuming that archiving is enabled.
Are backups done nightly, or because of time constraints are they done weekly ? If weekly, do you feel comfortable having to possibly apply a week of archives, in the case of a recovery ?
Do you use disk or tape ?
Do you use RMAN or other backup tools ?
What are the customer's expections for recovery and how do they effect your backup strategy ?
I appreciate your input.
ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Cherie_Machler_at_gelco.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). Received on Fri Oct 26 2001 - 13:19:43 CDT
 |
 |