Database Software

Hi,

by now my Streams environment works fine but I have some doubts. Suppose apply process fails, how do I know what is the last scn really applied and (this is the second question), while applying, how could I see the real progress in real time of the apply process, this is, what scn has just been applied?.

My environment is a two-node RAC 10.2.0.4 and the target site is 10.2.0.5. In this architecture all works fine but if the target site is 11.2.0.2 when updating appears an error:

ORA-23605 Update Should Have Non-Zero New Columns And Non-Zero Old Columns

Searching in Metalink , note 335529.1, it points that it is a bug and that it needs further investigation. However I have printed the lcr and while the source has a right structure with all the columns that I need to replicate, the target deletes all of them (In my case both source table and target table have not the same structure and some columns must be deleted at target site before execute the lcr). Due to some reason, in 11.2.0.2 the same custom dml handler code as 10.2.0.5, 11.2.0.2 version deletes all the columns so when it tries to execute the lcr, it is empty so an error appears.

My main question is the progress monitor of the apply process.

Thanks in advance.