ORA-600 [4000] trying to get dba of undo segment header block from usn-47456.1
ORA-600 [4000] "trying to get dba of undo segment header block from usn" [ID 47456.1]
Note: For additional ORA-600 related information please read Note:146580.1
PURPOSE:
This article discusses the internal error "ORA-600 [4000]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:
Format: ORA-600 [4000] [a]
VERSIONS: version 6.0 to 9.2 DESCRIPTION: This has the potential to be a very serious error. It means that Oracle has tried to find an undo segment number in the dictionary cache and failed. ARGUMENTS: Arg [a] Undo segment number FUNCTIONALITY: KERNEL TRANSACTION UNDO IMPACT: INSTANCE FAILURE - Instance will not restart STATEMENT FAILURE SUGGESTIONS: As per Note 1371820.8, this can be seen when executing DML on tables residing in tablespaces transported from another database. It is fixed in 8.1.7.4, 9.0.1.4 and 9.2.0.1 The workaround however is to create more rollback segments in the target database until the highest rollback segment number (select max(US#) from sys.undo$;) is at least as high as in equivalent max(US#) from the source database. It has also been seen where memory has been corrupted so try shutting down and restarting the instance. If the database will not start contact Oracle Support Services immediately, providing the alert.log and associated trace files. KNOWN ISSUES:
Known Bugs
You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:
NB Bug Fixed Description 13910190 11.2.0.4, 12.1.0.0 ORA-600 [4000] from plugged in tablespace in Exadata * 9145541 11.1.0.7.4, 11.2.0.1.2, 11.2.0.2, 12.1.0.0 OERI[25027]/OERI[4097]/OERI[4000]/ORA-1555 in plugged datafile after CREATE CONTROLFILE in 11g + 10425010 11.2.0.3, 12.1 Stale data blocks may be returned by Exadata FlashCache M 14741727 12.1.0.0 Fixes for bug 12326708 and 14624146 can cause problems - backout patch 12353983 ORA-600 [4000] with XA in RAC 7687856 11.2.0.1 ORA-600 [4000] from DML on transported ASSM tablespace 2917441 11.1.0.6 OERI [4000] during startup 3115733 9.2.0.5, 10.1.0.2 OERI[4000] / index corruption can occur during index coalesce 2959556 9.2.0.5, 10.1.0.2 STARTUP after an ORA-701 fails with OERI[4000] 1371820 8.1.7.4, 9.0.1.4, 9.2.0.1 OERI:4506 / OERI:4000 possible against transported tablespace + 434596 7.3.4.2, 8.0.3.0 ORA-600[4000] from altering storage of BOOTSTRAP$
- '*' indicates that an alert exists for that issue.
- '+' indicates a particularly notable issue / bug.
- 'I' indicates an install issue / bug included for completeness.
- 'P' indicates a port specific bug.
- Fixed versions use "BPnn" to indicate Exadata bundle nn.
- "OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].
Bug 1362499 ORA-600 [4000] after migrating 7.3.4.3 to 8.0.6.1 on HP-UX 32-bit Specific to HP-UX, fixed in one-off patch
|
|
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition > RDBMS > ORA-600 by dbase unrelated to another product or component
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Personal Edition > Generic RDBMS > ORA-600 by dbase unrelated to another product or component
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition > Generic RDBMS > ORA-600 by dbase unrelated to another product or component
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-753113/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- dump轉儲undo segment header block回滾段頭塊小方法HeaderBloC
- undo segment header中記錄的dba是該事務使用的單向連結串列中的頭(end block)!HeaderBloC
- oracle undo segment header 事務表transaction table系列一OracleHeader
- 關於ITL以及UNDO SEGMENT HEADER 事物表(tx table)闡述Header
- Oracle Undo SegmentOracle
- block/extent/segment的理解BloC
- 使用oracle 11g bbed dump undo header block報錯之系列六OracleHeaderBloC
- How to Shrink Undo Segment In Oracle DatabaseOracleDatabase
- table/segment/extent/block之間關係BloC
- Export data from a data blockExportBloC
- UNDO SEGMENT的擴充套件和收縮套件
- oracle concept——data block,extent,segment-01OracleBloC
- db block get和consistent read getBloC
- ORA-600[4000]/[4097]錯誤的處理
- dba_segments之segment_type='TEMPORARY'
- ORA-600 [kdBlkCheckError] [file#] [block#] [code]ErrorBloC
- SMON: recover undo segment與並行事務恢復並行
- Get data style from ExcelExcel
- get_data_from_yml
- ORA-600 [13011] when trying to delete a row-28184.1delete
- 1128PAGETABLE SEGMENT HEADER損壞恢復Header
- undo segment的建立、線上以及extent的分配原則。
- GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2Database
- Ora-600 [15160] Joining Dba_objects and Dba_segmentsObject
- PostgreSQL DBA(16) - WAL segment file內部結構SQL
- ora-600 [4000]的又一次處理[轉帖]
- Get your Windows product key from a scriptWindows
- error:unable to get logical block size for spfileErrorBloC
- zt_不完全詳解os block headerBloCHeader
- 查詢資料時,segment header被訪問的次數Header
- 沒有備份undo segment出現問題的處理
- undo segment的建立、online以及extent的分配原則
- Oracle效能最佳化之Rollback(undo)Segment最佳化(轉)Oracle
- SMON: about to recover undo segment 1 的錯誤提示解決方法
- LMT更新file header bitmap不產生redo和undo ?Header
- Can't find the 'libpq-fe.h header when trying to install pg gemHeader
- 前線上日誌檔案損壞與ora-600 [4000]處理
- jedis異常:Could not get a resource from the pool