| Corrupted File-Rollback segment [message #63233] |
Mon, 20 September 2004 18:06  |
Benny
Messages: 8
Registered: March 2002
|
Junior Member |
|
|
Hello,
I have the following problem need to be fixed. Hope someone can help. The data file is associated with rollback segment datafile and I found that it causes my RB7 rollback segment failed to be taken offline and be deleted.
ORA-00604
ORA-01578 ORACLE data block corrupted (file #3, block #575)
ORA-01110 data file : 'EORANTDATABASERBS1ORCL.ORA.' process stopped.
ORA-01578 ORACLE data block corrupted (file # string, block # string)
I don't have a very good backup at moment. I always do export as an option to backup.
Hope you can help me.
|
|
|
|
| Re: Corrupted File-Rollback segment [message #63251 is a reply to message #63233] |
Wed, 22 September 2004 12:04  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
I believe you can drop entire datafile where corrupted rollback segment is located in.
And recreate new tablespace/datafile and new rollback segments.
You can try
alter tablespace NAME offline
drop tablespace name including contents and datafiles
cascade constraints
Of course, you first must asure that only rollback segments are located in that tablespace, if not, you will be loosing important DATA !!!!
Export/import backups is not a desired backup policy. I think it is a complementary backup policy if you already have a strong backup procedures.
Hope it helps, let me know if you have further questions.
www.consultoria-oracle.com
Remote DBA for hire.
|
|
|
|
| Re: Corrupted File-Rollback segment [message #63260 is a reply to message #63251] |
Wed, 22 September 2004 22:24 |
Benny
Messages: 8
Registered: March 2002
|
Junior Member |
|
|
Hi,
Tks for the reply but actually tried. Situation is like this:
1. This is Oracle 8.0.6
2. I believe the datafile is corrupted and the
corrupted location is at my rollback segment "RB7".
3. It always shows that it is online, while trying to put it offline shows no error.
4. When trying to remove "RB7", it says its not available
5. Yet, when trying to put the whole tablespace "Rollback_data" offline, it says "RB7" is still active. Thus you can't remove a online tablespace.
6. Tried to add the undocumented line into my init.ora
_corrupted_rollback_segments=(rb1,rb2,...)
_offline_rollback_segment=(rb1,rb2,..)
but "_offline_rollback_segment=(rb1,rb2,..)" will cause error at start up.
Any idea ?
|
|
|
|
| extent allocation to the segment [message #63263 is a reply to message #63251] |
Thu, 23 September 2004 01:17 |
Kumar
Messages: 115
Registered: December 1998
|
Senior Member |
|
|
Hi
i want to know whether for a single table segment can database will allocate a extents from multiple datafiles of same tablespace where table is created...
or
a single extent, will it allocate from multiple
datafiles
Regards
kumar
|
|
|
|
| Re: extent allocation to the segment [message #63268 is a reply to message #63263] |
Thu, 23 September 2004 06:10 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Let's say your table is made of 10 extents.
Oracle can allocate those extents anywhere within any datafile that belongs to the tablespace where table was created in.
But ONE extent cannot be allocated in datafile1 and splitted into pieces and the remaining pieces allocated let's say in datafile2 or datafile3.
Hope this helps.
Regards.
|
|
|
|
| Re: Corrupted File-Rollback segment [message #63271 is a reply to message #63260] |
Thu, 23 September 2004 06:32 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
My fiend, you shouldn't do that.
Undocumented paramter _corrupted_rollback_segments
will require for you to re-create the whole database.
I had a similar problem few years agos, i cut the following from email i was sent by Oracle Support:
WARNING -- PLEASE NOTE
------------------------
The steps outlined are only to be used with the assistance of Oracle Worldwide Support. Included (in step 6) is a parameter _corrupted_rollback_segments that will require that you rebuild your database. Please explore all other options before using this parameter.
This recovery situation requires extra caution. Please call Oracle Customer Support if you have any questions or need any assistance.
-----------------------
What is the situation right now?, is db available?
Can you start/shutdown db in clean mode?
|
|
|
|
| Re: Corrupted File-Rollback segment [message #63280 is a reply to message #63271] |
Thu, 23 September 2004 17:51 |
Benny
Messages: 8
Registered: March 2002
|
Junior Member |
|
|
Tks for the advice.
Well I can start/shutdown db in clean mode. It's just
that some SQL couldn't run on this db anymore. It shows
ORA-00604 error occured at recursive SQL level 1
ORA-01578 ORACLE data block corrupted (file #3, block #575)
ORA-01110 data file : 'EORANTDATABASERBS1ORCL.ORA.' process stopped.
ORA-01578 ORACLE data block corrupted (file # string, block # string)
|
|
|
|
| Re: Corrupted File-Rollback segment [message #63292 is a reply to message #63280] |
Fri, 24 September 2004 05:36 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Ok.
do you still have parameter _corrupted_rollback_segments in your init.ora file?
please remove and try to follow procedure below:
1. shutdown normal or immediate your db
2. STARTUP RESTRICT MOUNT
3. ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE DROP;
4. ALTER DATABASE OPEN
if everything is fine, then
DROP TABLESPACE
INCLUDING
CONTENTS;
drop tablespace where your corrupted RS was
was allocated.
recreate the tablespace and rollback segments
ALTER SYSTEM DISABLE RESTRICTED SESSION;
If you still have problems or any doubt, feel free to email me to croca@ciudad.com.ar
Best luck.
|
|
|
|
| Re: Corrupted File-Rollback segment [message #63329 is a reply to message #63292] |
Mon, 27 September 2004 18:38 |
Benny
Messages: 8
Registered: March 2002
|
Junior Member |
|
|
Tks for the advice,tried but failed.
When I issue
alter database datafile "E:ORANTDATABASERBS1ORCL.ORA" OFFLINE DROP
when "E:ORANTDATABASERBS1ORCL.ORA" is exactly the datafile name, it responses
ORA-02236: invalid file name
Don't know what is the problem. Help!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
