Data corruption
Did a import of rman recovery catalog from the old recovery catalog database(10.2.0.4) and did a checker run on dictionary on the new(11.2.0.1)
I get errors like this one:
SQL dictionary health check: foreign key file# not found in file$ 3 on object TAB$ failed Critical Damaged rowid is AAAAACAABAAAWU7AAI - description: Object RCAT_PDM.FB is referenced
SQL> select rowid,OBJ#,DATAOBJ#,TS#,FILE# from TAB$ where rowid ='AAAAACAABAAAWU7AAI';
ROWID OBJ# DATAOBJ# TS# FILE#
------------------ ---------- ---------- ---------- ----------
AAAAACAABAAAWU7AAI 105931 105931 8 1024
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where OBJECT_ID=105931; OWNER ------------------------------ OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE ------------------- RCAT_PDM FB TABLE SQL> select rowid,OBJ#,DATAOBJ#,TS#,FILE# from TAB$ where file#=3; no rows selected I found doucument 786658.1, but not sure what to do about it. The recovery catalog works just fine(crosschecking,listing,repoting, new backup gets addded) Just ignore the checker report?0