Database Administration (MOSC)

MOSC Banner

ORA-01578: ORACLE data block corrupted in UNDO

edited May 17, 2011 5:15PM in Database Administration (MOSC) 6 commentsAnswered
Hello,

I am getting following error at database startup:(My database is on Windows Server)

----------------------------------------------------------------------

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 10 14:02:31 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> STARTUP;
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size                  2185160 bytes
Variable Size            1.0133E+10 bytes
Database Buffers         1.1207E+10 bytes
Redo Buffers               36151296 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01578: ORACLE data block corrupted (file # 3, block # 240)
ORA-01110: data file 3: 'G:\APP\ORACLE\ORADATA\ORUSX2\UNDOTBS01.DBF'
Process ID: 5972
Session ID: 234 Serial number: 3

Please help me to resolve this issue?

Thanks

Jitendra R. Desaria 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center