Skip to Content
0
Former Member
May 06, 2014 at 03:40 AM

warm standby synch up

110 Views

i have a question regarding sybase replication warm standby sync up and appreciate the clarification.

let us suppose in a warm standby setup, the standby data has gone out of sync with the primary database.

the log contains committed as well as uncommitted data.

but even uncommitted data is sent to rep server.

so in a tran log let us suppose there are 12 transactions. till transaction 7, it has been committed on the primary database (that i think is the primary truncation point).

and let us suppose that the secondary truncation point is at the 9th transaction - till which data has been sent to the rep server.

but we do the dump database at the 12th transaction, where the dump marker is inserted.

so when we load the database dump into the primary, it will start accepting replicated transactions from the 12th transaction - from where the dump marker starts.

so in this case won't the transactions from 7 to 12 be missed?

the above case assumes a scenario where the sync up can be done without doing a dump tran of the primary database. or does a warm standby sync up always require a dump tran with truncateonly/nolog, of the primary database (and also the related rs_zeroltm etc)?

I think with 15.6 there is a new way to do the sync up. but here I am referring to the pre-15 versions.

appreciate the clarification.

thanks,

nanda chandran