Re: First 17 updated records disappeared from REDOLOG files …

I have checked the same test case in 9.2.0.5 (Linux 3.0) and it works OK. Log minder retrived information about all records.

It is seams to me what is is a bug in 10GR2.

Jurijs

On 2/21/06, Jurijs Velikanovs <j.velikanovs_at_gmail.com> wrote:
> Hello everybody,
>
> I don't believe that change vectors are disappearing from REDO files.
> Presumably they are not.
> But the fact is that due some optimization or other reason Log Minder
> is not capable to retrieve data from an archive log file for first 17
> records updated by an update operation.
> . The FULL Test Case text is provided below .
> VJVDROPME:ASR02> update vjv_dropme_upd2
> VJVDROPME:ASR02> set object_name = 'HERE YOU GO.'
> VJVDROPME:ASR02> where rownum<=20
> VJVDROPME:ASR02> ;
> -------------=> 20 rows updated. <=-------------
> VJVDROPME:ASR02> commit;
> ... Starting Log Minder session commands …
> VJVDROPME:ASR02> SELECT a.sql_redo
> VJVDROPME:ASR02> FROM V$LOGMNR_CONTENTS a
> VJVDROPME:ASR02> where a.seg_name='VJV_DROPME_UPD2';
> SQL_REDO
> ----------------------------------------------------------------------------------------------------
> update "VJVDROPME"."VJV_DROPME_UPD2" set "OBJECT_NAME" = 'HERE YOU
> GO.' where "OBJECT_NAME" = 'I_CDE
> update "VJVDROPME"."VJV_DROPME_UPD2" set "OBJECT_NAME" = 'HERE YOU
> GO.' where "OBJECT_NAME" = 'IND$'
> update "VJVDROPME"."VJV_DROPME_UPD2" set "OBJECT_NAME" = 'HERE YOU
> GO.' where "OBJECT_NAME" = 'SEG$'
> -------------=> 3 rows selected. <=-------------
> .

--
http://www.freelists.org/webpage/oracle-l