一次修改时间导致的ORACLE 实例崩溃

oracle 10.2.0.4

OS redhat  5.3 x64

 

bdump
====
-rw-r----- 1 oracle oinstall     3775 Jun  7 10:48 testdb2_lms1_20121.trc
-rw-r----- 1 oracle oinstall     3775 Jun  7 10:48 testdb2_lms0_20112.trc
-rw-r----- 1 oracle oinstall     1014 Jun  7 10:48 testdb2_diag_20104.trc
-rw-r----- 1 oracle oinstall      784 Jun  7 10:48 testdb2_lgwr_20139.trc
-rw-r----- 1 oracle oinstall     9287 Jun  7 10:48 testdb2_lmon_20108.trc
-rw-r----- 1 oracle oinstall      786 Jun  7 10:48 testdb2_q000_20518.trc
-rw-r--r-- 1 oracle oinstall     6373 Jun  7 11:35 alert_testdb2_20120607113501.log
-rw-r----- 1 oracle oinstall    12360 Jun  7 12:30 testdb2_lmd0_20110.trc
-rw-r----- 1 oracle oinstall        0 Jun  7 12:35 alert_testdb2.log
-rw-r--r-- 1 oracle oinstall        0 Jun  7 12:35 alert_testdb2_20120607123501.log
-rw-r----- 1 oracle oinstall      814 Sep 22  20120607 testdb2_q005_18133.trc
-rw-r----- 1 oracle oinstall      814 Sep 22  20120607 testdb2_q003_21105.trc
-rw-r----- 1 oracle oinstall     1324 Sep 22  20120607 testdb2_pz99_20665.trc
-rw-r----- 1 oracle oinstall      789 Sep 22  20120607 testdb2_pmon_8301.trc
-rw-r----- 1 oracle oinstall     2114 Sep 22  20120607 testdb2_p002_8449.trc
-rw-r----- 1 oracle oinstall     2114 Sep 22  20120607 testdb2_p001_8447.trc
-rw-r----- 1 oracle oinstall     2421 Sep 22  20120607 testdb2_p000_8436.trc
-rw-r----- 1 oracle oinstall      814 Sep 22  20120607 testdb2_o001_31898.trc
-rw-r----- 1 oracle oinstall      808 Sep 22  20120607 testdb2_o000_8378.trc
-rw-r----- 1 oracle oinstall      789 Sep 22  20120607 testdb2_mman_8319.trc
-rw-r----- 1 oracle oinstall    20837 Sep 22  20120607 testdb2_lms1_8315.trc
-rw-r----- 1 oracle oinstall    23362 Sep 22  20120607 testdb2_lms0_8311.trc
-rw-r----- 1 oracle oinstall   376061 Sep 22  20120607 testdb2_lmon_8307.trc
-rw-r----- 1 oracle oinstall  1821694 Sep 22  20120607 testdb2_lmd0_8309.trc
-rw-r----- 1 oracle oinstall  5752998 Sep 22  20120607 testdb2_lgwr_8323.trc
-rw-r----- 1 oracle oinstall     1435 Sep 22  20120607 testdb2_lck0_8346.trc
-rw-r----- 1 oracle oinstall      847 Sep 22  20120607 testdb2_j002_21197.trc
-rw-r----- 1 oracle oinstall      884 Sep 22  20120607 testdb2_j001_27440.trc
-rw-r----- 1 oracle oinstall      839 Sep 22  20120607 testdb2_j000_8952.trc
-rw-r----- 1 oracle oinstall    80682 Sep 22  20120607 testdb2_diag_8303.trc
-rw-r----- 1 oracle oinstall     1481 Sep 22  20120607 testdb2_dbw0_8321.trc
-rw-r----- 1 oracle oinstall    12092 Sep 22  20120607 testdb2_cjq0_8331.trc
-rw-r----- 1 oracle oinstall     1568 Sep 22  20120607 testdb2_arc1_8566.trc

标红的文件其时间字段已经不对了

 

alert
====
Thu Jun  7 09:04:35 2012
Thread 2 advanced to log sequence 23288 (LGWR switch)
  Current log# 4 seq# 23288 mem# 0: +DG1/testdb/onlinelog/group_4.266.706720723
  Current log# 4 seq# 23288 mem# 1: +DG1/testdb/onlinelog/group_42
Thu Jun  7 09:04:36 2012
LOGMINER: End mining logfile: +DG1/testdb/onlinelog/group_3.265.706720721
Thu Jun  7 09:04:38 2012
LOGMINER: Begin mining logfile for session 21 thread 2 sequence 23288, +DG1/testdb/onlinelog/group_4.266.706720723
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_mman_8319.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120MMAN: terminating instance due to error 1513
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_lms0_8311.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_o000_8378.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_lms1_8315.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120krvxerpt: Errors detected in process 30, role preparer.
Tue Sep 22 00:00:00 20120krvxmrs: Leaving by exception: 1513
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_p002_8449.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_lmon_8307.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_lck0_8346.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_smon_8327.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_lgwr_8323.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_q003_21105.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120krvxerpt: Errors detected in process 29, role builder.
Tue Sep 22 00:00:00 20120krvxmrs: Leaving by exception: 1513
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_p001_8447.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_dbw0_8321.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_reco_8329.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120krvxerpt: Errors detected in process 26, role reader.
Tue Sep 22 00:00:00 20120krvxmrs: Leaving by exception: 1513
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_p000_8436.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_o001_31898.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_lmd0_8309.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_j001_27440.trc:
ORA-01513: 操作系统返回无效的当前时间
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_q005_18133.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120Errors in file /u01/app/oracle/admin/testdb/bdump/testdb2_pmon_8301.trc:
ORA-01513: invalid current time returned by operating system
Tue Sep 22 00:00:00 20120LMS0: terminating instance due to error 1513
Tue Sep 22 00:00:00 20120LMS1: terminating instance due to error 1513
Tue Sep 22 00:00:00 20120System state dump is made for local instance
System State dumped to trace file /u01/app/oracle/admin/testdb/bdump/testdb2_diag_8303.trc
Tue Sep 22 00:00:00 20120Termination issued to instance processes. Waiting for the processes to exit
Instance termination failed to kill one or more processes
Tue Sep 22 00:00:00 20120Shutting down instance (abort)
License high water mark = 225
Termination issued to instance processes. Waiting for the processes to exit
Instance termination failed to kill one or more processes
Instance terminated by USER, pid = 10410

 

 

检查历史

history
====
 1584  date -s '201206070922'
 1585  date
 1586  date -s '2012-06-07 09:22'

 

测试发现

[root@node6 ~]#  date -s '201206101337'
Thu Jun 17 00:00:00 CST 65734
[root@node6 ~]#
[root@node6 ~]#
[root@node6 ~]# date
Sat Sep  4 19:31:14 CST 2038

时间设置问题

 

[root@testdb2~]# date --v
date (GNU coreutils) 5.97
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software.  You may redistribute copies of it under the terms of
the GNU General Public License <http://www.gnu.org/licenses/gpl.html>.
There is NO WARRANTY, to the extent permitted by law.

Written by David MacKenzie.