5 Replies Latest reply: Nov 15, 2012 2:40 AM by JohnWatson RSS

    real time apply for logical standby

    Ora_83
      Hi

      Oracle 11.2.0.3.0

      I have a primary database orcl and logical standby database orcl_std.

      Real time apply is enabled. I have standby redologs in both primary and standby sides and I`ve started recovery with below command:

      ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;


      When I create a new table in primary database, I am unable to see it on standby database (Although real time apply is enabled)
      However, when I switch log in primary, I can see the new table in standby database.


      My question is, why realtime apply is not working in my scenerio ? I was expecting to see the new table immediately in standby database once it is created in primary database. Why am I supposed to wait for log switch in real time apply ?