| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: rbs oracle data block corrupted
Atul,
Using "_OFFLINE_ROLLBACK_SEGMENTS" or "_CORRUPTED_ROLLBACK_SEGMENTS" might allow you to open the database, but there is an almost absolute certainty that you will hopelessly corrupt the data in the database in doing so. So this is not a solution, this is the absolute very LAST resort.
Instead, using these parameters usually means that you will be initiating a complete dump all of the data out of this database in order to load it into a "fresh" new uncorrupted one. Please do NOT consider using these parameters unless you've exhausted all other possibilities, and absolutely do NOT use them without logging a SEV-1 TAR and having an Oracle Support analyst on the phone throughout.
The danger of these parameters is that just about everyone has heard about them, but very few clearly understand how they work and the implications. Roughly put, the "_OFFLINE_ROLLBACK_SEGMENTS" parameter means that Oracle will attempt to determine whether the transaction has been committed or rolled back. If it can, it will put things right. If it can't, Oracle will just simply commit the transaction. Of course, it may have been that the transaction was never committed, thus corruption. Roughly, the "_CORRUPTED_ROLLBACK_SEGMENTS" parameter means that the rollback segment in question is hopeless, and Oracle will simply commit any uncommitted transaction that were using it. Again, this is very scary...
---
The best solution to data block corruption?
Data block corruption should first be treated exactly like media failure. That is, exactly like a failed disk drive. Restore an older copy of the datafile from a backup that occurred prior to the detection of the corruption, and recover forward until a complete recovery has been performed.
But first, before doing even that, please verify that the database block indicated is really corrupt. The ALTER SYSTEM DUMP DATAFILE <file#> BLOCK <block#> command will make a symbolic dump of the block to a ".trc" file in your USER_DUMP_DEST directory. The error message has the "file#" and "block#" values in it, so please use those then examine the resulting ".trc" file. If it truly is corrupt, there will some obvious indication the ".trc" file (i.e. it'll say "corrupted").
Then, please backup the datafile in question before restoring over it, just out of caution. Or, if you know how, rename the datafile and restore it from backup to the new location. Either way, don't wipe out the datafile with the corruption if you can help it...
Hope this helps...
-Tim
In Init.ora there is some setting to ignore using ROLLBACK Segments. Talk to Oracle support and try that.
Hi,
which version of Oracle are you using ? what are the all error messages ?
regards...
Atul Kumar Srivastav wrote:
Hi All !
We have one problem.
We can mount the database but not able to open it.
It gives following error while opening:
One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment)
How can i repair this corruption?
Atul
--
Danisment Gazi Unal
http://www.ubTools.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: Tim_at_SageLogix.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Jun 29 2002 - 21:33:17 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |