ORA00600:[kcratr1_lostwrt]

ORA-00600: : [kcratr1_lostwrt], [], [], [], [], [], [], []

2009-08-10 09:09

OS:windows2003
DB:ORACLE 9.0.2.8
出现"ORA-00600: : [kcratr1_lostwrt], [], [], [], [], [], [], []"问题的原因:半夜机器自动挂掉

SQL> alter database open;
alter database open
*
ERROR 1 :
ORA-00600: : [kcratr1_lostwrt], [], [], [], [], [], [], []

SQL> alter database open;
alter database open
*
ERROR 1 :
ORA-00600: : [kcratr1_lostwrt], [], [], [], [], [], [], []

metalink提供办法:
Changes
There was a disk problem that caused the database to crash.
Cause
Oracle is unable to perform instance recover but it works when is invoked manually.
Solution
Mount the database and issue a recover statement

SQL> recover database;

SQL> alter database open;

另台OS为linux的机器没出现此问题,这里再次验证linux/unix做DB的OS比较好!