Hot Backups -- to Disk OR to tape direct

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 24 Mar 2004 17:10:10 +0800 (SGT)

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: