Sample Header Ad - 728x90

What is preventing ORA-00376 errors appearing in the alert log?

4 votes
1 answer
1109 views
An overnight hard drive failure had various side-effects, including leaving a single datafile needing recovery: SQL> select count(*) from v$datafile where status='RECOVER'; COUNT(*) ---------- 1 Everything is now back to normal but one mystery remains: before recovery, the client application logged an ORA-00376 to a logging table when a batch job tried to access a segment in the datafile. However this error did not appear in the alert log, how can this happen? At the time of the ORA-00376 error, the following did appear in the alert log: Errors in file /app/oracle/admin/live33/bdump/live33_j002_938224.trc: ORA-12012: error on auto execute of job 24760001 ORA-20001: Error during batch run ORA-06512: at "*******.***_*****", line 266 ORA-06512: at "*******.***_***_***_*****", line 355 ORA-06512: at line 1 And at the time of the original issue: KCF: write/open error block=0x2fb23 online=1 file=177 /data/ora9i/live/db3b/nsbme.dbf error=27072 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 195363' Automatic datafile offline due to write error on file 177: /data/ora9i/live/db3b/nsbme.dbf
Asked by Jack Douglas (40537 rep)
Aug 18, 2016, 08:09 AM
Last activity: May 14, 2017, 09:49 AM