ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: internal error code, arguments: [kcbgcur_9], [335544649],

ORA-00600: internal error code, arguments: [kcbgcur_9], [335544649],

原创 Linux操作系统 作者:lijiebin 时间:2011-02-17 20:10:10 0 删除 编辑

 

BEGIN dbms_logstdby.build; END;

 

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kcbgcur_9], [335544649], [17], [393216], [131072], [], [], []

ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 370

ORA-06512: at "SYS.DBMS_LOGSTDBY", line 157

ORA-06512: at line 1

 

根据后面的编号,可以对应到相关对象

 

11:05:44 sys@bt>  select dbms_utility.data_block_address_file(335544649) from dual;

   select dbms_utility.data_block_address_block(335544649) from dual;

 

DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(335544649)

-----------------------------------------------

                                             80

 

Elapsed: 00:00:00.09

11:05:46 sys@bt>

DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(335544649)

------------------------------------------------

                                             329

 

Elapsed: 00:00:00.01

11:05:46 sys@bt>select * from dba_data_files where file_id=80; 

 

FILE_NAME

----------------------------------------------------------------------------------------------------------------------------------

   FILE_ID TABLESPACE_NAME                                                        BYTES     BLOCKS

---------- ------------------------------------------------------------------------------------------ ---------- ----------

STATUS                      RELATIVE_FNO AUTOEXTEN   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS

--------------------------- ------------ --------- ---------- ---------- ------------ ---------- ----------- ---------------------

+DG1/bt/undotbs05.dbf

        80 UNDOTBS5                                                                  7011827712     855936

AVAILABLE                             80 YES       8589934592    1048576        1280 7011762176      855928 ONLINE

 

 

Elapsed: 00:00:00.05

 

将该undo  干掉解决问题。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-687464/,如需转载,请注明出处,否则将追究法律责任。

下一篇: rac 重建undo
请登录后发表评论 登录
全部评论

注册时间:2008-01-10

  • 博文量
    145
  • 访问量
    152111