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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8135069/viewspace-687464/