ALLSTARS_ORACLE 发表于 2017-4-14 17:25:36

数据库宕机,在线急救

数据库实例突然宕掉,然后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] [] []

刚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] [] []

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

ALLSTARS_ORACLE 发表于 2017-4-14 17:26:03


操作系统:RHEL4_x86_64
ORACLE RDBMS:Oracle 10.2.0.4 x86_64
数据文件采用文件系统存储。

1、数据库实例宕机,查看alert_.log
Sun Oct  5 16:17:33 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:17:33 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: , , , , [], [], [], []
Sun Oct  5 16:17:34 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [] []
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:17:34 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_j000_18517.trc:
ORA-00600: internal error code, arguments: , , , , , , [], []
ORA-08103: object no longer exists
Sun Oct  5 16:17:35 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-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: , , , , , , [], []
Sun Oct  5 16:18:15 2008
Instance terminated by CKPT, pid = 10437
2、手工startup database,mount无法打开,过一会实例又挂了.
alert_sid.log:
ALTER DATABASE   MOUNT
Sun Oct  5 16:31:44 2008
Setting recovery target incarnation to 2
Sun Oct  5 16:31:44 2008
Successful mount of redo thread 1, with mount id 2789094315
Sun Oct  5 16:31:44 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Sun Oct  5 16:31:44 2008
ALTER DATABASE OPEN
Sun Oct  5 16:31:44 2008
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Sun Oct  5 16:31:44 2008
Started redo scan
Sun Oct  5 16:31:44 2008
Completed redo scan
30492 redo blocks read, 1883 data blocks need recovery
Sun Oct  5 16:31:44 2008
Started redo application at
Thread 1: logseq 3490, block 142497
Sun Oct  5 16:31:44 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3490 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo01.log
Sun Oct  5 16:31:44 2008
Completed redo application
Sun Oct  5 16:31:45 2008
Completed crash recovery at
Thread 1: logseq 3490, block 172989, scn 5305915380
1883 data blocks read, 1872 data blocks written, 30492 redo blocks read
Sun Oct  5 16:31:45 2008
Thread 1 advanced to log sequence 3491 (thread open)
Thread 1 opened at log sequence 3491
  Current log# 4 seq# 3491 mem# 0: /usr/oracle/oradata/blog/redo04.log
Successful open of redo thread 1
Sun Oct  5 16:31:45 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Oct  5 16:31:45 2008
SMON: enabling cache recovery
Sun Oct  5 16:31:45 2008
Successfully onlined Undo Tablespace 1.
Sun Oct  5 16:31:45 2008
SMON: enabling tx recovery
Sun Oct  5 16:31:45 2008
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p013_18330.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p015_18340.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p012_18328.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p014_18334.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p001_18268.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []

ALLSTARS_ORACLE 发表于 2017-4-14 17:26:20

Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p011_18322.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p002_18270.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=32, OS id=18354
Sun Oct  5 16:31:49 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p008_18316.trc:
ORA-00600: internal error code, arguments: , , , , , , ,
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p010_18320.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p009_18318.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p006_18280.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p005_18278.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p004_18276.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p007_18314.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p003_18272.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:41:49 2008
Process 0x0xdf3b7020 appears to be hung while dumping
Current time = 914482846, process death time = 914422733 interval = 60000
Attempting to kill process 0x0xdf3b7020 with OS pid = 18322
OSD kill succeeded for process 0xdf3b7020
Doing block recovery for file 6 block 95506
Doing block recovery for file 6 block 95506
Doing block recovery for file 6 block 95506
Block recovery from logseq 3491, block 63 to scn 5305915460
Sun Oct  5 16:41:52 2008
Recovery of Online Redo Log: Thread 1 Group 4 Seq 3491 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo04.log
Sun Oct  5 16:41:52 2008
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Oct  5 16:41:52 2008
Block recovery completed at rba 3491.141.16, scn 1.1010948165
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sun Oct  5 16:41:52 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
Completed: ALTER DATABASE OPEN
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_j000_18536.trc:
ORA-00600: internal error code, arguments: , , , , , , [], []
Sun Oct  5 16:41:52 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_mmon_18092.trc:
ORA-00600: internal error code, arguments: , , , , , , [], []
Sun Oct  5 16:41:53 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-07445: exception encountered: core dump [] []
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:41:53 2008
DEBUG: Replaying xcb 0xdce3a968, pmd 0xdbf3e0c8 for failed op 8
Reconstructing  Uhdr 0x800029 for xcb 0xdce3a968, pmd 0xdbf3e0c8
Doing block recovery for file 2 block 41
No block recovery was needed
DEBUG: Restoring block headers for xcb 0xdce3a968, pmd 0xdbf3e0c8
Sun Oct  5 16:41:53 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_j000_18536.trc:
ORA-00600: internal error code, arguments: , , , , , , [], []
ORA-00600: internal error code, arguments: , , , , , , [], []
Sun Oct  5 16:41:54 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_mmon_18092.trc:
ORA-00600: internal error code, arguments: , , , , , , [], []
ORA-00600: internal error code, arguments: , , , , , , [], []
Sun Oct  5 16:41:55 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-07445: exception encountered: core dump [] []
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-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:41:56 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-07445: exception encountered: core dump [] []
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-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [] []
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Sun Oct  5 16:41:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_pmon_18068.trc:
ORA-00474: SMON process terminated with error
Sun Oct  5 16:41:58 2008
PMON: terminating instance due to error 474
Sun Oct  5 16:41:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_lgwr_18080.trc:
ORA-00474: SMON process terminated with error
Sun Oct  5 16:41:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_ckpt_18084.trc:
ORA-00474: SMON process terminated with error
Sun Oct  5 16:42:29 2008
Instance terminated by PMON, pid = 18068

3、再次启动都是无法打开,错误信息类似
页: [1]
查看完整版本: 数据库宕机,在线急救