Our SAN was getting low on space (1.8Gb left or so) and we started getting msgs in the alert log like
ORA-3297 signalled during: ALTER DATABASE DATAFILE '/u02/oradata/dev/claims_m...
I wasn't able to find out what these error msgs actually meant, but I think I know now. We took a cold backup, extended the amount of space available on the SAN, and restarted the database. When it came up, it signalled that there were about 70 corrupt blocks, which we found after running
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
and then
SQL> select *
2 from v$database_block_corruption;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
1 63550 1 0 CHECKSUM
2 31878 1 0 CHECKSUM
2 91205 1 0 FRACTURED
...
So the sol'n on metalink is to export the problem objects and then import them, but I don't know how to map the BLOCK# to the object it belongs to. Could someone help me with that query?
-Thanks
Chuck