数据库宕机，在线急救
数据库实例突然宕掉，然后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: , [], [], [], [], [], [], []
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 [] []
ORA-07445: exception encountered: core dump [] []
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
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 [] []
ORA-07445: exception encountered: core dump [] []
ORA-07445: exception encountered: core dump [] []
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
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: , , , , [], [], [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
ORA-00472: PMON process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
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: , , , , , , [], []
ORA-00600: internal error code, arguments: , , , , , , [], []
ORA-00472: PMON process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: , , , , , , [], []
这是宕机之前的信息
刚open了，不过立刻就宕掉了
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_7657.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [] []
ORA-07445: exception encountered: core dump [] []
ORA-07445: exception encountered: core dump [0x2A975D5
000] [] []
没有归档，也没有做任何热备份，无奈之下把数据库控制文件、日志文件、数据文件拷贝备份，再测试吧！此库采用导入导出备份，因为考虑数据量小，不太重要，把前天凌晨的数据导进去了，丢了整整一天的数据！我把全部错误等会整理发一下，忘高人指点下
页:
[1]