06ноя
Как здорово когда утро начинается с ORA-00600!!!
Пасмурное осеннее утро, зеленый чай, Jem - Finally Woken, скоро выходные. И надо же - прибежали пользователи. Не могут подключиться к серверу. А такое хорошее утро было!!!
SQL> conn / as sysdba
Connected.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []
Да! Врагу не пожелаешь!
SQL> select file#,status from v$datafile;
FILE# STATUS
---------- -------
1 SYSTEM
2 ONLINE
3 ONLINE
4 ONLINE
5 ONLINE
6 ONLINE
7 ONLINE
8 ONLINE
9 ONLINE
10 ONLINE
11 ONLINE
FILE# STATUS
---------- -------
12 ONLINE
13 ONLINE
14 ONLINE
15 ONLINE
15 rows selected.
Ну хоть это радует.
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET aq_tm_processes=0;
SQL> recover automatic database;
Media recovery complete.
SQL> alter database open;
Database altered.
На этот раз удалось быстро вернуться к чаю! А это вам к сведению:
ERROR:
ORA-600 [kcratr1_lostwrt]
VERSIONS:
versions 9.2 to 10.1
DESCRIPTION:
This error is raised during crash/media recovery. When an instance is restarted following an instance crash, Oracle carries out some checks against the last block that was written to disk prior to the instance crash. If Oracle finds an old block, then this suggests a lost write and the error is raised.
FUNCTIONALITY:
Cache Redo Application
IMPACT:
INSTANCE FAILURE
POSSIBLE PHYSICAL CORRUPTION
SUGGESTIONS:
Submit the trace files and alert.log Oracle Support Services for further analysis. This could suggest a hardware/OS problem. There is every chance that a recovery will be needed in order to resolve this problem. Oracle Support Services will advise on this once suitable evidence has been provided from the trace files and alert log.