Еще раз о ORA-00600
dbstalker, 07 июля
Еще одно утро началось с ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [], [], [], []
Об этой ошибке уже было здесь. Но сегодня захотелось восстановить базу немножко иначе. И на этот раз повезло !
SQL*Plus: Release 9.2.0.6.0 - Production on Ao. Eei 7 09:04:36 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> select status from V$INSTANCE;
STATUS
------------
MOUNTED
SQL> SHUTDOWN IMMEDIATE
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1368468024 bytes
Fixed Size 457272 bytes
Variable Size 788529152 bytes
Database Buffers 578813952 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1368468024 bytes
Fixed Size 457272 bytes
Variable Size 788529152 bytes
Database Buffers 578813952 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> recover database until cancel;
ORA-00279: change 10703439968 generated at 07/06/2009 15:06:11 needed for
thread 1
ORA-00289: suggestion : C:\ORACLE\ORADATA\MY_DBS\ARCHIVE\1_68.ARC
ORA-00280: change 10703439968 for thread 1 is in sequence #68
Specify log: {=suggested | filename | AUTO | CANCEL}
C:\oracle\oradata\my_dbs\redo01.log ;
Log applied.
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open noresetlogs;
Database altered.
Ура! Если будете идти таким путем, то не забудьте сделать холодную копию базы данных. Успехов!