Schedule job failure: ORA-48318

While running RMAN restore job it got stuck and alert log was showing  ORA-48318: ADR Relation [HM_FINDING] of version=3 cannot be supported.

Weird!!!

This problem has been identified and verified in an unpublished Bug  Usually the error is reported by Diagnosibility Framework after Downgrading from Release 11.2 to 11.1

After downgrading from Oracle Database release 11.2 to 11.1, the error ORA-48318 may occur in the alert log, or when using the ADRCI utility.

Errors in file /u01/app/oracle/prd/diag/rdbms/prd/prd/trace/prd_m000_22828.trc:

ORA-51106: check failed to complete due to an error.  See error below

ORA-48318: ADR Relation [HM_FINDING] of version=3 cannot be supported

Mon Oct 03 14:55:55 2011

Errors in file /u01/app/oracle/prd/diag/rdbms/prd/prd/trace/prd_m000_22987.trc:

ORA-51106: check failed to complete due to an error.  See error below

ORA-48318: ADR Relation [HM_FINDING] of version=3 cannot be supported

Mon Oct 03 15:40:56 2011

Solution:

The only options to fix the error is the following workaround:

1.    Determine the location of the ADR home:

    SQL> select value from v$diag_info where name = 'ADR Home';
    VALUE
    ------------------------------------------------------------------------------
   /u01/app/oracle/prd/diag/rdbms/prd/prd/trace

 

2. Shutdown the database instance

3. Remove the ADR home directory using OS utilities: It will be automatically recreated with the proper versions when the instance is restarted.