Home -> Usenet -> comp.databases.oracle -> Phantom disk space

Phantom disk space

From: Tim Antler <tantler_at_mdshealth.com>
Date: 1996/11/04
Message-ID: <01bbca96$805cef60$1d23e2c0_at_intd21518.mdshealth.com>#1/1 







        My company recent ran a HUGE job on our Oracle 7.2.2.1 server (running on
a dual-processor AlphaServer 2100A) which updated a large number of columns
in a large number of tables.



        The update died due to a table allocation problem.  Instead of letting it
back out of the rollback segments (it took 15 hours to get to the point of
failure), we decided to kill Oracle and restore the database files from our
last tape backup instead.



        When I was attempting to restore a particular JBOD filesystem, I
discovered that there was not enough free space in the filesystem to do the
restore.  I checked and all files that I was going to restore were there
and accounted for, but there was about 300 Mb more used space than the
files on it occupied.  I deleted all of the files I was attempting to
restore and the filesystem still reported that it was 35% full.



        Has anyone ever encountered this before?  Is it a Digital UNIX quirk or
Oracle.  We are running DU 3.2c. The backup/restore software is Polycenter
Save/Restore that comes with DU.



Thank you.


-- 
Tim Antler
Technical Analyst - Systems
MDS Health Group Limited


Received on Mon Nov 04 1996 - 00:00:00 CET












Original text of this message