OCP Blog
Super DBA
Logminer Gives Error - In Memory Undo is unsupported, What is In memory undo?
by Vazha Mantua Tuesday, July 12, 2011 1:44 PM

 

 

Hello All,

Oracle uses undo segments for these proposes

Undo records are used to:

1. Roll back transactions when a ROLLBACK statement is issued

2. Recover the database

3. Provide read consistency

4. Analyze data as of an earlier point in time by using Oracle Flashback Query

5. Recover from logical corruptions using Oracle Flashback features

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

In Memory undo!

 

In 10G,Oracle begin use new feature called In memory undo know as IMU, instead of undo

segments, they use memory structure which store undo information. Oracle still creates undo because it must still provide commit, rollback, and read consistency capabilities.

This has many implications. Anytime an Oracle buffer is changed the associated change (called a redo vector) is written into the redo log buffer. Unfortunately,

even if an undo segment is changed its change must also be recorded in the redo log buffer. But since IMUs are not undo segments, their changes

do not generate redo! So IMU will reduce the amount of redo an instance generates.

When we use traditional undo segments for each change , in redo log buffer write information about change of buffer cache block and undo block!

Another amazing feature of IMU is when it comes time to transform the in-memory undo into undo segment format(commit complete),

multiple IMUs can be consolidated into a single undo segment write.

When we use IMU for each change, in redo log buffer write information only for buffer cache block and after when IMU flushed in redo log buffer wrote combine undo info.

As we know Oracle use IMU for small transaction, for large transaction it works with traditional undo segment, but we don’t know it exactly. if we find any article about it we will tell us!

 

 

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

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 Note 186150.1
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 Note 186150.1 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

Tags: ,

Comments (8) -

9/6/2011 12:10:10 AM #

Tim Anderson

Incredibly illuminating thank you, It is my opinion your trusty audience might possibly want far more articles similar to this continue the good hard work.

Tim Anderson United States

9/6/2011 12:09:57 PM #

Gabriel Jefferson

Exceptionally beneficial cheers, I reckon your subscribers may want a whole lot more blog posts along these lines maintain the great work.

Gabriel Jefferson United States

9/6/2011 10:42:43 PM #

Tim Cole

Exceedingly challenging bless you, I reckon your readers may very well want even more well written articles similar to this keep up the excellent hard work.

Tim Cole United States

9/7/2011 1:25:11 AM #

Andrew Anderson

Astonishingly illuminating many thanks, I think your current followers would definitely want further reviews of this nature keep up the excellent work.

Andrew Anderson United States

9/7/2011 2:47:52 AM #

Gabriel Cole

Exceptionally enlightening thank you, I think your current audience would definitely want considerably more information of this nature carry on the excellent work.

Gabriel Cole United States

9/7/2011 12:38:46 PM #

Johnny Cole

Awfully revealing appreciate it, I believe your trusty audience might possibly want significantly more writing like that carry on the good effort.

Johnny Cole United States

9/7/2011 10:49:09 PM #

Andrew Cole

Enormously good many thanks, There's no doubt that your current audience may well want further blog posts like that continue the great work.

Andrew Cole United States

2/15/2012 3:21:22 AM #

carpet cleaning springville

nice blog. I enjoyed reading through your site.

carpet cleaning springville United States

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox