Oracle Data Block Corruption....(Rollback Segment)

greenspun.com : LUSENET : DBAzine : One Thread

Errors in file D:\Oracle\admin\bdump\SMON.TRC: ORA-01578: ORACLE data block corrupted (file # 27, block # 186716) ORA-01110: data file 27: 'D:\ORACLE\ORADATA\ROLLBACK1.ORA' View(dba_rollback_seg) status says partly available..... took this tablespace/segment offline and try to drop....but unsuccessful....Is there any way out?Will it Require to rebuild or recreate the instance?

-- Mukesh Moharir (mmoharir@jyotistructures.com), October 08, 2002

Moderation questions? read the FAQ