关于莫名其妙的ora-00472！！！

最新推荐文章于 2021-06-08 22:41:02 发布

congshanlan2358

最新推荐文章于 2021-06-08 22:41:02 发布

阅读量408

点赞数

文章标签：数据库操作系统

今天有人说，有个数据库，只要一登录数据库就会自动宕了！看日志文件，发现错误是由于472，这个错误是个对解决问题没有太大意义!

今天有人说，有个数据库，只要一登录数据库就会自动宕了！看日志文件，发现错误是由于472，这个错误是个对解决问题没有太大意义!查了半天,也就是说有可能bug呀什么,但最简单就是重启数据库!重启了几次问题依旧!后来把操作系统也重启了两次,还是不行!

可下班后,感觉系统慢,就又重启了一次,这次居然好了!

最后也不知道这个是怎么解决的,但问题消失了!

要说有什么总结,那也许就是重启N次！呵呵！！

日志中的错误类似:

CKPT: terminating instance due to error 472
Instance terminated by CKPT, pid = 7856

伴随生成的trace文件内容:

Dump file e:oracleadminoralimsudumporalims_ora_1300.trc
Wed May 17 15:40:47 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: oralims

Redo thread mounted by this instance: 0

Oracle process number: 12

Windows thread id: 1300, image: ORACLE.EXE

*** SESSION ID:(9.1) 2006-05-17 15:40:47.000
(blkno = 0x7a, size = 276, max = 1, in-use = 1, last-recid= 0)
(blkno = 0x7b, size = 56, max = 145, in-use = 1, last-recid= 1)
Thread checkpoint rba:0x00000c.00000002.0010 scn:0x0000.001e698d
On-disk rba:0x00000c.0000020c.0000 scn:0x0000.001e6bcf
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x00000c.00000003.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 260Kb/sec => 521 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/982 (0%)
----------------------------------------------
*** 2006-05-17 15:40:48.000
KCRA: start recovery claims for 110 data blocks
*** 2006-05-17 15:40:48.000
KCRA: buffers claimed = 110/110, eliminated = 0