transactions ready - 1, transactions applied 0
edited Nov 1, 2009 10:45PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi all,
We implemented logical standby database and it has been working for a while without any problem..But yesterday evening something happened, and now I can not see any transactions applying.
Archive logs are registered and log minining seems to be working when I checked alert.log. I can not find any error msg.
Archive logs are registered and log minining seems to be working when I checked alert.log. I can not find any error msg.
> SELECT NAME, VALUE FROM V$LOGSTDBY_STATS WHERE NAME LIKE '%transactions%';
NAME VALUE
transactions ready 1
transactions applied 0
I wonder why these values are 1 and 0 ??
0