修改系统时间引起，ora-00600错误

仔细查看下你的alert.log日志。。

调回应该会报错的.
scn变大了,对应的时间反而变小了.oracle会高糊涂的.
select timestamp_to_scn(systimestamp) from dual;
时间和scn是有对应关系的.

理论上应该不会影响数据库的，只会对你应用会产生影响。
在windows系统前后修改系统时间，数据库是正常。
至于aix，没有对应操作系统环境，也无法验证是否真的不行的。
楼主修改系统时间前是否将数据库的完全关闭？！

能否把你的alert log 贴出来？

参考：
Oracle DB 服务器系统时间修改问题与 SCN 关系的深入研究
http://blog.csdn.net/tianlesoftware/archive/2011/01/25/6163859.aspx

IBM AIX RISC System/6000 Error: 5: I/O error
Sun Jan  9 21:03:40 2011
Thread 1 advanced to log sequence 22530
  Current log# 2 seq# 22530 mem# 0: /oracle/app/oradata/zgfxpt/redo02.log
Mon Jan 10 11:00:02 2011
Thread 1 advanced to log sequence 22531
  Current log# 3 seq# 22531 mem# 0: /oracle/app/oradata/zgfxpt/redo03.log
Fri Dec 10 13:26:49 2010
Thread 1 advanced to log sequence 22532
  Current log# 1 seq# 22532 mem# 0: /oracle/app/oradata/zgfxpt/redo01.log
Fri Dec 10 13:50:31 2010
Thread 1 advanced to log sequence 22533
  Current log# 2 seq# 22533 mem# 0: /oracle/app/oradata/zgfxpt/redo02.log
Wed Nov 10 15:47:00 2010
kccrsz: expanded controlfile section 9 from 7260 to 14520 records
  requested to grow by 7260 record(s); added 32 block(s) of records
Thread 1 advanced to log sequence 22534
  Current log# 3 seq# 22534 mem# 0: /oracle/app/oradata/zgfxpt/redo03.log
