Friday, February 20, 2015

Oracle 11g R2 -- DBA_HIST_WR_CONTROL contains more than one entry


The DBA_HIST_WR_CONTROL view contains more than one rows. The DBID column has distinct values for each row.


It is OK to have multiple entries in DBA_HIST_WR_CONTROL as long as the DBIDs are different for each entry. The other DBIDs could be caused by RMAN duplicate/clone operations. 

Deleting these entries is not possible in a supported way.

No comments: