Out of Sync: Maddy's Blog

The qualification of Oracle 10gR2 on Solaris cluster on x64 platform has been completed.  Now that is really good news!  With this, Oracle 10gR2 is certified on all supported platforms of Cluster!

Today in my DB Admin II workshop, faced a rather strange behaviour which none of us had a clue about.  The environment was linux + 10.2.0.1 with normal fs based storeage (no ASM/RAW volumes).  We manually corrupted one of the dbf files using dd.

1.) Let's say the file# was 7 and block id# corrupted were 51,52,53,54. 

2.) Flushed buffer_cache

3.) Executed select statement on the table to confirm that there was corruption.

4.) used dbv file='<file>' blocksize=8192 and confirmed that the blocks from 51-54 were corrupted.

5.) Checked alert_log file and it showed only 53 and 54 as corrupted!

6.) Used RMAN> blockrecover datafile 7 block 53,54;  and recovered the blocks.

7.) issued the select statement and was surprised to find that it worked!!

8.) select file#,blockid from v$database_corruption_block to find that there were no more corrupted blocks!!

9.) Executed dbms_repair.check_object  ==>  reports block 51 alone as corrupted!

10.) Executed dbms_repair.fix_corrupt_blocks to fix 51 and re-executed dbms_repair.check_object ==> No corruptions!!!

 Now, this stumped my trainer as well who was forced to blush and left me wondering what the heck?

Finally!  Oracle RAC 9i/10g  is now officially certified with Solaris Cluster 3.2. The certification currently covers only SPARC platform (Solaris 9 and 10) and the x64 certification is on its way.