standby log apply acknowledgement
edited Jan 5, 2014 5:21PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 10 commentsAnswered ✓
Hi
There is small problem in my data-guard env.
In the standby server successfully applied logs generated by primary server. It is status also updating correctly as shown bellow.
390 YES 21-DEC-13 21-DEC-13
391 YES 21-DEC-13 21-DEC-13
392 YES 21-DEC-13 21-DEC-13
393 YES 22-DEC-13 22-DEC-13
394 YES 22-DEC-13 22-DEC-13
395 YES 22-DEC-13 22-DEC-13
396 YES 22-DEC-13 22-DEC-13
SEQUENCE# APPLIED COMPLETIO COMPLETIO
---------- --------- --------- ---------
397 YES 22-DEC-13 22-DEC-13
But in the side of primary server, its applied status shown as "NO" .
1 382 YES NO 20-DEC-13
1 383 YES NO 20-DEC-13
1 384 YES NO 20-DEC-13
1 385 YES NO 21-DEC-13
1 386 YES NO 21-DEC-13
1 387 YES NO 21-DEC-13
DEST_ID SEQUENCE# ARC APPLIED COMPLETIO
---------- ---------- --- --------- ---------
There is small problem in my data-guard env.
In the standby server successfully applied logs generated by primary server. It is status also updating correctly as shown bellow.
390 YES 21-DEC-13 21-DEC-13
391 YES 21-DEC-13 21-DEC-13
392 YES 21-DEC-13 21-DEC-13
393 YES 22-DEC-13 22-DEC-13
394 YES 22-DEC-13 22-DEC-13
395 YES 22-DEC-13 22-DEC-13
396 YES 22-DEC-13 22-DEC-13
SEQUENCE# APPLIED COMPLETIO COMPLETIO
---------- --------- --------- ---------
397 YES 22-DEC-13 22-DEC-13
But in the side of primary server, its applied status shown as "NO" .
1 382 YES NO 20-DEC-13
1 383 YES NO 20-DEC-13
1 384 YES NO 20-DEC-13
1 385 YES NO 21-DEC-13
1 386 YES NO 21-DEC-13
1 387 YES NO 21-DEC-13
DEST_ID SEQUENCE# ARC APPLIED COMPLETIO
---------- ---------- --- --------- ---------
0