ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []

今天在PlateSpin Forge(关于PlateSpin相关介绍,请见最下面部分简单介绍) 复制出来的一台数据库服务器上,测试数据库能否正常启动时,遇到了“ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []”错误:

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []

在官方文档介绍中,这个错误主要出现在磁盘出现故障导致数据库崩溃后,实例启动失败,并报ORA-00600: arguments: [kcratr1_lastbwr].

After a disk failure that caused the database to crash, the instance fails to start up with ORA-00600: arguments: [kcratr1_lastbwr].The alert log file shows the following entries :

Completed: ALTER DATABASE MOUNT

Tue Sep 19 09:43:03 2006

ALTER DATABASE OPEN

Block change tracking file is current.

Tue Sep 19 09:43:04 2006

Beginning crash recovery of 1 threads

parallel recovery started with 2 processes

Tue Sep 19 09:43:04 2006

Started redo scan

Tue Sep 19 09:43:05 2006

Errors in file gns80_ora_9936.trc:

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

Tue Sep 19 09:43:06 2006

Aborting crash recovery due to error 600

出现这个错误后,只能手工操作恢复,操作步骤也非常简单。如下所示:

Oracle is unable to perform instance recover but it works when is invoked manually.

SQL>  shutdown immediate;

 

SQL> startup mount;

 

SQL> recover database;

 

SQL> alter database open;

在整个过程中,最好开启另外一个窗口,一直刷新告警日志(tail -60f  alert_{$ORACLE_SID}.log),查看恢复过程中的具体情况。

Novell  PlateSpin Forge 相关资料:

Novell  PlateSpin Forge 将其接入生产环境后, 便可通过Forge管理界面,指定保护对象(workload, 可以是物理机或VM), 确定之后, Forge便将每个被保护对象转换复制成其ESX上的一台VM. 并在之后根据用户的设定在被保护对象和DR的VM之间进行定期复制更新.

保护对象故障时, 用户激活Forge上的VM, 实现failover. 故障排除之后, 可以通过V2P或V2V的方式, 对DR VM进行Failback操作, 将其复制回生产环境中的物理机或VM.

参考资料:

ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (文档 ID 393984.1)

上一篇:JAVA将Excel中的报表导出为图片格式(三)换一种实现


下一篇:flot图表的使用