[StandbyDB] shows logs in double, one applied, one not.
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>