And yet another perspective.....
Dennis;
Things to keep in mind:
1. Tapes are cheaper than rebuilding all the data by hand.
2. Managers who make decisions to put tape cost more important can
be replaced.
Basic Backup Schedule:
Backed up logs Hourly
Hot Incremental Backup weekly
Cold Backup Monthly
Tape Recovery:
We kept between 1 and 2 months worth of backups on hand. At the
beginning of each month we deleted all tapes from the month PRIOR to the
last cold backup. So, at the beginning of each month, we had 1 month of
backups. Over the next month this grew to 2 months of saves until we hit
the end of the month again and started the deletion process again.
If you are not that paranoid as we were then I would suggest reducing the 1
- 2 month range down to 1 - 2 weeks. Every week you delete the old data 2
weeks ago.
I guess the key thing to remember is that , after the cold backup, as long
as you can guarantee the cold backup tape is good, then the previous hot and
log backups are superfluous
Kevin
-----Original Message-----
Sent: Wednesday, July 11, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Dennis,
This is the method we've been using for many years. There has never been a
case where the open datafile has been required for any kind of restore.
However, I can count on one hand the number of times where we had to go to
tape for a database recovery. FWIW
Michael Hand
Polaroid Corp
-----Original Message-----
Sent: Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L
Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: Hand, Michael T
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: Kevin Lange
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).
