有關修改作業系統時間導致例項down掉的一個案例

現網一資料庫down掉,在告警日誌中有如下的提示:

Thu Apr 23 13:41:02 1007
Errors in file /oracle/admin/cswap/bdump/cswap_lgwr_19411.trc:
ORA-01513: invalid current time returned by operating system
Thu Apr 23 13:41:02 1007
LGWR: terminating instance due to error 1513
Instance terminated by LGWR, pid = 19411

檔案/oracle/admin/cswap/bdump/cswap_lgwr_19411.trc中的內容如下:

/oracle/admin/cswap/bdump/cswap_lgwr_19411.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /oracle/product/9.2.0.4
System name: Linux
Node name: cs_db01
Release: 2.6.9-42.ELlargesmp
Version: #1 SMP Wed Jul 12 23:46:39 EDT 2006
Machine: x86_64
Instance name: cswap
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 19411, image: (LGWR)

*** 1007-04-23 13:41:02.675
*** SESSION ID:(4.1) 1007-04-23 13:41:02.674
error 1513 detected in background process
ORA-01513: invalid current time returned by operating system

經諮詢原來是一哥們在資料庫run狀態時將作業系統的時間修改導致的.

教訓:資料庫主機的作業系統時間不可隨便改,只有在資料庫正常關閉後才可進行.最好的做法是在安裝資料庫軟體時就調整好時間.

[@more@]