| 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: Hot Backups -- to Disk OR to tape direct
Hemant,
I think not the backup, but the restore requirements should be the driving force. Just ask the managemen/check the SLA for how much time is allowed for a restore!
When the backup to tape is simply tar'ed or cpio'ed, restoring all file, or just the the last one, might well exceed this timeframe.
When 80 GB is large, given the cost of disks, I would always store at least one backup (probably more) on disk. Recovery from a human error, or just a storage error not affecting the server itself can be pretty much faster then.
Too often backup is taken as the starting point, where the restore/recovery process should be taken to define the requirements for the backup.
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
>
> Conducting a survey here ...
>
> What is the preferred method of Hot Backups
> {where you do not have a SAN with SnapClones) and
> the database is large [say more than 80GB,
> against the DLT drive of 40GB tapes]
>
> 1. Scripted Hot Backup to Tape, spanning tapes in
> an AutoLoader configuration [the switching of tapes
> has to be scripted into the Hot Backup]
>
> 2. Scripted Hot Backup to Disk, followed by a subsequent
> backup to tape
> a. With a compressed image of the DB on Disk
> b. To an uncompressed image on Disk
>
> Assume : No Media Manager Libraries available for RMAN
> so backups have to be scripted with ALTER TABLESPACE
> BEGIN ... END ...
> Hemant K Chitale
> http://hkchital.tripod.com
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Mar 24 2004 - 03:16:34 CST
 |
 |