Laurence wrote:
> Hi folks,
>
> Anyone knows what do these mean?
>
> Primary log position(file, page, LSN) = S0000009.LOG, 0,
> 00000000036B0000
> Standby log position(file, page, LSN) = S0000008.LOG, 357,
> 000000000342D073
> Log gap running average(bytes) = 2633608
>
> Is HADR state real peer when the HADR state is peer but the above
> primary/standby log position are not the same? May I takeover the HADR
> at that time, or shall wait the primary/standby log position are the
> same?
>
>
> Thanks in advance~

I always see this log mis-match when I do an online backup, and no
subsequent changes to the database have occured since the backup. I
include the logs with the backup, but I don't know if that is reason
for the mis-match. If you were to do an insert, update, or delete, I
think you would see them in synch right after that.

I have never tried to do a takeover in that state, but I assume it
would not be a problem.