View V$HM_RUN on Standby Database Shows Failures

(Doc ID 2254780.1)

Last updated on SEPTEMBER 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

Oracle Data Guard 12.1 environment where primary and physical standby databases are synchronized.

V$HM_RUN check on the primary database doesn't returned any issues.

V$HM_RUN check on the physical standby database shows failures:

select * from V$HM_RUN;

Basic Run Information
Run Name : HM_RUN_9341
Run Id : 9341
Check Name : DB Structure Integrity Check
Mode : REACTIVE
Status : COMPLETED
Start Time : 2017-03-27 11:05:29.065000 +03:00
End Time : 2017-03-27 11:06:10.966000 +03:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0

Input Paramters for the Run
Run Findings And Recommendations
Finding
Finding Name : Datafiles are inconsistent
Finding ID : 9342
Type : FAILURE
Status : CLOSED
Priority : HIGH
Message : Datafiles are mutually inconsistent
Message : Database may not be able to open

Further checks on the physical standby database:

RMAN> list failure; shows no failures.

RMAN> validate database; shows no failures.

ADRCI shows incidents.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms