Home » RDBMS Server » Backup & Recovery » backup issue (oracle 9.2.0 on HP_UX)
backup issue [message #329871] Thu, 26 June 2008 20:02 Go to next message
mbabu2
Messages: 1
Registered: June 2008
Junior Member
am getting below error message from backups

ORA-19501: read error on file "/u05/oradata/SABPRD/tools02.dbf", blockno 172481 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 5: I/O error
Additional information: 172481

Please let us know how to resolve this issue. Very urgent.

when i run the dbv command it failed with below error

DBVERIFY - Verification starting : FILE = /u05/oradata/SABPRD/tools02.dbf

DBV-00102: File I/O error on FILE (/u05/oradata/SABPRD/tools02.dbf) during verification read operation (-2)

Report message to a moderator

Re: backup issue [message #329872 is a reply to message #329871] Thu, 26 June 2008 20:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Let's review

You don't bother to read or follow Posting Guidelines
http://www.orafaq.com/forum/t/88153/0/

You are incapable or unwilling to use GOOGLE to learn about this
>HP-UX Error: 5: I/O error
>Additional information: 172481

http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1214528699667+28353475&threadId=220522

>Please let us know how to resolve this issue. Very urgent.
Nobody here owes you any response; timely or otherwise!

You might find interesting details in /var/log/messages

By the way, I hope you have good backups & a documented DB restoration procedure

You're On Your Own (YOYO)!

[Updated on: Thu, 26 June 2008 20:34] by Moderator

Report message to a moderator

Re: backup issue [message #424423 is a reply to message #329871] Fri, 02 October 2009 05:14 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
It might be the problem of that particular file.

Or the file system is 100% full.

Please correct me.

Thanks,
Afroze.

Report message to a moderator

Re: backup issue [message #424427 is a reply to message #424423] Fri, 02 October 2009 05:45 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Very good answer.

Regards
Michel

Report message to a moderator

Previous Topic: Alter Database Begin backup flow (merged)
Next Topic: How to Export only selected type of objects(i.e. procedure) from oracle database(schema)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 17:17:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.