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
Last activity: May 14, 2017, 09:49 AM