SQL error 376: 'ORA-00376: file 12 cannot be read at this time

[Former Member]

While installing Appl Patch set SAPKH70010- SAPKH70013 I received followingerror ,

SQL_fehler in der Datenbank beim Zugriff auf eine

Following is output of the dev_w0 logfile.

C SELECT TLINE, SEQNO FROM SNAPT WHERE LANGU = :A0 AND ERRID = :A1 AND TTYPE = :A2 ORDER BY SEQNO;

B ***LOG BY2=> sql error 376 performing FET dbds#1 @ 592 dbds 0592

B ***LOG BY0=> ORA-00376: file 12 cannot be read at this time

ORA-01110: data file 12: '/oracle/RTQ/sapdata2/sr3_9/sr3.data9' dbds#1 @ 592 dbds 0592

C OCI-call failed with -1=OCI_ERROR

C SQL error 376: 'ORA-00376: file 12 cannot be read at this time

C ORA-01110: data file 12: '/oracle/RTQ/sapdata2/sr3_9/sr3.data9''

C *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0

http://dbsloci.c 12861

C *** ERROR => ORA-376 occurred when executing SQL stmt (parse error offset=0)

http://dbsloci.c 12880

C sc_p=0x106d644c8,no=227,idc_p=(nil),con=0,act=1,slen=95,smax=256,#vars=3,stmt=0x108563c80,table=SNAPT

C SELECT TLINE, SEQNO FROM SNAPT WHERE LANGU = :A0 AND ERRID = :A1 AND TTYPE = :A2 ORDER BY SEQNO;

C sc_p=0x106d644c8,no=227,idc_p=(nil),con=0,act=1,slen=95,smax=256,#vars=3,stmt=0x108563c80,table=SNAPT

C prep=0,lit=0,nsql=1,lobret=0,#exec=1,dbcnt=0,upsh_p=(nil),ocistmth_p=0x1085649b0

C IN : cols=3,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=42,vmax=32,bound=1,iobuf_p=0x1070cf7d0,vda_p=0x1074f664

0

C lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0

C OUT: cols=2,rmax=208,xcnt=208,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=152,vmax=32,bound=1,iobuf_p=0x1070e9f50,vda_p=0x108

565000

According this i checked file

ORA-01110: data file 12: '/oracle/RTQ/sapdata2/sr3_9/sr3.data9''

This file is in RECOVER mode.

my SAP application ECC6.9 is running.

Oracle is also running.

I do not have any oracle backup

For any transaction the system is giving following error,

"SQL_fehler in der Datenbank beim Zugriff auf eine"

Please advice.

[Former Member]

Hi PushpaMitra,

Check below note.

Note 328785 - ORA-00376: File cannot be read at this time

Regards

Ashok

[former_member185954]

Hello,

Well you need to RECOVER that file, i hope you have Log backups and Online Redo logs enabled.

Regards,

Siddhesh