ORA-00600之kcrf_rsw_init-2

最新推荐文章于 2023-01-03 15:26:46 发布

转载最新推荐文章于 2023-01-03 15:26:46 发布 · 388 阅读

文章标签：

#数据库

本文介绍ORA-00600错误的原因及手动恢复数据库的方法，包括启动实例到挂起状态、查找当前在线重做日志、使用备份控制文件进行恢复等步骤。

ORA-00600: 内部错误代码, 参数: [kcrf_rsw_init-2], [346], [345], [1], [], [], [], [], [], [], [], []

Cause
During instance recovery the current online redolog header is read and we compare the information in the header against the information in the controlfile.

If the information in the controlfile is corrupt or out of sync then ORA-600 [kcrf_rsw_init-2] is raised.

Solution
Recover the database manually using 'backup controlfile' syntax.

This works because this syntax instructs the rdbms to ignore the recovery information in the controlfile - only the datafile names is taken from the controlfile and recovery is driven manually - we supply the name of the current online redolog and then we open the database with resetlogs - this involves a new checkpoint and this is recorded in the CHECKPOINT PROGRESS section

a. SQL>STARTUP MOUNT

b. Find current online redolog:

SQL>SELECT F.MEMBER, V.THREAD#, V.SEQUENCE#, V.GROUP#, V.STATUS
FROM V$LOG V, V$LOGFILE F WHERE V.GROUP# = F.GROUP#;
SQL>RECOVER DATABASE USING BACKUP CONTROFILE UNTIL CANCEL;

When prompted for the log sequence supply the name of the current online redolog then reopen:

SQL>ALTER DATABASE OPEN RESETLOGS;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8367589/viewspace-700134/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8367589/viewspace-700134/