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
posted
0
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
posted
0
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
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: how to recover - corrupted "undotbs01.dbf " ?
0
