Error in alert logfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Error in alert logfile

  1. #1
    Join Date
    Nov 2008
    Posts
    30

    Error in alert logfile

    Hi All,
    when checking my alert logfile i saw this errors

    ORA-00313: open failed for members of log group 5 of thread 1
    ORA-00312: online log 5 thread 1: '/data/m4rep/system2/m4rep_redo_05b.rdo'
    ORA-27037: unable to obtain file status

    A trace file is also mentioned with that.When i checked the tracefile i saw these errors

    HP-UX Error: 2: No such file or directory
    Additional information: 3
    ORA-00312: online log 2 thread 1: '/data/m4rep/system/m4rep_redo_02a.rdo'
    ORA-27037: unable to obtain file status
    HP-UX Error: 2: No such file or directory
    Additional information: 3
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: '/data/m4rep/system2/m4rep_redo_03b.rdo'
    ORA-27037: unable to obtain file status
    HP-UX Error: 2: No such file or directory
    Additional information: 3
    ORA-00312: online log 3 thread 1: '/data/m4rep/system/m4rep_redo_03a.rdo'
    ORA-27037: unable to obtain file status
    HP-UX Error: 2: No such file or directory
    Additional information: 3
    ORA-00313: open failed for members of log group 4 of thread 1
    ORA-00312: online log 4 thread 1: '/data/m4rep/system2/m4rep_redo_04b.rdo'
    ORA-27037: unable to obtain file status
    HP-UX Error: 2: No such file or directory
    Additional information: 3
    ORA-00312: online log 4 thread 1: '/data/m4rep/system/m4rep_redo_04a.rdo'
    ORA-27037: unable to obtain file status
    HP-UX Error: 2: No such file or directory



    I thought that the problem might be with the redo logfiles and checked the status of the redo file.All are in online and working fine.
    Can anyone please tell me why i got this error in alertlogfile???Whether my tracing is correct?
    LittleAngel
    DBA-SQL,Oracle

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Look at this...

    ORA-00312: online log 3 thread 1: '/data/m4rep/system2/m4rep_redo_03b.rdo'
    ORA-27037: unable to obtain file status
    HP-UX Error: 2: No such file or directory


    Operating system cannot see the file.

    Either file is not there or you have a privileges issue.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2008
    Posts
    30
    Hi Paul,
    Thanks for your immediate reply.
    I can see the status of the logfile in online.And i can also see the file in the location.
    LittleAngel
    DBA-SQL,Oracle

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Well... operating system cannot see it.

    Log into the box using the oracle account then do...

    ls -ltr /data/m4rep/system2/m4rep_redo_03b.rdo

    ... is the file listed?

    I would ask the systems guy to check on their end anyway.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Nov 2008
    Posts
    30
    Hi Paul,
    I did what you said.The file is listed.Still there remains any problem with the files?
    LittleAngel
    DBA-SQL,Oracle

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Interesting.

    If you are getting these error messages logged in alertlog it means Operating System is telling Oracle it can't see the affected files.

    Just to be sure:

    a) Is affected database up-and-running?
    b) Are you sure entries on alertlog are from today?
    c) Are you sure you are looking at the right database, right alertlog?

    Since this is an O/S originated error I would report the issue to Systems team letting them know...

    1- O/S error which is: HP-UX Error: 2: No such file or directory
    2- List of affected files: /data/m4rep/system2/m4rep_redo_03b.rdo , etc.
    3- Date/Time of the error/s

    If errors keep comming into alertlog and Systems team is not responsive I would escalate.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Nov 2008
    Posts
    30
    Yes the database is up and running fine..
    I'm checking the correct database and correct logfile.
    Yes,this alert date is correct.

    I suppose cloning will haapen daily.Whether while opening the database it might faced this error.later then it might be resolved.[Hoping so]..
    LittleAngel
    DBA-SQL,Oracle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width