OraFAQ Forum: Server Administration » datablock corruption, when you get time

Home » RDBMS Server » Server Administration » datablock corruption, when you get time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datablock corruption, when you get time [message #254251]

Thu, 26 July 2007 05:21

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

hi,

OS:windowsNT
oracle:10.2

Last saturday while taking backup (export) via TOAD i got an error like "there is no enough space in the output dumpfile specified location (E drive)".
There is no enough space in the E: drive to a full DB backup so my export session terminated.

In that E: i have three datafiles.

My problem is, yesterday i cant start my database it gives error like
"cant read datafile header 13
I/O datablock corruption error" the datafile which is in the E drive is corrupted.

my question is, Did the export which i took last saturday caused this? plz give me some sugesstions. am in a critical situ...

Thanx...

Did everyone notice that I may be illiterate because I don't even know how to spell "please?"

[Updated on: Thu, 26 July 2007 07:58] by Moderator

Report message to a moderator

Re: datablock corruption urgent plz.... [message #254253 is a reply to message #254251]

Thu, 26 July 2007 05:27

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

No.

Report message to a moderator

Re: datablock corruption urgent plz.... [message #254269 is a reply to message #254251]

Thu, 26 July 2007 06:16

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Who knows what happens on Windows when a disk is full?
Maybe yes, maybe no.
Logically no.

Regards
Michel

Report message to a moderator

Re: datablock corruption urgent plz.... [message #254270 is a reply to message #254253]

Thu, 26 July 2007 06:17

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Wow!!thanx. i scared a lot.....

Report message to a moderator

Re: datablock corruption urgent plz.... [message #254274 is a reply to message #254269]

Thu, 26 July 2007 06:22

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

hi,

Is it possible to corrupt a datafile header?

In that folder i have three datafiles if "may be yes" means all
three datafiles would have been corrupted know?

Report message to a moderator