oracle logmnr 報錯"In Memory Undo is unsupported"
非原創
Logminer Gives Error - In Memory Undo is unsupported!
Why logiminer Gives error?
We see that structure of redo entries is different, for IMU logminer can’t recover full picture of transaction in same time.
Now see on metalink, note ID 428167.1 which give us solution for avoid error “In Memory Undo is unsupported” in future!
1.Logminer cannot always populate all the fields of the v$logmnr_contents this is
because the redo may/may not have all the information that we need for every
column. Adding Supplemental Logging will help in more info being logged in the
redo being generated, helping populate more values. This can be done by the
following commands:
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY,
UNIQUE INDEX) COLUMNS;
SQL> ALTER SYSTEM SWITCH LOGFILE;
Additionally, it is not unusual for 10g to generate more redo than previously
seen in earlier versions.
2: Logminer cannot always populate all the fields of the v$logmnr_contents this is because the redo
may/may not have all the information that we need for every column, you need to enable supplemental
logging on the database following
Supplemental logging is required to receive reliable and consistent information from logminer.
Without supplemental logging enabled, the redo may not contain enough information
for LogMiner to construct the correct sql_redo (or any sql_redo in the case of in-memory undo, IMU).
LogMiner does not work with IMU and turning supplemental logging on disables IMU.
Please enable supplemental logging as per to eliminate these messages and update
whether you still encounter the UNSUPPORTED messages.
3: Logminer may not be able to find sql_redo for transactions that were created before supplemental
logging is enabled.
It will only work for redo's which contains information to extract the correct sql_redo
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/133735/viewspace-713362/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle In Memory Undo(IMU)Oracle
- Oracle In Memory Undo(轉)Oracle
- GoldenGate OGG-00717 unsupported in-memory undo recordGo
- 安裝OUD報錯,unsupported classversion 51.0
- 報錯求助:Unsupported locator strategy: -ios predicate stringiOS
- golang使用sqlx報錯:unsupported type []interface {}, a slice of interfaceGolangSQL
- Oracle報錯:ORA-00845: MEMORY_TARGET not supported on this systemOracle
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- oracle logmnrOracle
- 執行jar檔案生成pdf報錯,Unsupported URL <file:///homeJAR
- Oracle logmnr使用Oracle
- oracle logmnr文件Oracle
- Oracle 11g報錯"ORA-00845: MEMORY_TARGET not supported on this system"Oracle
- oracle 11g報錯ORA-00845: MEMORY_TARGET not supported on this systemOracle
- MongoDB報錯:"assertion" : "can't map file memory"MongoDB
- 報錯:Missing type map configuration or unsupported mappingAPP
- 使用oracle 11g bbed dump undo header block報錯之系列六OracleHeaderBloC
- [江楓]In Memory Undo與logical standby databaseDatabase
- 關於Unsupported major.minor version 52.0報錯問題解決方案
- hadoop 程式碼編譯 mvn報錯 Unsupported major.minor version 51.0Hadoop編譯
- git post資料過大報錯-Out of memoryGit
- influxdb報錯:cache-max-memory-size exceededUX
- HP-UX執行Oracle相關命令報錯Memory fault(coredump)分析處理UXOracle
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- ORACLE LOGMNR 日誌挖掘Oracle
- oracle 10g logmnrOracle 10g
- memory_max_target/memory_target設定過大報ORA-00845錯誤
- Oracle Redo and UndoOracle Redo
- Oracle undo 管理Oracle
- Oracle Undo SegmentOracle
- oracle undo管理Oracle
- oracle undo一Oracle
- Oracle logmnr簡單測試Oracle
- Oracle 10g Logmnr使用Oracle 10g
- oracle 的dbms_logmnr用途Oracle
- oracle dg報錯Oracle
- oracle emctl 報錯Oracle
- 錯誤:Dx unsupported class file version 52.0(解決)