FILE_SYSTEM_FULL

[mohsin_m3]

Hello All,

Dbcheck finishe with below warnings

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/SID/sapdata16, value: 99.23% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/SID/sapdata6, value: 99.01% (> 99%)

But no datafile added or extend from decemebr than how immediately this file system full?

plaixlpc065:oraap5 6> ls -altr

total 16

drwxr-xr-x 2 root system 256 Dec 05 2007 lost+found

drwxr-xr-x 2 orasid dba 256 Jan 16 2008 btabd_19

drwxr-xr-x 2 orasid dba 256 Jan 16 2008 btabi_10

drwxr-xr-x 2 orasid dba 256 Jan 16 2008 odsd_30

drwxr-xr-x 2 orasid dba 256 Jan 16 2008 odsd_29

drwxr-xr-x 2 orasid dba 256 Jan 16 2008 odsd_27

drwxr-xr-x 2 oraasid dba 256 Jan 16 2008 odsi_8

drwxr-xr-x 2 orsid dba 256 Dec 13 2008 temp2_3

drwxr-xr-x 49 orasid dba 4096 Jan 27 12:15 ..

drwxr-xr-x 10 orasid dba 4096 Mar 06 11:19 .

plaixlpc065:oraap5 7> pwd

/oracle/SID/sapdata16

Regards

Mohsin M

[Former Member · Accepted solution]

Hello Mohsin,

It is possible that alert is activated/changed recently. Please check in DB17 if that's the case.

Regards,

Sudhir

[uwe_theisinger · Accepted solution]

Hi,

there is a temp file in the current Filesystem.

drwxr-xr-x 2 orsid dba 256 Dec 13 2008 temp2_3

On Unix the file could be created as "Sparse File",

see SAP Note Note 548221 - Temporary Files are created as sparse files.

When you check the space on operating system level you see that commands like 'du' and 'df' do not show a significant change of allocated resp. free space on the one hand. On the other hand a 'ls -l <path and file>' shows a filesize as specified in the 'create' or 'alter' command.

It is possible that a file created with 2000M initially allocates only 100K on disk,

regards

Uwe

[mohsin_m3]

DB17 check value has been increased.

[former_member524429]

Hi,

->> First , Check the Auto Extend Flag for the data files located at the complained destination. Also check the Maxlimit for the Data-file specified.

If the Space is the issue, you can extend the File System to have additional space. You can move the Data-files from one location to another free location using BR*Tools (BRSPACE).

You can Disable the Auto Extend settings for the Data Files and do the manual File Management for your Database Files.

-->> You can disable/modify the Check entry for FILE_SYSTEM_FULL check condition using DB17 T-code.

Also refer the description of FILE_SYSTEM_FULL condition and required settings info. in SAP Note 435290 along with SAP Note 483856.

Regards,

Bhavik G. Shroff

[sunny_pahuja2]

Hi,

When you have added data file in this file system with auto extend on option, then those files might be getting extended that's the reason that your this data file is getting full.

Thanks

Sunny

[mohsin_m3]

Hi,

then why date wise not updated in file system

suppose if datafile alterd due to autoextend on ..it must be updated in filestsem datewise...

from December no datafile updated...and file system error coming since last few days

Regards

Mohsin M