Clear the V$Database_block_corruption view


learning to know, learning to do, learning to live together and learning to be

In 10.2.0.4, the v$database_block_corruption view is based on v$copy_corruption and v$backup_corruption.
The rows for dropped datafile doesn’t go away until the datafile# is reused by database and a backup of that file# is taken.

This issue was fixed in 11g.

To workaround the problem in 10.2.0.4, you will have to clear the v$backup_corruption and v$copy_corruption view on target database.

SQL> execute dbms_backup_restore.resetCfileSection(17); /** clear v$backup_corruption
SQL> execute dbms_backup_restore.resetCfileSection(18); /**clear v$copy_corruption

(Oracle Metalink)

View original post