• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

how to recover - corrupted "undotbs01.dbf " ?

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
"rohith rs",
Please check your private messages.
-Ben
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
"rohith",
Please check your private messages, again.
-Ben
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
"rohithrs",
Please check your private messages.
-Ben
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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......
 
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
straws are for suckers. tiny ads are for attractive people.
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic