报错如下:
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解释如下:
所以向回改时间需要注意,尽量关闭数据库,同时等到当前时间超过原有时间后启动数据库
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.所以向回改时间需要注意,尽量关闭数据库,同时等到当前时间超过原有时间后启动数据库