4 Replies Latest reply on Dec 3, 2009 6:52 AM by 291647

    ORA-00394: online log reused while attempting to archive it

    291647
      Hello Gurus,

      We found the below text in our DEV alertlog file for SAP system:

      Wed Dec 2 12:09:49 2009
      Errors in file /oracle/DEV/saptrace/background/dev_arc1_999474.trc:
      ORA-00394: online log reused while attempting to archive it
      ORA-00312: online log 2 thread 1: '/oracle/DEV/mirrlogB/log_g12m2.dbf'
      ORA-00312: online log 2 thread 1: '/oracle/DEV/origlogB/log_g12m1.dbf'
      ARC1: All Archive destinations made inactive due to error 394
      Wed Dec 2 12:09:49 2009
      ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/DEV/oraarch/DEVarch1_11_703790173.dbf' (error 394)
      (DEV)


      Can you please suggest a solution to get back the system to normal.
      Oracle database is on 10.2.02 and OS is AIX.

      regards
      Sharath.