Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: determining bytes written to tape

RE: determining bytes written to tape

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 19 Mar 2003 10:33:48 -0600
Message-Id: <24715.322389@fatcity.com>


Patrice

   Just be sure and do a test restore to make sure Veritas restores the file identically to the original :-0

   There have been problems where systems see "unused" space in Oracle data files and eliminate it to save you some space. Oracle doesn't see the humor ;-)

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] Sent: Wednesday, March 19, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L Subject: OT: determining bytes written to tape

[/begin rant]

We ran into a bit of a puzzle here.

It started innocently enough, with someone asking whether Oracle tablespaces that are largely empty are really being compressed before they are written to tape.

We use Veritas Enterprise NetBackup with a StorageTek tape silo. Our backups are done in parallel to multiple tape drives, and we back up many machines at once so these backups are all multiplexed and interleaved.

After weeks of discussion with the vendors, it is starting to look like the only way to determine the actual number of physical bytes written to tape has to be determined by backing up one tablespace file repeatedly on one tape, until the tape fills up, then infer (guesstimate) how many bytes were written.

The tape drives' hardware can be told to back up files in "native" mode instead of in "compressed" mode, but one cannot ask them to report how many bytes were written in "compressed mode" without the tape hardware "decompressing" the bytes written.

Veritas NetBackup doesn't know how many bytes were written to tape, it can only report how many bytes the original file had. It gets its values from the tape drives.

This took me by surprise, are we the only ones who want to have an exact reading of how many bytes are written to tape?

[/end rant]

Regards,
Pat.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Wed Mar 19 2003 - 10:33:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US