Sun Oct 10 16:07:22 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1134776.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064171932], [], [], [], [], []
Sun Oct 10 16:07:39 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1147028.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064171937], [], [], [], [], []
Sun Oct 10 16:07:47 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1118316.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064172003], [], [], [], [], []
Sun Oct 10 17:02:18 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1134676.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182057], [], [], [], [], []
Sun Oct 10 17:02:22 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1151166.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182058], [], [], [], [], []
Sun Oct 10 17:02:26 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1118322.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182059], [], [], [], [], []
Sun Oct 10 17:05:52 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1151180.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182569], [], [], [], [], []
Sun Oct 10 17:06:30 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1118330.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182645], [], [], [], [], []
Sun Oct 10 17:06:35 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1151186.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182646], [], [], [], [], []
Sun Oct 10 17:08:39 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1134690.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182937], [], [], [], [], []
Sun Oct 10 17:08:42 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1147110.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064182939], [], [], [], [], []
Sun Oct 10 17:09:12 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1118346.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064183011], [], [], [], [], []
Sun Oct 10 17:13:02 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1151196.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064183627], [], [], [], [], []
Sun Oct 10 17:13:35 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1147114.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064183705], [], [], [], [], []
Sun Oct 10 17:14:33 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1020158.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064183851], [], [], [], [], []
Sun Oct 10 17:15:04 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1151204.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064183926], [], [], [], [], []
Sun Oct 10 17:18:12 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_471122.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064184369], [], [], [], [], []
Sun Oct 10 17:18:36 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1118366.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064184440], [], [], [], [], []
Sun Oct 10 17:20:58 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1105934.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064184802], [], [], [], [], []
Sun Oct 10 17:23:53 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_471142.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064185246], [], [], [], [], []
Sun Oct 10 17:27:34 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1077362.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064185760], [], [], [], [], []
Sun Oct 10 17:28:33 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1151230.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064185906], [], [], [], [], []
Sun Oct 10 17:30:08 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1134710.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064186125], [], [], [], [], []
Sun Oct 10 17:31:42 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_471160.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064186346], [], [], [], [], []
Mon Oct 11 06:45:56 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1019944.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064298553], [], [], [], [], []
Mon Oct 11 08:34:32 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1020036.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064313926], [], [], [], [], []
Mon Oct 11 08:35:18 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_1150980.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064314004], [], [], [], [], []
Mon Oct 11 08:35:28 2010
Errors in file /oracle/app/admin/zgfxpt/udump/zgfxpt_ora_471146.trc:
ORA-00600: internal error code, arguments: [2252], [2796], [1064314007], [], [], [], [], []
Tue Jan 11 08:57:48 2011
Starting ORACLE instance (normal)
Tue Jan 11 08:58:07 2011
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water  = 115
All dispatchers and shared servers shutdown
Tue Jan 11 08:58:11 2011
ALTER DATABASE CLOSE NORMAL
Tue Jan 11 08:58:11 2011
SMON: disabling tx recovery
Tue Jan 11 09:02:52 2011
CLOSE: Error 604 during database close
Tue Jan 11 09:02:52 2011
SMON: enabling tx recovery
Tue Jan 11 09:02:52 2011
ORA-604 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Jan 11 09:54:41 2011
Starting ORACLE instance (normal)
Tue Jan 11 09:54:55 2011
Shutting down instance (abort)
License high water  = 115
Instance terminated by USER, pid = 1101862
Tue Jan 11 09:55:18 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
  processes                = 3000
  timed_statistics         = TRUE
  shared_pool_size         = 2097152000
  sga_max_size             = 6595518568
  large_pool_size          = 16777216
  java_pool_size           = 117440512
  control_files            = /oracle/app/oradata/zgfxpt/control01.ctl, /oracle/app/oradata/zgfxpt/control02.ctl, /oracle/app/oradata/zgfxpt/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 4194304000
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = zgfxpt
  dispatchers              = (PROTOCOL=TCP) (SERVICE=zgfxptXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/app/admin/zgfxpt/bdump
  user_dump_dest           = /oracle/app/admin/zgfxpt/udump
  core_dump_dest           = /oracle/app/admin/zgfxpt/cdump
  sort_area_size           = 524288
  db_name                  = zgfxpt
  open_cursors             = 5000
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 838860800
  aq_tm_processes          = 1
PMON started with pid=2, OS id=331946
DBW0 started with pid=3, OS id=319692
LGWR started with pid=4, OS id=303278
CKPT started with pid=5, OS id=299162
SMON started with pid=6, OS id=274608
RECO started with pid=7, OS id=307396
CJQ0 started with pid=8, OS id=1118398
QMN0 started with pid=9, OS id=336038

Tue Jan 11 09:55:20 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jan 11 09:55:20 2011
ALTER DATABASE   MOUNT
Tue Jan 11 09:55:24 2011
Successful mount of redo thread 1, with mount id 3837778312
Tue Jan 11 09:55:24 2011
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue Jan 11 09:55:24 2011
ALTER DATABASE OPEN
Tue Jan 11 09:55:24 2011
Beginning crash recovery of 1 threads
Tue Jan 11 09:55:24 2011
Started redo scan
Tue Jan 11 09:55:24 2011
Completed redo scan
9 redo blocks read, 8 data blocks need recovery
Tue Jan 11 09:55:24 2011
Started recovery at
Thread 1: logseq 22534, block 167803, scn 0.0
Tue Jan 11 09:55:24 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 22534 Reading mem 0
  Mem# 0 errs 0: /oracle/app/oradata/zgfxpt/redo03.log
Tue Jan 11 09:55:24 2011
Completed redo application
Tue Jan 11 09:55:25 2011
Ended recovery at
Thread 1: logseq 22534, block 167812, scn 2796.1064338612
8 data blocks read, 8 data blocks written, 9 redo blocks read
Crash recovery completed successfully
Tue Jan 11 09:55:25 2011
Thread 1 advanced to log sequence 22535
Thread 1 opened at log sequence 22535
  Current log# 1 seq# 22535 mem# 0: /oracle/app/oradata/zgfxpt/redo01.log
Successful open of redo thread 1
Tue Jan 11 09:55:25 2011
SMON: enabling cache recovery
Tue Jan 11 09:55:25 2011
Successfully onlined Undo Tablespace 1.
Tue Jan 11 09:55:25 2011
SMON: enabling tx recovery
Tue Jan 11 09:55:25 2011

你的oracle是什么时候安装的，或者什么时候修复过

2009年底装的oracle，最近一次修改时间是最近。

调试易

修改系统时间引起，ora-00600错误

解决方案 »