Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to recover - corrupted "undotbs01.dbf " ?

 
rohithrs
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle 10g installed in my Linux OS.

# su - oracle
# sqlplus log/logpwd as sysdba ;
// once above command entered

sql> startup;
.........
.........
database mounted;
//then its giving these error message
ora-01115 : IO error reading blick from file 2 (block # 2252)
ora-01110 : data file 2: '/u02/oradata/orcl/undotbs01.dbf'
ora-27072 : file I/O error
Linux error : 2: No such file or directory
Additional Info : 2251

sql> shutdown;
database not open

database unmounted:


how to solve these problem..... give me a solution
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
 
shinoj mohan
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Ben Souther:
"rohithrs",
Please check your private messages.
-Ben


i am having the same problem will you please help......
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by rohith rs:
Oracle 10g installed in my Linux OS.

# su - oracle
# sqlplus log/logpwd as sysdba ;
// once above command entered

sql> startup;
.........
.........
database mounted;
//then its giving these error message
ora-01115 : IO error reading blick from file 2 (block # 2252)
ora-01110 : data file 2: '/u02/oradata/orcl/undotbs01.dbf'
ora-27072 : file I/O error
Linux error : 2: No such file or directory
Additional Info : 2251

sql> shutdown;
database not open

database unmounted:


how to solve these problem..... give me a solution


is U02 mounted?
 
damian wood
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi folks, hope this message is not considered as spam because I suggest a good solution to the question, raised by rohithrs. I can recommend trying the sql server data file secondary restore program that automatically eliminates dbf errors. It is a good solution, if you experience any difficulties with dbx files. Hope this helps
 
jack adision
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle database corruption is very embarrassing for the user of this database because they are totally dependent on the database. There are many reasons of database corruption and by knowing that causes you can protect your database from corruption.
• Due to any virus attack. It can totally damage your database and make it inaccessible.
• Due to damage operating system database will get corrupted.
• If any hardware problem or malfunctioning are occurs in to the computer system then it will also corrupt your database.
• Improper shut down of the database when it is running.
• Database will also get corrupted due to the corruption of Media.

In manual process corrupted database can be repaired by applying lengthy commands and codes on the command prompt which is very difficult to remember for the normal user of computer. In Automatic process any one can repair and restore corrupted database easily because in this process database can be repaired by using any third party oracle database repair tool.

Kindly visit the give url to download oracle database

http://oracle.filerepairtool.net
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic