ORA-01110: data file 2 error in database [message #555012] |
Mon, 21 May 2012 00:16 |
|
nilesh_pawaskar
Messages: 16 Registered: April 2012 Location: Mumbai
|
Junior Member |
|
|
Dear all,
We are facing one issue in our production database as our database is not open in read write mode i have checked in alert log file it shown some error ,request you to kindly help
alert file error
Mon May 21 09:23:01 2012
Errors in file d:\oracle\product\10.2.0\admin\goa\bdump\orcl_p001_608.trc:
ORA-00600: internal error code, arguments: [3020], [2], [7797], [8396405], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 7797)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: 'E:\ORACLE\ORADATA\DATA\UNDOTBS01.DBF'
ORA-10560: block type 'KTU UNDO BLOCK'
|
|
|
Re: ORA-01110: data file 2 error in database [message #555013 is a reply to message #555012] |
Mon, 21 May 2012 00:19 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
bcm@bcm-laptop:~$ oerr ora 10560
10560, 00000, "block type '%s'"
// *Cause: Report block type for details of another error.
// *Action: See associated error message.
bcm@bcm-laptop:~$ oerr ora 1110
01110, 00000, "data file %s: '%s'"
// *Cause: Reporting file name for details of another error. The reported
// name can be of the old file if a data file move operation is
// in progress.
// *Action: See associated error message.
bcm@bcm-laptop:~$ oerr ora 10564
10564, 00000, "tablespace %s"
// *Cause: Report tablespace name for details of another error.
// *Action: See associated error message.
bcm@bcm-laptop:~$ oerr ora 10567
10567, 00000, "Redo is inconsistent with data block (file# %s, block# %s, file offset is %s bytes)"
// *Cause: There are two possible causes of this error: (1) A write issued
// by Oracle was lost by the underlying OS or storage system.
// (2) an Oracle internal error.
// *Action: Investigate why the error occurred and how important is the data
// block. Media and standby database recovery usually can continue
// if user allows recovery to corrupt this data block.
investigate OS error
|
|
|
|
|