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
Hi,
We currently do hot backups to disk and then dump to tape only the
directories that contain all the pices of the hot backups. We also do a
cold backup once a week to catch all of the O/S type stuff along with
Oracle.
I am assuming that anything else that is Oracle related would be static
[EMAIL PROTECTED] wrote:
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
We don't back up the filesystems that have the live data during our tape
backups. Since these files are effectively unusable there's no point in
saving them.
Jay Miller
-Original Message-
Sent: Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L
Hi all,
We are
We do rman online backups to disk and put just these backups on tape each
day. The sys admin takes care of system backups separately.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 3:28 PM
Hi all,
We are running
Title: RE: DB Backup Question
Dennis, your sysadmin is right. He shoudln't have to back up your raw data files, only your backup sets from your hot backups. I've seen this in practice at my previous position and have validated it as well.
If you are unsure, have you tried practicing
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
I only backup the archive logs and the directory that I put the hot backuped
data files. The rest really is useless.
-Original Message-
Sent: Wednesday, July 11, 2001 12:29 PM
To: Multiple recipients of list ORACLE-L
Hi all,
We are running into tape capacity problems and unix admin