6 Replies Latest reply: Nov 22, 2012 10:42 PM by IGorbatovsky RSS

    Standby v$archived_log sequecne#

    user2015671
      Hi,

      I created standby from primary database (oracle standard edition) and becauase of oracle standard edition i cannot ship archived logs from the primary side. And catalog archivelogs after mannually shipping it.

      So i wanted to to get sequecne# from the standby side. But for the first time value of below query is null.

      SQL> select trim(max(SEQUENCE#)) from v$archived_log where applied='YES';

      TRIM(MAX(SEQUENCE#))
      ----------------------------------------


      Is there any way that i can find something so that i come to know that which archives i need to ship from primary to standby side?

      Thanks a lot in advance for your help