This discussion is archived
6 Replies Latest reply: Nov 22, 2012 8:42 PM by IGorbatovsky RSS

Standby v$archived_log sequecne#

user2015671 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points