2 Replies Latest reply: Dec 15, 2012 11:34 PM by 979666 RSS

    ORA-16038, ORA019504, ORA-00312

    979666
      Hi there, first of all, my apologies if the question I'm about to ask has been answered in other thread before. Kindly direct me to the thread it's similar.

      I'm currently using Oracle 9i installed on HP-UX. Before doing a reboot on the machine, there was an error from oracle like below:


      Database mounted.
      ORA-16038: log 3 sequence# 177448 cannot be archived
      ORA-19504: failed to create file ""
      ORA-00312: online log 3 thread 1: '/u00/oradata/ODSDWPD/t1_log3a.rdo'
      ORA-00312: online log 3 thread 1: '/u00/oradata/ODSDWPD/t1_log3b.rdo'

      After a system reboot, the system could not start up, both primary and alternate path could not boot.

      May I know what are the oracle errors above mean, and could it had led to a system boot-up to failed?

      Thanks and regards

      Edited by: 976663 on Dec 15, 2012 9:34 PM
        • 1. Re: ORA-16038, ORA019504, ORA-00312
          hitgon
          ORA-16038: log 3 sequence# 177448 cannot be archived
          http://www.bestremotedba.com/tag/ora-16038-log-s-sequence-s-cannot-be-archived/

          ORA-19504: failed to create file ""

          check that redo logs available in os/storage
          ls -ltr /u00/oradata/ODSDWPD/t1_log3b.rdo

          http://oraclespin.wordpress.com/2008/04/02/how-to-fix-online-redo-log-corruption/
          ORA-00312: online log 3 thread 1: '/u00/oradata/ODSDWPD/t1_log3a.rdo'
          ORA-00312: online log 3 thread 1: '/u00/oradata/ODSDWPD/t1_log3b.rdo'
          • 2. Re: ORA-16038, ORA019504, ORA-00312
            979666
            Hi hitgon,

            Thanks a lot for your reply. I will look into the reference.

            Thanks and best regards

            Edited by: 976663 on Dec 15, 2012 9:34 PM