Home » RDBMS Server » Server Administration » data block corruption
data block corruption [message #61298] Tue, 13 April 2004 05:57 Go to next message
Tammy
Messages: 6
Registered: March 2001
Junior Member
-

When i checked on file number and the data block i found that that the file belongs to temporary tablespace . I get data block corrution error quiet often and all is for temp tablepace data file .

I thought to create another tablepace and assign to the user but for some time I assigned data tablepace as TEMP but it started giving me data block corruption error there too .

please suggest .
-

Report message to a moderator

Re: data block corruption [message #61300 is a reply to message #61298] Tue, 13 April 2004 08:26 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Are these tablespaces located on the same physical device? What type of errors ? Do you have access to Metalink ? there's an excellent article that talks about dealing with block corruption issues.

-Thiru

Report message to a moderator

Re: data block corruption [message #61306 is a reply to message #61300] Tue, 13 April 2004 10:03 Go to previous messageGo to next message
Tammy
Messages: 6
Registered: March 2001
Junior Member
Yes i do have access to metalink but could find which can tell me what to do in this situation.

I get data block corruption error with data file id and block id
when i look for segemnt there is no segment as the file 3 is a temporary tablespace data file .

Any suggestion ...

Report message to a moderator

Re: data block corruption [message #61307 is a reply to message #61306] Tue, 13 April 2004 11:00 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
See metalink notes 28814.1 , 77587.1 ,47955.1 .

Check with your Sysadmin to see if there are any disk corruption errors/messages.

Report message to a moderator

Re: data block corruption [message #61308 is a reply to message #61307] Tue, 13 April 2004 11:12 Go to previous messageGo to next message
Tammy
Messages: 6
Registered: March 2001
Junior Member
Can't you give me the solution may be possible casue instead of wasting my time here ...
Send me the link pls ..

Report message to a moderator

Re: data block corruption [message #61309 is a reply to message #61308] Tue, 13 April 2004 11:20 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
and stop wasting my time here.

Report message to a moderator

Re: data block corruption [message #61312 is a reply to message #61308] Tue, 13 April 2004 12:53 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Tammy, you are the one that's wasting everybody's time. If you don't want to be helped, please don't post your messages here. On the other hand, you will do well if you take Thiru advice seriously!

Best regards.

Frank

Report message to a moderator

Re: data block corruption [message #61334 is a reply to message #61298] Thu, 15 April 2004 05:38 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Tammy i suggest you to create a different temporary tablepspace and assign to the user .
I hope things will work out for you

Report message to a moderator

Previous Topic: Oracle startup problem
Next Topic: Re: data block corruption
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:42:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.