Oracle Database 12.1.0.2.0
Hi,
I am getting a datafile block corruption error for datafile 2
RMAN> list failure
2> ;
using target database control file instead of recovery catalog
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
21922 HIGH OPEN 30-OCT-17 Datafile 2: '/u01/oradata/DLP/datafile/LOB02.dbf' contains one or more corrupt blocks
RMAN> advise failure;
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
21922 HIGH OPEN 30-OCT-17 Datafile 2: '/u01/oradata/DLP/datafile/LOB02.dbf' contains one or more corrupt blocks
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
========================
1. No backup of block 4500 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption
2. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair
Optional Manual Actions
=======================
no manual actions available
Automated Repair Options
========================
no automatic repair options available
How will I know which object to drop and recreate?
Regards,
Joe