Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 29, 2013 at 05:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2013 at 06:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2013 at 11:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • Nov 29, 2013 at 12:26 PM

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

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

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded