-
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
-
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.
-
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
-
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.
-
Hi Paul,
I did what you said.The file is listed.Still there remains any problem with the files?
LittleAngel
DBA-SQL,Oracle
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|