Data block corruption cleared with alter system flush buffer_cache

This page has been moved to http://andrewfraserdba.com/?p=35

Advertisements

2 Responses to “Data block corruption cleared with alter system flush buffer_cache”

  1. Lutz Hartmann Says:

    Hi Anrew,
    it is always a good idea to check proactively for corrupt block (both physical & logical corruption) with RMAN.
    Pls see my post about it:
    http://sysdba.wordpress.com/2006/04/05/how-to-check-for-and-repair-block-corruption-with-rman-in-oracle-9i-and-oracle-10g/

    =;-)
    Lutz

  2. Lutz Hartmann Says:

    Hi Andrew,
    this is very interesting. I had a similar efect at a customer’s site recently with 10gR2 where I encountered an object that “didi not exist any more”.
    It was possible to describe it but a SELECT COUNT(*) returned an ORA-600.
    There were no extents in DBA_EXTENTS and it was not possible to DROP it: also ORA-600.

    Since my customer did not use RMAN we ended up with a full export except this one object and full import into a new DB.
    Obviousely the Data Dictionary was corrupted.

    I guess it’s a BUG!
    Or is it a feature?
    =;-)
    Lutz

Leave a Reply

Please log in using one of these methods to post your comment:

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


%d bloggers like this: