今天在PlateSpin Forge(关于PlateSpin相关介绍,请见最下面部分简单介绍) 复制出来的一台数据库服务器上,测试数据库能否正常启动时,遇到了“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)