Tablespace Reorg - Reduced space not reflecting at OS HP-UX

[Former Member]

Hi,

I have Followed the procedure in SAP Note: 646681(Section IV) to

perform a Tablespace Reorg. I have choosed PSAPBTABD & PSAPBTABI for

Reorg and completed Successfuly. The DB Size of 1.6TB was reduced to

1.3 which released the free space of 363GB from the Database. I Could

see the difference in Size at DB02(SAP Level), But it is not reflecting

at OS level(HP-UX) after droping the old Tablespace. Tablespace became

99%. All filesystems shows full when "bdf" executed. Please Advice.

Thanks

Prasad

[Former Member · Accepted solution]

But it is not reflecting at OS level(HP-UX) after droping the old Tablespace. 

This probably means you didn't drop with including datafiles thus the files are still there. Before deleting the files double check the timestamp, all files should have more or less current modification timestamps when the db is running. The leftover files should have the timpstamp from the drop tablespace command. Only delete files you are sure they don't belong to an active tablespace.

Cheers Michael

[Former Member · Accepted solution]

Thanks Micheal ... I used the below command for dropping the old tablespace which did and deleted the empty datafiles also after Reorg

brspace -u / -f tsdrop -t PSAPBTABD

Thanks

Prasad

[Former Member · Accepted solution]

Ok, could you try a df -k /oracle/SID/sapdataX and compare that to a du -k /oracle/SID/sapdataX?

If the difference is the dropped datafiles, then you might need to either wait or bounce the oracle instance (if you can). I have seen the behaviour on HP-UX, it looks like the space is not released until the processes having handles to those files are gone.

Cheers Michael

[Former Member · Accepted solution]

Michael,

I unmounted the Oracle database and mounted again at SQL level fixed the issue. I could see the released free space now at OS level.

Thanks

Prasad

[former_member204746 · Accepted solution]

next time, try to drop tablespaces when SAP is down.

this should release datafiles quicker.