数据库运行过程中自动关闭

meilee

Windows Server 2003 Version V5.2 Service Pack 2
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
数据库运行过程中自动关闭，
>conn sys/sys as sysdba; 提示已经连接到空闲例程
>startup
之后恢复正常使用，之后约每一个半小时由自动关闭

附件为alter_orac和trace文件，请刘老大和各位前辈帮忙看一下

Maclean Liu(刘相兵

Dump continued from file: d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smon_1920.trc
ORA-00600: internal error code, arguments: [13013], [5001], [259], [8462525], [3], [8462525], [17], []

========= Dump for incident 7227 (ORA 600 [13013]) ========

*** 2013-05-27 07:52:36.343
----- Current SQL Statement for this session (sql_id=dma0vxbwh325p) -----
update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4,  scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn =  (select min(scn) from smon_scn_time)


update smon_scn_time 时遇到 ORA-00600  [13013], [5001], [259], [8462525], [3], [8462525], [17], []

Maclean Liu(刘相兵

ERROR:
Format: ORA-600 [13013] [a] [b] [c] [d] [e] [f]

This format relates to Oracle Server 8.0.3 and above
Arg [a] Passcount
Arg [b] Data Object ID
Arg [c] Tablespace DEcimal Relative DBA (RDBA) of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Decimal RDBA of block being updated (should be same as [c])
Arg [f] Code

Maclean Liu(刘相兵

FYI

http://www.askmaclean.com/archiv ... B8%80%E4%BE%8B.html

Maclean Liu(刘相兵

[oracle@vrh8 ~]$ grep "seg/obj" orcl_smon_1920_i7227.trc
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2296c4  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2298f2  itc: 1  flg: E  typ: 2 - INDEX
seg/obj: 0x103  csc: 0x00.5b203436  itc: 2  flg: E  typ: 1 - DATA
seg/obj: 0x107  csc: 0x00.5b2298f2  itc: 1  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2296c4  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b1a7d16  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b222888  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX
seg/obj: 0x107  csc: 0x00.5b2432a1  itc: 2  flg: E  typ: 2 - INDEX

seg/obj: 0x103 ==> 259 Arg [b] Data Object ID

这个是表 确认下 是不是 SMON_SCN_TIME

meilee

Maclean Liu(刘相兵 发表于 2013-5-27 17:28
[oracle@vrh8 ~]$ grep "seg/obj" orcl_smon_1920_i7227.trc
seg/obj: 0x107  csc: 0x00.5b2432a1  itc:  ...

我很纳闷，orcl_smon_1920_i7227.trc 这个文件不就是update smon_scn_time 时的trace文件么，为什么刘老大要我确认呢？

meilee

Maclean Liu(刘相兵 发表于 2013-5-27 17:28
[oracle@vrh8 ~]$ grep "seg/obj" orcl_smon_1920_i7227.trc
seg/obj: 0x107  csc: 0x00.5b2432a1  itc:  ...

是我理解错了，object_id：259  对应的是sys.smon_scn_to_time_aux cluster

Maclean Liu(刘相兵

可以通过设置诊断事件event=’12500 trace name context forever, level 10′来禁止SMON更新SMON_SCN_TIME基表(Setting the 12500 event at system level should stop SMON from updating the SMON_SCN_TIME table.):
SQL>  alter system set events '12500 trace name context forever, level 10';

System altered.

meilee

Maclean Liu(刘相兵 发表于 2013-5-31 14:48
可以通过设置诊断事件event=’12500 trace name context forever, level 10′来禁止SMON更新SMON_SCN_TIME ...

http://www.xifenfei.com/2754.html　我根据这个做了处理，处理后数据库不会自动关闭了，但报其他600错误,相关日志见附件，客户的服务器最近老出现断电情况，我不确定是不是这个引起这些错误的发生。