Solved

Oracle Space Issue | AIX

Posted on 2013-12-20
10
530 Views
Last Modified: 2014-01-25
Experts -

I do see space mismatch as below. What happens when the mount /dwdata reaches 100%. But I still have enough space at the DB level.  This is a PROD I just cannot bounce the DB.

We dropped a tablepace worth of 1TB, which is not reflecting at the OS level commands.

$ df -g /dwdmdata
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/fslv03     6000.00    236.65   97%      609     1% /dwdata


$ cd /dwdata
$ du -gs .
5762.17 .

Real Used at DB level

SQL> select sum(bytes)/1024/1024/1024 GB from dba_data_Files where FILE_NAME like '/dwdata%';

        GB
----------
4612.54259


thanks,
sve.
0
Comment
Question by:sventhan
10 Comments
 
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 39732620
Are Temp files in same location?
0
 
LVL 18

Author Comment

by:sventhan
ID: 39732692
No. They're in a different location.
0
 
LVL 29

Assisted Solution

by:MikeOM_DBA
MikeOM_DBA earned 334 total points
ID: 39732713
We dropped a tablepace worth of 1TB, which is . . .
Did you do it "INCLUDING CONTENTS AND DATAFILES"? if not, remember to also remove the files.
;)
0
 
LVL 18

Author Comment

by:sventhan
ID: 39732732
When I dropped the tablespace was empty no objects were associated with it. But I did not use the "including" clause.

Will that be an issue?

If we bounce the DB, will df/du reflect the correct numbers?
0
 
LVL 29

Assisted Solution

by:MikeOM_DBA
MikeOM_DBA earned 334 total points
ID: 39732739
You may need to use OS command to remove the files related to the dropped tablespace.
And if "df" command does not reflect the change, then just close and open the database.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 18

Author Comment

by:sventhan
ID: 39732754
when drop the tablespace with "drop tablespace tablespacename" command, the associated datafiles will not be dropped automatically. Is this true?

Thanks for the help.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39732762
True, datafiles only removed with the "DROP TABLESPACE ... INCLUDE...DATAFILES" otherwise you need to remove the files using the "rm {file name}" OS command.
0
 
LVL 34

Assisted Solution

by:johnsone
johnsone earned 166 total points
ID: 39732779
Once you remove the files at the OS level, then if the space is still not showing up in df, then run this:

sync ; sync ; sync

That may need to be run as root, but you can try as oracle.  That syncs the file system headers and the space should show up at that point.  You should not need to bounce the database.
0
 
LVL 18

Accepted Solution

by:
sventhan earned 0 total points
ID: 39732814
Thanks Virdi, Mike and John. I'll try this tonight
0
 
LVL 18

Author Closing Comment

by:sventhan
ID: 39808400
Thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now