Home » RDBMS Server » Server Administration » Corrupted Datafile Block
Corrupted Datafile Block [message #143662] Fri, 21 October 2005 06:52 Go to next message
himankar_das
Messages: 3
Registered: October 2005
Location: INDIA
Junior Member
We had encountered a corrupted data block problem for
a datafile. We could repair it by using old cold backup
files and archive log files and truncating certain
tables.

Is there any chance that the data once again getting
stored/saved in the same data block ?

If so, then is there any way to seal those corrupted
blocks in that datafile.

Report message to a moderator

Re: Corrupted Datafile Block [message #143665 is a reply to message #143662] Fri, 21 October 2005 06:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Block level corruptions are supposed to be dealt by OSS.
Raise a TAR.

Report message to a moderator

Re: Corrupted Datafile Block [message #143671 is a reply to message #143665] Fri, 21 October 2005 07:12 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And happen to have any RMAN backup?

Report message to a moderator

Previous Topic: application tuning
Next Topic: Archive Logs - Question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 12:21:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.