Forum OpenACS Q&A: DIsk space question

Collapse
Posted by Allan Regenbaum on
Im working on 2 servers (ACS + Oracle) which are running out of space
on the /ora8 volume.  I go through the steps of moving one of my
older, unused datafiles (olddb.dbf approx 1G) to a different volume
which has a bunch of free space. When I go back check disk space
on /ora8 using df -k I see that the disk space that had been occupied
by the olddb.dbf file has not been released and available space has
not changed at all..

Any help is appreciated ...

I ran sync to flush changes to disk, but that has not had any effect.
Bouncing the server also has had no effect ...

Ive spoken to people who have seen this problem, but nobody has been
able to suggest a solution.

Collapse
Posted by Cynthia Kiser on
Double check that the old data file is not in use by Oracle (think that is 'select name from v$data_file;' - your old file should not appear!). If it doesn't, then you can use 'rm' to remove the file.
Collapse
Posted by Allan Regenbaum on
Cynthia ,, thanks for the response ...
When I originally moved olddb.dbf , after confirming that the move was ok, I did delete the original copy of the file.... df -k shows that no space has been released on /ora8 as a result of that delete.

SQL> select name from v$datafile;

/ora8/m01/app/oracle/oradata/ora8/system01.dbf

/ora8/m01/app/oracle/oradata/ora8/tools01.dbf

/ora8/m01/app/oracle/oradata/ora8/rbs01.dbf

/ora8/m01/app/oracle/oradata/ora8/temp01.dbf

/ora8/m01/app/oracle/oradata/ora8/users01.dbf

/ora8/m01/app/oracle/oradata/ora8/indx01.dbf

/ora8/m01/app/oracle/oradata/ora8/drsys01.dbf

/ora8/m02/oradata/ora8/msds.dbf

/web/dp32/tmpdata/dp32.dbf << this used to be on /ora8

/ora8/m02/oradata/ora8/monitor.dbf

/ora8/m02/oradata/ora8/dp1dev01.dbf

and

[nsadmin@digitalp1 aol]$ df -k

Filesystem          1k-blocks      Used Available Use% Mounted on

/dev/sda5              5044156  4767468    20456 100% /ora8  <<<<

/dev/sda6              5044156  3479160  1308764  73% /web

Collapse
Posted by mark dalrymple on
Is your database still running?  If so, Oracle may still have that
file open.  Unix doesn't reclaim disk space until all folks who
have the file open actually close it.  There's a handy utility called
'lsof' (ls open files) that'll show you what files are open, and
more importantly *who* has the open so you can track them
down and unleash righteous wrath.