Oracle fails due to disk partition is full. Data now is corrupted.

2790 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mariodlg
    Thank you Orangehat, I will review this information. Regards
    2,790 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following