Home > IT Answers > DataCenter > Oracle fails due to disk partition is full. Data now is corrupted.
Mariodlg
2,790 pts.
 Oracle fails due to disk partition is full. Data now is corrupted.
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
Hi all, I have a big trouble with one application that is working in a wrong way due to Oracle failure. Oracle is running on AIX. I just have access to see the disk partitions on the server with df command but I have no access to see Oracle logs. I can see that one of the system partitions is almost full, with 99% of used space. Oracle is reporting a corrupted datafile and that is the reason of why my program is working bad. The principal oracle error is this: ORA-01578: ORACLE data block corrupted (file # 60, block # 35052) ORA-01110: data file 60: '/oradata/XXXXXX03.dbf The people who manage Oracle doesn't have enought knowledge to do something about it and I don't have access (nor knowledge) to help them. So I asking you for some tips of what to do in this case with Oracle. Any suggestions will be appreciated!

Software/Hardware used:
Oracle 9i, AIX server, Java language 1.5
ASKED: May 25, 2011  5:06 PM
UPDATED: May 26, 2011  1:50 AM
RELATED QUESTIONS
Answer Wiki:
I've been lucky and not hit that error. I would take a look at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm
Last Wiki Answer Submitted:  May 25, 2011  11:19 pm  by  orangehat   1,445 pts.
All Answer Wiki Contributors:  orangehat   1,445 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thank you Orangehat, I will review this information.

Regards

Mariodlg
 2,790 pts.