Oninit cdi / Archive
Talk to an expert →

ER - How to reset the replay position ?

Posted in 2007

Topics: Logging & Checkpoints, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

philippe — — source: Usenet: comp.databases.informix

Hi all, In ER (IDS 10.00.UC4), how to reset the replay position ? We have performed a 'cdr stop' on both root and leaf servers, leaving intentionally the leaf server going out of sync. A few day later, we intended to globally resynchronize the leaf server (dbexport on the root, dbimport on the leaf). When trying to start up ER ('cdr start' on both servers), DDR didn't start, because "replay logical log ID (26286) is not present". Indeed, the log 26286 had been overwritten. Is it necessary to drop and recreate all the ER objects (servers, replicates, replicatesets) to reset the replay position ? Thank you, Philippe

↪ replying to philippe
Madison Pruet — — source: Usenet: comp.databases.informix

philippe wrote: > Hi all, > > In ER (IDS 10.00.UC4), how to reset the replay position ? > > We have performed a 'cdr stop' on both root and leaf servers, leaving > intentionally the leaf server going out of sync. > > A few day later, we intended to globally resynchronize the leaf server > (dbexport on the root, dbimport on the leaf). When trying to start up ER > ('cdr start' on both servers), DDR didn't start, because "replay logical > log ID (26286) is not present". Indeed, the log 26286 had been overwritten. Use "cdr cleanstart" > > Is it necessary to drop and recreate all the ER objects (servers, > replicates, replicatesets) to reset the replay position ? > > Thank you, > Philippe > >

↪ replying to Madison Pruet
philippe — — source: Usenet: comp.databases.informix

Madison Pruet vient de nous annoncer : > philippe wrote: >> Hi all, >> >> In ER (IDS 10.00.UC4), how to reset the replay position ? >> >> We have performed a 'cdr stop' on both root and leaf servers, leaving >> intentionally the leaf server going out of sync. >> >> A few day later, we intended to globally resynchronize the leaf server >> (dbexport on the root, dbimport on the leaf). When trying to start up ER >> ('cdr start' on both servers), DDR didn't start, because "replay logical >> log ID (26286) is not present". Indeed, the log 26286 had been overwritten. > > Use "cdr cleanstart" > Thank you Madison !

Glossary