由于重起之后也没再出现异常,所以就没再理它,不过想想不能这么干,所以请大家给分析分析,造成这种现象的原因.怎么预防~~~
谢谢
***
Corrupt block relative dba: 0x0240ca8e (file 9, block 51854)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240caa1
last change scn: 0x0000.060a4123 seq: 0x1 flg: 0x04
consistency value in tail: 0x41230601
check value in block header: 0xca89, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240ca8e (file 9, block 51854) found valid data
***
Corrupt block relative dba: 0x0240dd16 (file 9, block 56598)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240dd28
last change scn: 0x0000.05452835 seq: 0x1 flg: 0x04
consistency value in tail: 0x28350601
check value in block header: 0xd317, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240dd16 (file 9, block 56598) found valid data
***
Corrupt block relative dba: 0x06000fde (file 24, block 4062)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06000fe7
last change scn: 0x0000.05f3759a seq: 0x1 flg: 0x06
consistency value in tail: 0x759a0601
check value in block header: 0xb71b, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x06000fde (file 24, block 4062) found valid data
***
Corrupt block relative dba: 0x024025f1 (file 9, block 9713)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x02402602
last change scn: 0x0000.03a53157 seq: 0x1 flg: 0x06
consistency value in tail: 0x31570601
check value in block header: 0x2b0f, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x024025f1 (file 9, block 9713) found valid data
***
Corrupt block relative dba: 0x02409b0c (file 9, block 39692)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x02409b13
last change scn: 0x0000.0603756d seq: 0x1 flg: 0x06
consistency value in tail: 0x756d0601
check value in block header: 0x343b, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x02409b0c (file 9, block 39692) found valid data
***
Corrupt block relative dba: 0x0240c927 (file 9, block 51495)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240c939
last change scn: 0x0000.0507afba seq: 0x1 flg: 0x04
consistency value in tail: 0xafba0601
check value in block header: 0x524e, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240c927 (file 9, block 51495) found valid data
***
Corrupt block relative dba: 0x0240c928 (file 9, block 51496)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240c939
last change scn: 0x0000.0507afba seq: 0x1 flg: 0x04
consistency value in tail: 0xafba0601
check value in block header: 0x524e, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240c928 (file 9, block 51496) found valid data
***
Corrupt block relative dba: 0x060026eb (file 24, block 9963)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06002708
last change scn: 0x0000.060365a8 seq: 0x1 flg: 0x06
consistency value in tail: 0x65a80601
check value in block header: 0xc62a, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060026eb (file 24, block 9963) found valid data
***
Corrupt block relative dba: 0x060026ec (file 24, block 9964)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06002708
last change scn: 0x0000.060365a8 seq: 0x1 flg: 0x06
consistency value in tail: 0x65a80601
check value in block header: 0xc62a, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060026ec (file 24, block 9964) found valid data
***
Corrupt block relative dba: 0x060026ed (file 24, block 9965)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06002708
last change scn: 0x0000.060365a8 seq: 0x1 flg: 0x06
consistency value in tail: 0x65a80601
check value in block header: 0xc62a, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060026ed (file 24, block 9965) found valid data
***
Corrupt block relative dba: 0x0240eae1 (file 9, block 60129)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240eaff
last change scn: 0x0000.061f74cf seq: 0x1 flg: 0x06
consistency value in tail: 0x74cf0601
check value in block header: 0xa7e1, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240eae1 (file 9, block 60129) found valid data
***
Corrupt block relative dba: 0x060026ee (file 24, block 9966)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06002708
last change scn: 0x0000.060365a8 seq: 0x1 flg: 0x06
consistency value in tail: 0x65a80601
check value in block header: 0xc62a, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060026ee (file 24, block 9966) found valid data
***
Corrupt block relative dba: 0x0240eae2 (file 9, block 60130)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240eaff
last change scn: 0x0000.061f74cf seq: 0x1 flg: 0x06
consistency value in tail: 0x74cf0601
check value in block header: 0xa7e1, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240eae2 (file 9, block 60130) found valid data
Mon Nov 27 09:53:49 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2160.trc:
ORA-00600: 内部错误代码，参数: [711], [1], [0x0], [opifch:cbv_rdef], [], [], [], []
Mon Nov 27 09:53:57 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2160.trc:
ORA-00600: 内部错误代码，参数: [17114], [0x7A15218C], [], [], [], [], [], []
ORA-00600: 内部错误代码，参数: [711], [1], [0x0], [opifch:cbv_rdef], [], [], [], []
***
Corrupt block relative dba: 0x024094d4 (file 9, block 38100)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x024094e9
last change scn: 0x0000.03e9679d seq: 0x1 flg: 0x06
consistency value in tail: 0x679d0601
check value in block header: 0x3b17, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
***
Corrupt block relative dba: 0x024025af (file 9, block 9647)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x024025b6
last change scn: 0x0000.0396da9b seq: 0x1 flg: 0x04
consistency value in tail: 0xda9b0601
check value in block header: 0xcaa8, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Mon Nov 27 09:55:28 2006
Reread of rdba: 0x024094d4 (file 9, block 38100) found valid data
Mon Nov 27 09:55:28 2006
Reread of rdba: 0x024025af (file 9, block 9647) found valid data
***
Corrupt block relative dba: 0x0240c918 (file 9, block 51480)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240c92b
last change scn: 0x0000.04ebe641 seq: 0x1 flg: 0x06
consistency value in tail: 0xe6410601
check value in block header: 0x1a64, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240c918 (file 9, block 51480) found valid data
***
Corrupt block relative dba: 0x024025f0 (file 9, block 9712)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x024025f8
last change scn: 0x0000.03a566c0 seq: 0x1 flg: 0x04
consistency value in tail: 0x66c00601
check value in block header: 0x8630, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x024025f0 (file 9, block 9712) found valid data
Mon Nov 27 09:55:53 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [kghGetHpSz1], [0x713784CC], [], [], [], [], [], []
Mon Nov 27 09:56:09 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [17090], [], [], [], [], [], [], []
***
Corrupt block relative dba: 0x060013a1 (file 24, block 5025)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060013c0
last change scn: 0x0000.05e0780f seq: 0x1 flg: 0x06
consistency value in tail: 0x780f0601
check value in block header: 0x9c0a, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060013a1 (file 24, block 5025) found valid data
***
Corrupt block relative dba: 0x060013a2 (file 24, block 5026)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060013c1
last change scn: 0x0000.05d29bbf seq: 0x1 flg: 0x06
consistency value in tail: 0x9bbf0601
check value in block header: 0x58b3, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060013a2 (file 24, block 5026) found valid data
***
Corrupt block relative dba: 0x060013a3 (file 24, block 5027)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060013c2
last change scn: 0x0000.13078196 seq: 0x1 flg: 0x06
consistency value in tail: 0x81960601
check value in block header: 0x1d22, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060013a3 (file 24, block 5027) found valid data
***
Corrupt block relative dba: 0x060013a4 (file 24, block 5028)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060013c3
last change scn: 0x0000.05bef94c seq: 0x1 flg: 0x06
consistency value in tail: 0xf94c0601
check value in block header: 0x415c, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060013a4 (file 24, block 5028) found valid data
Mon Nov 27 09:56:26 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [17090], [], [], [], [], [], [], []
Mon Nov 27 09:56:38 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [17090], [], [], [], [], [], [], []
Mon Nov 27 09:56:48 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [17090], [], [], [], [], [], [], []
***
Corrupt block relative dba: 0x06000621 (file 24, block 1569)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06000633
last change scn: 0x0000.05a5c722 seq: 0x1 flg: 0x04
consistency value in tail: 0xc7220601
check value in block header: 0x51e7, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x06000621 (file 24, block 1569) found valid data
***
Corrupt block relative dba: 0x06000622 (file 24, block 1570)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x06000633
last change scn: 0x0000.05a5c722 seq: 0x1 flg: 0x04
consistency value in tail: 0xc7220601
check value in block header: 0x51e7, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x06000622 (file 24, block 1570) found valid data
Mon Nov 27 09:57:26 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2460.trc:
ORA-00600: 内部错误代码，参数: [12209], [9], [], [], [], [], [], []
Mon Nov 27 09:58:57 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [kpnugd-3], [Invalid Handle], [], [], [], [], [], []
Mon Nov 27 09:58:57 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2460.trc:
ORA-00600: 内部错误代码，参数: [17271], [instantiation space leak], [], [], [], [], [], []
Mon Nov 27 09:59:02 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2408.trc:
ORA-00600: 内部错误代码，参数: [17090], [], [], [], [], [], [], []
Mon Nov 27 10:00:20 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2172.trc:
ORA-00600: internal error code, arguments: [kghxhdr1], [], [], [], [], [], [], []
Mon Nov 27 10:00:21 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2336.trc:
ORA-00600: internal error code, arguments: [17114], [0x6D3B218C], [], [], [], [], [], []
***
Corrupt block relative dba: 0x024094c8 (file 9, block 38088)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x024094e1
last change scn: 0x0000.03e8fc11 seq: 0x1 flg: 0x06
consistency value in tail: 0xfc110601
check value in block header: 0xbe38, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x024094c8 (file 9, block 38088) found valid data
***
Corrupt block relative dba: 0x06003794 (file 24, block 14228)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060037b3
last change scn: 0x0000.1303095f seq: 0x1 flg: 0x04
consistency value in tail: 0x095f0601
check value in block header: 0x416f, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x06003794 (file 24, block 14228) found valid data
***
Corrupt block relative dba: 0x06003795 (file 24, block 14229)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060037b4
last change scn: 0x0000.1303178e seq: 0x1 flg: 0x04
consistency value in tail: 0x178e0601
check value in block header: 0xf98c, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x06003795 (file 24, block 14229) found valid data
***
Corrupt block relative dba: 0x06003796 (file 24, block 14230)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060037b4
last change scn: 0x0000.1303178e seq: 0x1 flg: 0x04
consistency value in tail: 0x178e0601
check value in block header: 0xf98c, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
***
Corrupt block relative dba: 0x0240d6e0 (file 9, block 55008)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240d6ec
last change scn: 0x0000.05b40daa seq: 0x1 flg: 0x06
consistency value in tail: 0x0daa0601
check value in block header: 0xb0f5, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Mon Nov 27 10:05:59 2006
Reread of rdba: 0x06003796 (file 24, block 14230) found valid data
Mon Nov 27 10:06:30 2006
Reread of rdba: 0x0240d6e0 (file 9, block 55008) found valid data
***
Corrupt block relative dba: 0x060025e0 (file 24, block 9696)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060025f1
last change scn: 0x0000.06000938 seq: 0x1 flg: 0x04
consistency value in tail: 0x09380601
check value in block header: 0x8650, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060025e0 (file 24, block 9696) found valid data
***
Corrupt block relative dba: 0x060037aa (file 24, block 14250)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x060037c9
last change scn: 0x0000.1306a0bd seq: 0x1 flg: 0x04
consistency value in tail: 0xa0bd0601
check value in block header: 0x5f25, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x060037aa (file 24, block 14250) found valid data
***
Corrupt block relative dba: 0x0240c948 (file 9, block 51528)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0240c95b
last change scn: 0x0000.05306f3f seq: 0x1 flg: 0x04
consistency value in tail: 0x6f3f0601
check value in block header: 0xce75, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0240c948 (file 9, block 51528) found valid data
Mon Nov 27 10:14:17 2006
Errors in file e:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump\\\\jdlsprod_ora_2052.trc:
ORA-00600: 内部错误代码，参数: [kghGetHpSz1], [0x640694C8], [], [], [], [], [], []
Mon Nov 27 10:14:50 2006
CJQ0: terminating instance due to error 472
Mon Nov 27 10:15:07 2006
Instance terminated by CJQ0, pid = 1432
Mon Nov 27 10:53:09 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 450
timed_statistics = TRUE
shared_pool_size = 318767104
sga_max_size
= 1553016688
large_pool_size
= 109051904
java_pool_size = 159383552
control_files
= E:\\\\oracle\\\\oradata\\\\jdlsprod\\\\CONTROL01.CTL, E:\\\\oracle\\\\oradata\\\\jdlsprod\\\\CONTROL02.CTL, D:\\\\oradataCONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 788529152
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 32
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= jdlsprod
dispatchers
= (PROTOCOL=TCP) (SERVICE=jdlsprodXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
hash_area_size = 1048576
background_dump_dest = E:\\\\oracle\\\\admin\\\\jdlsprod\\\\bdump
user_dump_dest = E:\\\\oracle\\\\admin\\\\jdlsprod\\\\udump
core_dump_dest = E:\\\\oracle\\\\admin\\\\jdlsprod\\\\cdump
sort_area_size = 1048576
db_name
= jdlsprod
open_cursors
= 300
star_transformation_enabled= TRUE
query_rewrite_enabled= TRUE
pga_aggregate_target = 268435456
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon Nov 27 10:53:13 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address \\\'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))\\\'...
Mon Nov 27 10:53:14 2006
/* OracleOEM */ ALTER DATABASE MOUNT
Mon Nov 27 10:53:18 2006
Successful mount of redo thread 1, with mount id 1653566362.
Mon Nov 27 10:53:18 2006
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Mon Nov 27 10:53:18 2006
/* OracleOEM */ ALTER DATABASE OPEN
Mon Nov 27 10:53:19 2006
Beginning crash recovery of 1 threads
Mon Nov 27 10:53:19 2006
Started first pass scan
Mon Nov 27 10:53:19 2006
Completed first pass scan
21987 redo blocks read, 3860 data blocks need recovery
Mon Nov 27 10:53:19 2006
Started recovery at
Thread 1: logseq 1481, block 165141, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1481 Reading mem 0
Mem# 0 errs 0: E:\\\\ORACLE\\\\ORADATA\\\\JDLSPROD\\\\REDO01.LOG
Mon Nov 27 10:53:33 2006
Ended recovery at
Thread 1: logseq 1481, block 187128, scn 0.322980115
3860 data blocks read, 3860 data blocks written, 21987 redo blocks read
Crash recovery completed successfully
Mon Nov 27 10:53:35 2006
Thread 1 advanced to log sequence 1482
Thread 1 opened at log sequence 1482
Current log# 2 seq# 1482 mem# 0: E:\\\\ORACLE\\\\ORADATA\\\\JDLSPROD\\\\REDO02.LOG
Successful open of redo thread 1.
Mon Nov 27 10:53:36 2006
SMON: enabling cache recovery
Mon Nov 27 10:53:36 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Nov 27 10:53:37 2006
SMON: enabling tx recovery
Mon Nov 27 10:53:37 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
|
