ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600之kcrf_rsw_init-2

ORA-00600之kcrf_rsw_init-2

原创 Linux操作系统 作者:homeworld80 时间:2011-06-17 15:19:04 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-24

  • 博文量
    28
  • 访问量
    37383