Yesterday friend encountered a database failure case:
The 11.2.0.3 database crashed due to an ASM disk header block, and an error ORA-15196 occurred.
More detailed errors are as follows: Ora-15196:invalid ASM block Header [kfc.c:26076] [ENDIAN_KFBH] [256] [0!= 1]
Further inspection found that the Dataguard was also damaged. This is confusing to everyone, why is the primary and the repository corrupted at the same time?
Finally after careful examination found:
Is that the SA found a disk on the host is useless, the main standby has performed the Fdisk mkfs.
The final recovery benefits from the user's off-site disaster preparedness environment.
This case gives us the warning that:
1.DBA and SA enhanced communication is important
Lack of communication led to the disaster, SA's unauthorized operation is also contrary to safe operating procedures.
2. Disaster-tolerant environment critical moment can help
Backup, disaster-tolerant environment is the lifeblood of enterprise data security, to be prepared to sit back and relax