4 Replies Latest reply on Jan 16, 2009 8:01 PM by 400137

    redo error  in window

    592815
      Hi Experts,

      we use oracle 10GR2 in 32 bit window.

      I got an error mesage as
      ~Errors in file d:\oracle\product\10.2.0\admin\sale\bdump\sale_arc1_1980.trc:~ORA-16038: log 11 sequence# 15078 cannot be archived~ORA-00333: redo log read error block count~ORA-00312: online log 11 thread 1: 'G:\ORACLE\ORADATA\SALE\REDO11.LOG'~ORA-00312: online log 11 thread 1: 'G:\ORACLE\ORADATA\SALE\REDO11_MIRROR.LOG'~

      What do i need to do?
      I checked redo group 11 as inactive status and archived as yes.
      Under thsi condition, doi need to force checkpoint and switch logfile?
      Actually, it auto switch to other redo group before i saw message.
      Any suggestion?

      Thanks,
      JIm
        • 1. Re: redo error  in window
          283014
          A redo log read error sounds scary.
          The error message posted tells you where to look for more information - there is a trace file to examine:
          d:\oracle\product\10.2.0\admin\sale\bdump\sale_arc1_1980.trc

          If this file does not help you to identify the problem, post the messages here and we'll see if we can help or if you need to contact Oracle Support.
          • 2. Re: redo error  in window
            592815
            *** 2009-01-16 12:25:45.160
            ORA-00333: redo log read error block 16385 count 2048
            *** 2009-01-16 12:25:45.160 62692 kcrr.c
            ARC1: All Archive destinations made inactive due to error 333
            *** 2009-01-16 12:25:45.160 60970 kcrr.c
            kcrrfail: dest:1 err:333 force:0 blast:1
            *** 2009-01-16 12:25:45.426 21373 kcrr.c
            ORA-16038: log 11 sequence# 15078 cannot be archived
            ORA-00333: redo log read error block count
            ORA-00312: online log 11 thread 1: 'G:\ORACLE\ORADATA\SALE\REDO11.LOG'
            ORA-00312: online log 11 thread 1: 'G:\ORACLE\ORADATA\SALE\REDO11_MIRROR.LOG'
            *** 2009-01-16 12:31:03.785
            *** 2009-01-16 12:31:03.785 21420 kcrr.c


            Thanks for your help.
            All message is in there. It seems that redo 11 could not archived. Crash? But I saw this redo file is wroking on other switch?

            I check alert. after this redo message there are other message as
            Fri Jan 16 12:33:18 2009
            Errors in file d:\oracle\product\10.2.0\admin\sale\bdump\sale_arc0_1984.trc:
            ORA-00333: redo log read error block 16385 count 2048
            ORA-00312: online log 10 thread 1: 'G:\ORACLE\ORADATA\SALE\REDO10.LOG'
            ORA-27091: unable to queue I/O
            ORA-27070: async read/write failed
            OSD-04006: ReadFile() failure, unable to read from file
            O/S-Error: (OS 1450) Insufficient system resources exist to complete the requested service.

            We talk with oracle support and feedback as OS issue.
            I asked os person for search in past time. sys admin do not find issue. we reboot server 3 times.
            However today I get this message after 2 days.


            What do I ned todo?

            Thanks,
            Jim
            • 3. Re: redo error  in window
              Anand...
              Hi..

              As you are getting O/S-Error: (OS 1450) Insufficient system resources exist to complete the requested service , it seems to be a OS issue.
              Refer to [http://support.microsoft.com/kb/q236964/]


              HTH
              Anand
              • 4. Re: redo error  in window
                400137
                user589812 wrote:
                ORA-27091: unable to queue I/O
                ORA-27070: async read/write failed
                OSD-04006: ReadFile() failure, unable to read from file
                <b>O/S-Error: (OS 1450) Insufficient system resources exist to complete the requested service.</b>
                Check your system resources.

                Strange enough, I had similar issue couple of days ago and the problem was due to very high CPU utilization by some non-oracle processes.

                ...it was on UNIX box though.

                Edited by: tekicora on Jan 16, 2009 2:01 PM