ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr] 与 ORA-01219:数据库未打开：仅允许在固...

今天也遇到了这个问题，在网上结合以下两个解决方法即可

造成的原因是log被损坏。
cmd -> sqlplus
SQL> select group#,sequence#,archived,status from v$log;

    GROUP#  SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
         1         86 NO  INACTIVE
         2         87 NO  INVALIDATED
         3         85 NO  INACTIVE

alter database clear logfile group 1;
 alter database clear logfile group 2;
 alter database clear logfile group 3;
 shutdown immediate;
 startup mount;
SQL> select group#,sequence#,archived,status from v$log;
    GROUP#  SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
         1         88 NO  CURRENT
         2          0 NO  UNUSED
         3          0 NO  UNUSED
alter database clear logfile group 1;
alter database clear unarchived logfile group 1;
 alter database clear logfile group 2;
alter database clear unarchived logfile group 2;
 alter database clear logfile group 3;
alter database clear unarchived logfile group 3;
shutdown;
startup mount;
alter database open;

 

----------------------------------------------

数据库装载完毕。
SQL> recover database;
完成介质恢复。
SQL> alter database open; 数据库已更改。
SQL>exit;

 

转载于:https://www.cnblogs.com/leeyq/p/ORA-00600.html