有沒有大神能幫忙看下ORACLE告警日志，是什么問題？怎么解決？
Tue Jan 02 16:07:59 2018
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Tue Jan 02 16:08:04 2018
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
Tue Jan 02 16:08:30 2018
O/S-Error: (OS 1) Incorrect function. !
Tue Jan 02 16:10:19 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_1296.trc:
ORA-00345: redo log write error block 79008 count 1198
ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Tue Jan 02 16:10:19 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_1296.trc:
ORA-00340: IO error processing online log 3 of thread 1
ORA-00345: redo log write error block 79008 count 1198
ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Tue Jan 02 16:11:00 2018
opidrv aborting process M000 ospid (12532) as a result of ORA-449
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9284.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9792.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
LGWR (ospid: 1296): terminating the instance due to error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7108.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_11524.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
Tue Jan 02 16:11:00 2018
Doing block recovery for file 3 block 610
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10104.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j005_6040.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_11100.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_2892.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4900.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j006_7388.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_12488.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j003_8128.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j007_2740.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j002_5528.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_9872.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
O/S-Error: (OS 1) Incorrect function. !
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j004_11588.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:00 2018
opidrv aborting process M001 ospid (11532) as a result of ORA-449
Tue Jan 02 16:11:00 2018
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j001_10836.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_9872.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_9872.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
ORA-00449: background process 'LGWR' unexpectedly terminated with error 340
Tue Jan 02 16:11:19 2018
opiodr aborting process unknown ospid (11824) as a result of ORA-1092
Tue Jan 02 16:11:20 2018
ORA-1092 : opitsk aborting process
Tue Jan 02 16:12:14 2018
Instance terminated by LGWR, pid = 1296
uj5u.com熱心網友回復：
問題挺多啊IO錯誤，讀寫失敗，后臺行程例外。。這是干啥著啊，例外掉電了？
uj5u.com熱心網友回復：
應該是聯機日志檔案（C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG）損壞了，網上找下“Oracle 聯機日志檔案損壞的幾種場景和恢復方法”試試恢復下。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/74947.html
標籤：非技術區
上一篇：幾個.txt檔案中的資料匯入到一個oracle資料表中的方法
下一篇：存盤程序