Home » RDBMS Server » Server Administration » datablock corruption, when you get time
datablock corruption, when you get time [message #254251] Thu, 26 July 2007 05:21 Go to next message
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 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

No.
Re: datablock corruption urgent plz.... [message #254269 is a reply to message #254251] Thu, 26 July 2007 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who knows what happens on Windows when a disk is full?
Maybe yes, maybe no.
Logically no.

Regards
Michel
Re: datablock corruption urgent plz.... [message #254270 is a reply to message #254253] Thu, 26 July 2007 06:17 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Wow!!thanx. i scared a lot.....
Re: datablock corruption urgent plz.... [message #254274 is a reply to message #254269] Thu, 26 July 2007 06:22 Go to previous messageGo to next message
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?
Re: datablock corruption urgent plz.... [message #254277 is a reply to message #254274] Thu, 26 July 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it possible to corrupt a datafile header?

Yes.
Quote:
i have three datafiles if "may be yes" means all three datafiles would have been corrupted know?

Maybe 0, maybe 1, maybe all.
Use DBV to check your files.

Regards
Michel
Re: datablock corruption urgent plz.... [message #254284 is a reply to message #254277] Thu, 26 July 2007 06:31 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
But on monday and tuesday it is fine.
I connected through RMAN to that database.

Re: datablock corruption urgent plz.... [message #254289 is a reply to message #254284] Thu, 26 July 2007 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yesterday my car worked, today it does not start.

Regards
Michel
Re: datablock corruption [message #254293 is a reply to message #254289] Thu, 26 July 2007 06:40 Go to previous message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
its k. thanx michel.

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

Report message to a moderator

Previous Topic: UNDO size increasing at very high speed
Next Topic: Xmanager setup
Goto Forum:
  


Current Time: Sat Dec 10 04:53:08 CST 2016

Total time taken to generate the page: 0.06467 seconds