to reduce the filesystem sapreorg

[Former Member]

Hi All,

The file system in production system /oracle/SID/sapreorg has reached 95%.kindly let me know how to reduce the file system .

Regards

Ram

[sunny_pahuja2]

Hi,

You can delete the log files from this directory.

Thanks

Sunny

[Former Member]

Hi Sunny,

let me list the files under /oracle/SID/sapreorg and let me know other log files anything further can be deleted

drwxr-xr-x 2 root root 512 Mar 2 2007 old_logs

-rw-r----- 1 orasid sapsys 10485768192 May 9 2010 SID.data14

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data27

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data26

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data25

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data24

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data23

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data20

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data19

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data18

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data17

-rw-r----- 1 orasid sapsys 2147491840 May 9 2010 SID.data16

-rw-r----- 1 orasid sapsys 10485768192 May 9 2010 SID.data15

-rw-r----- 1 orasid sapsys 2147491840 May 10 2010 SID.data22

-rw-r----- 1 orasid sapsys 2147491840 May 10 2010 SID.data21

drwxr-xr-x 2 orasid dba 512 Dec 14 11:50 full_export

drwxr-xr-x 2 orasid sapsys 512 Dec 26 08:50 sehngpmc

-rw-rr 1 orasid sapsys 6020 Dec 26 08:50 sehngpmc.tse

-rw-rr 1 orasid sapsys 3893 Dec 26 08:57 sehngqek.tse

-rw-rr 1 orasid sapsys 3895 Dec 28 14:33 sehnrpnw.tse

-rw-rr 1 orasid sapsys 3895 Dec 29 09:22 sehnvlvs.tse

drwxr-xr-x 2 orasid sapsys 512 Jan 4 16:10 sehpaivl

-rw-rr 1 orasid sapsys 6020 Jan 4 16:10 sehpaivl.tse

drwxr-xr-x 2 orasid sapsys 512 Jan 6 09:08 sehpisxp

-rw-rr 1 orasid sapsys 6020 Jan 6 09:08 sehpisxp.tse

drwxr-xr-x 2 orasid sapsys 512 Jan 10 14:08 sehqdkwf

-rw-rr 1 orasid sapsys 8439 Jan 10 14:08 sehqdkwf.tse

drwxr-xr-x 2 orasid sapsys 512 Jan 18 08:28 sehrppcy

-rw-rr 1 orasid sapsys 6020 Jan 18 08:28 sehrppcy.tse

drwxr-xr-x 2 orasid sapsys 512 Jan 18 08:30 sehrppjq

-rw-rr 1 orasid sapsys 6020 Jan 18 08:31 sehrppjq.tse

-rw-rr 1 orasid sapsys 10951 Jan 23 07:15 sehsnxpy.tse

-rw-rr 1 orasid dba 20505 Jan 23 08:14 strucSID.log

drwxr-xr-x 2 orasid sapsys 512 Jan 23 08:14 sehsocya

-rw-rr 1 orapbw dba 9919 Jan 23 08:20 spaceSID.log

-rw-rr 1 orapbw sapsys 7389 Jan 23 08:20 sehsocya.tse

regards

Ram

[Former Member]

Hi,

I consider that you are on UNIX platform. Please follow the below specified action to narrow down to fix your prob.

sudo su - ora<sid>

cd /oracle/<SID>/sapreorg

pwd (ensure that you are on correct directory i.e sapreorg)

du -sg * (see which directory or file under sapreorg File system occupies more space.

This help you to narrow down to the prob of having any ununsed huge file at the given sapreorg file system. Delete or move that file from the sapreorg File system. You should be strong enough to confirm that which file is needed and which can be moved out.

Best Regards,

Vasanth G

[Former Member]

Hi vasanth;

du -sh old_logs

8K old_logs

du -sh vdbench

256M vdbench

du -sh pbw.data14

9.8G pbw.data14

du -sh pbw.data27

2.0G pbw.data27

du -sh pbw.data17

2.0G pbw.data17

du -sh pbw.data26

2.0G pbw.data26

du -sh pbw.data21

2.0G pbw.data21

du -sh pbw.data22

2.0G pbw.data22

du -sh pbw.data16

2.0G pbw.data16

du -sh full_export

8K full_export

du -sh sehngpmc

32M sehngpmc

du -sh sehngpmc.tse

8K sehngpmc.tse

du -sh sehngqek.tse

8K sehngqek.tse

du -sh sehnrpnw.tse

8K sehnrpnw.tse

du -sh sehnvlvs.tse

8K sehnvlvs.tse

du -sh sehqdkwf.tse

16K sehqdkwf.tse

du -sh sehqdkw

0K sehqdkw

du -sh sehpisxp

32M sehpisxp

du -sh sehpisxp.tse

8K sehpisxp.tse

du -sh sehrppcy

32M sehrppcy

du -sh sehrppcy.tse

8K sehrppcy.tse

du -sh sehrppjq

32M sehrppjq

du -sh sehrppjq.tse

8K sehrppjq.tse

du -sh sehsnxpy.tse

16K sehsnxpy.tse

du -sh strucPBW.log

24K strucPBW.log

du -sh sehsocya

32M sehsocya

du -sh spacePBW.log

16K spacePBW.log

du -sh sehsocya.tse

8K sehsocya.tse

can i delete strucPBW.log and spacePBW.log.And let me know whether .tse files can also be deleted

Regards

Ram

[Former Member]

Hi All,

kindly provide me help on this please

Regards

Ram

[Former Member]

Hi All,

is it good to delete all the pbw.data15 to pbw.data27 as they occupy space of more than 2gb.And let me know what these files are and how data files are coming under this directory

Kindly provide me a help please

Regards

Ram

[JPReyes]

*.dataXX sound like datafiles to me. Now why are they in the wrong file system??? No idea. DO NOT delete them until you have check that!!

Check DB02 and make sure theres no datafiles in the sapreorg directory... if thats the case you can move them using BRTOOLS

Regards

Juan

[former_member218173]

Hi Sunny,

Whether there will be any problem if deleting log files from directory because SAPREORG has reached

100% for the system production.

Regards

Hari