This discussion is archived
2 Replies Latest reply: Dec 15, 2012 9:34 PM by 979666 RSS

ORA-16038, ORA019504, ORA-00312

979666 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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