orcale/SID 100% Full

[Former Member]

Dear Team,

I have check all file system  in my development Server

sapdev :/oracle/DEV/saptrace/background#bdf

Filesystem          kbytes    used   avail %used Mounted on

/dev/vg00/lvol3    2097152  432240 1651968   21% /

/dev/vg00/lvol1    1835008  245080 1577592   13% /stand

/dev/vg00/lvol8    17301504 7040112 10182576   41% /var

/dev/vg00/lvol7    12320768 3082168 9166456   25% /usr

/dev/vg00/lvol10   31457280 12610581 17668802   42% /usr/sap/trans

/dev/vg00/lvol11   10485760 5477406 4695510   54% /usr/sap/DEV

/dev/vg00/lvol6    10354688 3559432 6742968   35% /tmp

/dev/vg00/lvol9    10485760 8112338 2229717   78% /sapmnt

/dev/vg00/lvol12   2097152   28273 1940446    1% /oracle

/dev/vg00/lvol29   5242880 4857623  361185   93% /oracle/stage/102_64

/dev/vg00/lvol13   2097152  133178 1841230    7% /oracle/client

/dev/vg00/lvol15   15728640 15728640       0  100% /oracle/DEV  ----------------------->Full

/dev/vg00/lvol22   14548992   20735 13620312    0% /oracle/DEV/sapreorg

/dev/vg00/lvol26   68157440 36730061 29463169   55% /oracle/DEV/sapdata4

/dev/vg00/lvol25   68157440 46867677 19959154   70% /oracle/DEV/sapdata3

/dev/vg00/lvol24   68157440 41135469 25333162   62% /oracle/DEV/sapdata2

/dev/vg00/lvol23   68157440 39986493 26410325   60% /oracle/DEV/sapdata1

/dev/vg00/lvol18   8388608  146099 7727359    2% /oracle/DEV/origlogB

/dev/vg00/lvol17   8388608  146099 7727359    2% /oracle/DEV/origlogA

/dev/vg00/lvol21   41943040 3966779 35602985   10% /oracle/DEV/oraarch

/dev/vg00/lvol20   8388608  121539 7750384    2% /oracle/DEV/mirrlogB

/dev/vg00/lvol19   8388608  121539 7750384    2% /oracle/DEV/mirrlogA

/dev/vg00/lvol30   6291456 4683388 1508201   76% /oracle/DEV/102_64

/dev/vg00/lvol5    12320768 4362272 7896720   36% /opt

/dev/vg00/lvol4    4194304   19016 4142704    0% /home

I have delete core file . I have notice that  alert_DEV.log file  size is  1256112128

sapdev :/oracle/DEV/saptrace/background#ll

total 2561546

-rw-r--r--   1 oradev     dba        1256112128 Dec  6 21:42 alert_DEV.log

-rw-------   1 oradev     dba              0 Feb  8  2008 core

drwxr-x---   2 oradev     dba             96 Jul 20 17:55 core_10116

drwxr-x---   2 oradev     dba             96 Dec  1  2011 core_10707

drwxr-x---   2 oradev     dba             96 Oct 15 01:30 core_11154

drwxr-x---   2 oradev     dba             96 Jan 10  2012 core_11487

drwxr-x---   2 oradev     dba             96 Sep 29  2011 core_11600

drwxr-x---   2 oradev     dba             96 Nov  1  2011 core_1176

drwxr-x---   2 oradev     dba             96 Oct 31 06:54 core_12013

drwxr-x---   2 oradev     dba             96 Apr 16  2012 core_12249

drwxr-x---   2 oradev     dba             96 Oct 20 07:02 core_12664

drwxr-x---   2 oradev     dba             96 Sep  4 16:30 core_12821

drwxr-x---   2 oradev     dba             96 Jan 12  2012 core_12924

drwxr-x---   2 oradev     dba             96 Sep 28 20:30 core_13638

Now can I delete  alert_DEV.log file during SAP start in my this server  or We have to move alert_DEV.log file in some other location.

How we can  reduce  size of    oracle/DEV  100 %

Regards

Sunil

[Former Member]

Hi Sunil,

You can delete your alerl.log while Orcale is running and Orcale will create a new one.

Best practice is to copy the exiting one to a new location and create a new one.

In unix you can mv command to move to a new location. If the aler.log is very big do not use "mv' command to NFS, rather move it to some local file system.

Dipam

[Former Member]

Dear Dipam,

After delete alert_DEV.log file , my file system size /oracle/DEV  is not reducing.

sapdev :/oracle/DEV/saptrace/background#rm alert_DEV.log 

/dev/vg00/lvol12   2097152   28273 1940446    1% /oracle

/dev/vg00/lvol29   5242880 4857623  361185   93% /oracle/stage/102_64

/dev/vg00/lvol13   2097152  133178 1841230    7% /oracle/client

/dev/vg00/lvol15   15728640 15728640       0  100% /oracle/DEV

/dev/vg00/lvol22   14548992   20735 13620312    0% /oracle/DEV/sapreorg

/dev/vg00/lvol26   68157440 36730061 29463169   55% /oracle/DEV/sapdata4

/dev/vg00/lvol25   68157440 46867677 19959154   70% /oracle/DEV/

Now Should I reboot the server Or wha  check some other thing.

Regards

[Former Member]

Hi,

Try to extend the file system /dev/vg00/lvol15.

Are you using HP-UX machine?

[Former Member]

Hi Sunil,

Please find the largest files in dir /oracle/DEV using command "du -k" in UNIX.  and after taking backup you can remove that file.

This is home directory of user ORADEV have made any changes ?

Regards

Ganesh Datt Tiwari

[Former Member]

Hi Sunil,

As mentioned by Ganesh, check which directory occupied more spaces and remove some unwanted stuff. It looks like there is no separate file system for "saptrace", "sapchcek" and "oraarch"; does not matter. Check the situation of these three directory using du -sk * . Also you can delete *.trc file from saptrace directory ( usertrace and background)..

Regards,

Dipam