Skip to Content
avatar image
Former Member

ORA-01552: cannot use system rollback segment

Hello,

I get the following erroru201D SQL error 1552 occurred when accessing program SAPu201D

When I try to logon to SAP System:

And from alert_crp.log I can see:

Sun Aug 24 08:33:33 2008

KCF: write/open error block=0xfa5 online=1

file=2 G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1

error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.

O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'

Automatic datafile offline due to write error on

file 2: G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1

Sun Aug 24 08:33:33 2008

Errors in file g:\oracle\crp\saptrace\background\crp_smon_1672.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: 'G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1'

And From crp_smon_2068.trc I can see:

SMON: following errors trapped and ignored:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: 'G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1'

Furthermore from database level I can see datafile1 itu2019s on recovery status and I already tried to bring it on online but I canu2019t as mention below:

SQL> SELECT FILE#, STATUS, NAME FROM V$DATAFILE;

FILE# STATUS

-


-


NAME

-


1 SYSTEM

G:\ORACLE\CRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

2 RECOVER

G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: 'G:\ORACLE\CRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> alter database datafile 1 online;

Database altered.

Please advice me.

Regards,

Ahmed

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 14, 2008 at 11:07 AM

    Hello Ahmed,

    in the concept you did the right actions, but you have to recover the datafile 2 not the datafile 1.

    > 2 RECOVER G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1

    > SQL> recover datafile 2;

    > SQL> alter database datafile 2 online;

    But this is only the action to "repair" the situation .. the problem is the error before

    > error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.

    Are you using VMware and Legato Filesystem Sync Driver or any Backup Software like Backup Exec?

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2008 at 05:07 AM

    Dear Stefan,

    First let me thank you for your interest and help,

    And I would like to tell you that the problem was resolved by change the command, which you said

    Regarding Vmware yes we already used and for Backup we used VERITAS but itu2019s still in processing to installing, once again Iu2019m very thankful for you.

    Regards,

    Ahmed

    Add comment
    10|10000 characters needed characters exceeded