ORA-30036: unable to extend segment by 8 in undo tablespace

[Former Member]

Hello

in sm21 of an BI7.3 system UNIX/Oracle11.2  I have following error

Database error 30036 at EXE

> ORA-30036: unable to extend segment by 8 in undo tablespace

> 'PSAPUNDO'

Database error 30036

How to deal with this issue as with brtools I can not extend PSAPUNDO. Namely I have:

BR0678I The action will be skipped...

BR0259I Program execution will be continued...

BR0370I Directory /oracle/BWD/sapreorg/semqirfl created

BR0280I BRSPACE time stamp: 2013-11-29 06.38.15

BR0301E SQL error -206 at location BrCtlBackup-1, SQL
statement:

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO
'/oracle/BWD/sapreorg/semqirfl/cntrlBWD.old''

ORA-00206: error in writing (block 8256, # blocks 64) of
control file

ORA-00202: control file: '/oracle/BWD/sapreorg/semqirfl/cntrlBWD.old'

ORA-27072: File I/O error

Additional information: 4

Additional information: 8256

Additional information: 123904

BR0320E Copying of control file to /oracle/BWD/sapreorg/semqirfl/cntrlBWD.old
failed

BR0280I BRSPACE time stamp: 2013-11-29 06.38.15

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

BR1008I End of BRSPACE processing: semqirfl.tse 2013-11-29
06.38.15

BR0280I BRSPACE time stamp: 2013-11-29 06.38.15

BR1007I BRSPACE terminated with errors

###############################################################################

BR0292I Execution of BRSPACE finished with return code 5

BR0280I BRTOOLS time stamp: 2013-11-29 06.38.15

BR0668I Warnings or errors occurred - you can continue to
ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back,
's[top]' to abort:

thank you in advance

Jan

[Reagan]

Could you provide the complete log of the BRSPACE operation please ?

Also provide the space information of all the sapdata file systems.

Regards

RB

[Reagan]

Cleanup the old log files and control files ending with .old from the /oracle/BWD/sapreorg file system.

If there isn't any then extend the file system and see if that helps.

Regards

RB

[Former Member]

Hello

Nope /oracle/BWD/sapreorg is not full. There should be another problem

regards

Jan

[ashish_vikas]

Can you please provide output of :

df -k | grep BWD

best regards

ashish

[ashish_vikas]

b'cos error is :

BR0320E Copying of control file to /oracle/BWD/sapreorg/semqirfl/cntrlBWD.old
failed

I hope you are running brtools with orasid.

[ashish_vikas]

your filesystem "/oracle/BWD/sapreorg" looks to be full.

in "/oracle/BWD/sapreorg", brspace keeps a backup of control files, so if you have multiple controlfiles backup, you can move/delete older ones and try to extend this again.

best regards

ashish

[former_member206552]

Hi Jan,

this seems like an filesystem issue,

ORA-00202: control file: '/oracle/BWD/sapreorg/semqirfl/cntrlBWD.old'

ORA-27072: File I/O error

http://ora-00206.ora-code.com/

please check it by running "df -h" and see if any errors was returned if no errors was return tne ask SERVER OPERATIONS to check the system.

Best Regards

Marius