ORA-00600: [kccpb_sanity_check_2], [494207], [493984], [0x0], [],

本文记录了一个Oracle数据库遇到ORA-00600和ORA-1507错误的情况及解决方案,错误出现在尝试进行数据库mount操作时,提供了三种解决思路:恢复控制文件、重建控制文件或者从最近的良好备份恢复整个数据库。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

今天是2013-03-24,在晚上打牌的时候,突然有个哥们“重庆-M*Red”遇到了这么一个oracle错误,自己想了一下解决方案,然后又百度了一下,发现差别不是很大。贴出来看一下。

 

alert日志内容如下:


Sun Mar 24 19:47:11 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)

(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sun Mar 24 19:47:12 2013
ALTER DATABASE MOUNT
Sun Mar 24 19:47:16 2013
Setting recovery target incarnation to 3
Sun Mar 24 19:47:16 2013
Errors in file c:\oracle\product\10.2.0\admin\his\udump\his_ora_3904.trc:
ORA-00600: ??????, ??: [kccpb_sanity_check_2], [494207], [493984], [0x0], [],
[], [], []
ORA-600 signalled during: ALTER DATABASE MOUNT...
Sun Mar 24 19:47:45 2013
ALTER DATABASE RECOVER database
Sun Mar 24 19:47:45 2013
ORA-1507 signalled during: ALTER DATABASE RECOVER database ...
Sun Mar 24 19:49:26 2013
alter database open

case:
[kccpb_sanity_check_2] indicates that the seq# of the last read block is
higher than the seq# of the control file header block. This is indication of
the lost write of the header block during commit of the previous cf
transaction.
Solution
1) restore a backup of a controlfile and recover
OR
2) recreate the controlfile
OR
3) restore the database from last good backup and recover
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值