Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question