数据库宕机，在线急救

ALLSTARS_ORACLE

数据库实例突然宕掉，然后startup mount
SQL> startup  
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2085320 bytes
Variable Size            1275072056 bytes
Database Buffers          855638016 bytes
Redo Buffers               14688256 bytes
Database mounted.
一直不会动

看alert_sid.log
Sun Oct  5 17:23:24 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p011_7695.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Starting background process QMNC
QMNC started with pid=32, OS id=7705
Sun Oct  5 17:29:22 2008
Restarting dead background process QMNC
QMNC started with pid=32, OS id=7739


Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:36 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:37 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [4519], [6], [21072487], [204], [], [], [], []
Sun Oct  5 16:17:38 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928052], [3866], [74217479], [46203647], [], []
Sun Oct  5 16:17:40 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928052], [3866], [74217479], [46203647], [], []
Sun Oct  5 16:17:41 2008
Doing block recovery for file 6 block 95506
Block recovery from logseq 3490, block 144200 to scn 5305895325
Sun Oct  5 16:17:41 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3490 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo01.log
Block recovery completed at rba 3490.172038.16, scn 1.1010928030
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18597.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928085], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18599.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928086], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:42 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18593.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928089], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:43 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18601.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928093], [17922], [3271876784], [892220165], [], []
Sun Oct  5 16:17:44 2008
CKPT: terminating instance due to error 472
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18599.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928086], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928096], [45279], [3334780325], [3372071386], [], []
ORA-00472: PMON  process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:47 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18593.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928089], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:47 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18601.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928093], [17922], [3271876784], [892220165], [], []
Sun Oct  5 16:17:48 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928097], [45279], [3334780325], [3372071386], [], []
ORA-00600: internal error code, arguments: [2662], [1], [1010928096], [45279], [3334780325], [3372071386], [], []
ORA-00472: PMON  process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []

这是宕机之前的信息



刚open了，不过立刻就宕掉了
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_7657.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2A975D5
000] [] []


没有归档，也没有做任何热备份，无奈之下把数据库控制文件、日志文件、数据文件拷贝备份，再测试吧！此库采用导入导出备份，因为考虑数据量小，不太重要，把前天凌晨的数据导进去了，丢了整整一天的数据！我把全部错误等会整理发一下，忘高人指点下