Brspace command for Oracle on SAP system

[Former Member]

Hi all!

I need to perform a complete "reorg" of my sap BW 7 system (NW2004s).

I check the sap note 646681 but I din't find anything for a complete database reorganization.

I try to execute the following command:

BRSPACE -F TBREORG -T SAPSR3DB

after that I receive the following error message:

ORA-01116: error in opening database file 5

ORA-01110: data file 5: '/oracle/EPT/sapdata4/sr3db_2/sr3db.data2'

ORA-27092: size of file exceeds file size limit of the process

....

BR0280I BRSPACE time stamp: 2010-07-06 18.06.17

BR0815I Number of indexes in schema of owner SAPSR3DB: 957

BR1107E Table(s) 'SAPSR3DB' not found

BR0182E Checking parameter/option '-t|reorg_table' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

Someone can help me?

Thanks in advance!

[former_member204746 · Accepted solution]

with the reorg method from SAP note 646681, you can reorg by table, by index or even by tablespace. IT DOES NOT handle a full database reorg.

re-read that note again, make some tests on a sandbox before attempting this on a productive environment.

do not take that note lightly, i small mistake could lead to data loss. make a good backup before attempting a reorg.

[markus_doehr2]

> ORA-01116: error in opening database file 5

> ORA-01110: data file 5: '/oracle/EPT/sapdata4/sr3db_2/sr3db.data2'

> ORA-27092: size of file exceeds file size limit of the process

What operating system are you using?

What are the shell limits of user ora<sid>?

Markus

[Former Member]

The error you are getting is unrelated to reorg. My guess is, you will get this error if you attempt to backup the datafile using the same id that runs the reorg. You need to fix that first. check the ulimit of sidadm and orasid and the ownership of the datafile in question. I am guessing someone added a datafile very close to 32 gb size. Please update the result of these and we can debug further.