Database Backup and Recovery (MOSC)

MOSC Banner

Data corruption

edited Oct 28, 2010 7:55PM in Database Backup and Recovery (MOSC) 9 commentsAnswered ✓
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?  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center