Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Oracle/OAS and the fly likes how to recover - corrupted Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "how to recover - corrupted "undotbs01.dbf " ?" Watch "how to recover - corrupted "undotbs01.dbf " ?" New topic
Author

how to recover - corrupted "undotbs01.dbf " ?

rohithrs
Greenhorn

Joined: Mar 11, 2008
Posts: 12
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

Joined: Dec 11, 2004
Posts: 13410

"rohith rs",
Please check your private messages.
-Ben


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

"rohith",
Please check your private messages, again.
-Ben
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

"rohithrs",
Please check your private messages.
-Ben
shinoj mohan
Greenhorn

Joined: Nov 29, 2008
Posts: 1
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

Joined: Oct 06, 2007
Posts: 338
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

Joined: Nov 10, 2009
Posts: 3
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

Joined: Nov 19, 2013
Posts: 1
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to recover - corrupted "undotbs01.dbf " ?