ORA-01578: ORACLE data block corrupted / LOB issue
ORA-01578: ORACLE data block corrupted
Last week we went in serious problems when one of our datafiles have been corrupted when we had an outage of the Filesystem (SAN).
The database is huge and we run it NOARCHIVE MODE and weekly offline backup.
When database came up after filesystem outage. Media recovery was needed.
A 'recover database' was possible with the online redo logs.
Later we discovered that one of the tables had not been recovered. A CLOB column still had data-corruption ORA-01578.
This table has normal LOGGING option and I would have expectred that a recovery also covers LOB columns??
Last week we went in serious problems when one of our datafiles have been corrupted when we had an outage of the Filesystem (SAN).
The database is huge and we run it NOARCHIVE MODE and weekly offline backup.
When database came up after filesystem outage. Media recovery was needed.
A 'recover database' was possible with the online redo logs.
Later we discovered that one of the tables had not been recovered. A CLOB column still had data-corruption ORA-01578.
This table has normal LOGGING option and I would have expectred that a recovery also covers LOB columns??
0