[StandbyDB] shows logs in double, one applied, one not.

[pivert]

I have multiple old logs that are always showed as non applied. (My actual sequence# is 11796.) The standby db is running fine.

If I look closer, in fact I have all theses logs in double, with the same name. One applied, and one not. (See the second query.)

Theses logs sequence# should match when I had to rebuild the standby database. (copy datafiles from primary, create standby controlfile,...)

How can I solve this problem ?

Thanks !

SQL> select name from v$archived_log where applied='NO';

NAME
--------------------------------------------------------------------------------
/db/app/oracle/oradata/kosmodb/archive/1_9976.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9975.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9978.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9977.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9980.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9979.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9982.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9981.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9983.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9984.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9985.dbf

NAME
--------------------------------------------------------------------------------
/db/app/oracle/oradata/kosmodb/archive/1_9986.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9987.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9988.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9989.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9990.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9992.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9991.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9994.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9993.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9996.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9995.dbf

NAME
--------------------------------------------------------------------------------
/db/app/oracle/oradata/kosmodb/archive/1_9998.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9997.dbf
/db/app/oracle/oradata/kosmodb/archive/1_10000.dbf
/db/app/oracle/oradata/kosmodb/archive/1_9999.dbf

26 rows selected.

SQL>


SQL> select name,applied from v$archived_log where name like '%1_999_.dbf';

NAME APP
-------------------------------------------------- ---
/db/app/oracle/oradata/kosmodb/archive/1_9990.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9992.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9991.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9994.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9993.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9996.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9995.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9998.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9997.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9999.dbf NO
/db/app/oracle/oradata/kosmodb/archive/1_9990.dbf YES

NAME APP
-------------------------------------------------- ---
/db/app/oracle/oradata/kosmodb/archive/1_9991.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9992.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9994.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9993.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9995.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9996.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9997.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9998.dbf YES
/db/app/oracle/oradata/kosmodb/archive/1_9999.dbf YES

20 rows selected.

SQL>