Home » Infrastructure » Linux » ORA-19502: write error on file (oracle 11.2.0.2.0 linux)
ORA-19502: write error on file [message #548912] Tue, 27 March 2012 02:23 Go to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member
I got an error while opening the database. I was exporting the database and it was not running so I stop that process and shut the db then it get hangs for 2 or 3 hrs so I drop the cmd shutdown abort after that error was coming of end of line communication channel. I tried so many things and then I use to recover database until cancel and open resetlogs but error coming:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-19502: write error on file
"/u03/oradata/DSSGD/flash_recovery_area/DSSGD/onlinelog/o1_mf_1_%u_.log", block
number 100353 (block size=512)
ORA-27072: File I/O error
Additional information: 4
Additional information: 100353
Additional information: 794112

Regards//Neha
Re: ORA-19502: write error on file [message #548915 is a reply to message #548912] Tue, 27 March 2012 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-27072: File I/O error
Additional information: 4
Additional information: 100353
Additional information: 794112


Oracle received an IO error from the OS.
Oracle is the victim not the culprit.
Investigate OS side (FS full?).

Regards
Michel
Re: ORA-19502: write error on file [message #548918 is a reply to message #548915] Tue, 27 March 2012 02:52 Go to previous messageGo to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member
Hi
This is error on logfile
what should be the option for resolving this error should I increase the space for sga or what?

//Neha
Re: ORA-19502: write error on file [message #548920 is a reply to message #548918] Tue, 27 March 2012 03:18 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The error is at OS side.

Quote:
Oracle is the victim not the culprit.


Regards
Michel
Previous Topic: OEM not working
Next Topic: telnet error
Goto Forum:
  


Current Time: Thu Apr 18 01:42:59 CDT 2024