ORA-15196: invalid ASM block header. Continued investigation.

Hey fellas. As you know from previous article, I’ve got the error around ASM block header. Which I also tried to solve with scrubbing mechanism which has appeared in 12c Oracle. You know this mechanism is working well, but only one’s you need to know, you must have at least one type of block (primary or mirror) in correct state, and then the scrubbing mechanism can afford to save your data. But not in my situation which I’ve described in previous article.

In a nut shell. I have two disk shelves with 15 disk by 4Tb each. And I want to create one big diskgroup which will have normal redundancy for database files, and backup files.

So I’ve created it. One diskgroup equal 60Tb size for database files, and backup files which will placed inside ADVM volume. And the problem has appeared only when I’ve tried to create backup through RMAN within one diskgroup. Again 🙂 If you will have TWO diskgroups, one for database files, and another with ADVM volume, and ACFS filesystem for backup files it would work well. But, if you will have ONE diskgroup for database files, and the same diskgroup for ADVM volume, and ACFS filesystem for backup files, you will stumble on the pitfall.

After couple weeks of investigations, and tests I’ve found the solution, which is easy. You just need to install Patch Set Update : 12.1.0.2.160119. In my environment I have this patches

Patch description: “Database Patch Set Update : 12.1.0.2.160119 (21948354)”
Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
Sub-patch 21359755; “Database Patch Set Update : 12.1.0.2.5 (21359755)”
Sub-patch 20831110; “Database Patch Set Update : 12.1.0.2.4 (20831110)”
Sub-patch 20299023; “Database Patch Set Update : 12.1.0.2.3 (20299023)”
Sub-patch 19769480; “Database Patch Set Update : 12.1.0.2.2 (19769480)”

Advertisements

One thought on “ORA-15196: invalid ASM block header. Continued investigation.

  1. Pingback: ASM data scrubbing for fixing ORA-15196: invalid ASM block header | Yet Another Oracle Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s