7 x 24 在线支持!
Oracle Database Block Corruption in ASM
we got Block corruption in the database and found the following alert log entry during that time.
we need to find why block corruption occur. what is the culprit OS/Storage/DB ?
ASM disk header corruption
Calling all ASM experts - we have the problem described in note 1487443.1 . I have a simple question, as follows:
what's the reason for Oracle ASM ORA-15196 if no OS/storage issues
we met several times ORA-15196 without any reason.
1) no error in OS message
2) no error on storage
ASM disk corrupted
I want to know if the diskgroup couldn't mount and the header of an asm disk corrupted (it is only my supposition), how should I deal with it? Will the data in the ASM disk lose?
Oracle ASM ORA-15196: invalid ASM block header [kfc.c:29416] [endian_kfbh] [287] [2147483648] [0 != 1]
6 instances fell down yesterday afternoon with a because ORA-00227: corrupt block detected.
Oracle ORA-1157 Troubleshooting
PURPOSE
This note is intended to list the common reasons and solutions for the ORA-1157 error.
SCOPE
How to Recover from a Lost or Deleted Oracle Datafile with Different Scenarios
PURPOSE
This article explains the various scenarios for ORA-01157 and how to avoid them.
SCOPE & APPLICATION
Recreating a missing Oracle datafile with no backups
GOAL
How to recreate a datafile that is missing at the operating system level. Missing/inaccessible files may be reported with one or more of these errors: