Home » Other » General » ORA-01110: data file 2 error in database (oracle 10g )
ORA-01110: data file 2 error in database [message #555012] Mon, 21 May 2012 00:16 Go to next message
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 Go to previous messageGo to next message
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
Re: ORA-01110: data file 2 error in database [message #555031 is a reply to message #555012] Mon, 21 May 2012 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Also ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can read this article: Troubleshooting Internal Errors.

Regards
Michel
Re: ORA-01110: data file 2 error in database [message #555079 is a reply to message #555031] Mon, 21 May 2012 04:27 Go to previous message
nilesh_pawaskar
Messages: 16
Registered: April 2012
Location: Mumbai
Junior Member
Dear all,

As per seniors decision we have recoverd that database from y'days hotbackup
thank you for your immediate help.
Previous Topic: ER Diagram
Next Topic: (Possibly OT) an Oracle script manager for Linux?
Goto Forum:
  


Current Time: Tue Nov 26 04:11:09 CST 2024