11.2.0.3 資料庫 ORA-00600 [4:kgstmLdiToEpochTs]

gaopengtttt發表於2015-06-25
報錯如下:
Wed Jun 24 23:10:07 2015
Archived Log entry 8345 added for thread 1 sequence 8345 ID 0x2d60d16c dest 1:
Wed Aug 25 05:17:58 1976
Errors in file /home/oracle/product/diag/rdbms/sndbp/sndb/trace/sndb_mmon_33405.trc  (incident=50137):
ORA-00600: internal error code, arguments: [4:kgstmLdiToEpochTs], [1], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/oracle/product/diag/rdbms/sndbp/sndb/incident/incdir_50137/sndb_mmon_33405_i50137.trc
Wed Aug 25 05:17:58 1976
Errors in file /home/oracle/product/diag/rdbms/sndbp/sndb/trace/sndb_mman_4935.trc:
ORA-01513: invalid current time returned by operating system
MMAN (ospid: 4935): terminating the instance due to error 1513
Wed Aug 25 05:17:58 1976
opiodr aborting process unknown ospid (28754) as a result of ORA-1092
Wed Aug 25 05:17:58 1976
opiodr aborting process unknown ospid (23140) as a result of ORA-1092
Wed Aug 25 05:17:58 1976
ORA-1092 : opitsk aborting process
Wed Aug 25 05:17:58 1976
System state dump requested by (instance=1, osid=4935 (MMAN)), summary=[abnormal instance termination].
System State dumped to trace file /home/oracle/product/diag/rdbms/sndbp/sndb/trace/sndb_diag_4929.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Aug 25 05:18:08 1976
Instance terminated by MMAN, pid = 4935
Thu Jun 25 10:14:47 2015

可以看到時間有一個大量的向回改的過程,日誌顯示為1976年,報錯MOS解釋如下:

CHANGES

In the scenario where this problem happened there was a power outage and somehow the operating system clock got misconfigured.

CAUSE

The operating system date and time changed.

SOLUTION

Correct the operating system date and time and re-start the instance.

所以向回改時間需要注意,儘量關閉資料庫,同時等到當前時間超過原有時間後啟動資料庫

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7728585/viewspace-1711623/,如需轉載,請註明出處,否則將追究法律責任。

相關文章