6 Replies Latest reply on Nov 23, 2012 4:42 AM by IGorbatovsky

    Standby v$archived_log sequecne#


      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';


      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