现网一数据库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: oracle@cs_db01 (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@]

ITPub博客

有关修改操作系统时间导致实例down掉的一个案例

最新文章