Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ora-01555 on 7.3.4.5

Re: ora-01555 on 7.3.4.5

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Sun, 25 Aug 2002 21:59:53 +0200
Message-ID: <akbcvs$h0b$1@news1.xs4all.nl>


Strange indead. My impression is that for some reason the select thinks it needs an older version of the block that must be in that rollback segment but is not anymore.
You are really sure that nobody is modifying the table during the selection in all ways you tried?
Is the database been stopped and started since the problem occurs? And V7.3 is no longer supported by Oracle so....

You could check if there are no block corruptions in 2 ways: a. analyze table X validate structure;
b. use the dbverify utility for every file the table and its indexes have extents in:
(I think its called "dbverf" or "dbverf73"on Windows NT).

      dbverf file=xxx.dbf blocksize=8192 or whatever blocksize your database uses.

If you find corrupt blocks, Oracle Support can give you special undocumented events to set in the init.ora to make an export that skips corrupt blocks, ofcourse loosing the rows that are in those blocks. That's why Oracle is very very carefull in giving this info, for obvious reasons. But I'am afraid you won't find corruptions. Good luck.

Martin Dohse <mdohse_at_web.de> schreef in berichtnieuws Xns9275D83829D8Bmdohsewebde_at_130.133.1.4...
| Hej all,
|
| a customer is running an ora 7.3.4.5 on windows nt. Since a few weeks
| they're working with an indexed table that is the more or less not
| accessable, e.g. no export, no select * etc. - every action is running
| into ora-01555 referencing always the same rbs.
|
| We tried to create a copy by create table as select, but that did not
| work.
|
| We deleted the rbs given in the error message - just to get the same
| message referencing the same old rbs.
|
| OSS sugested the typical way to handle ora-01555, but we think the table
| contains something like old snapshot data like having a system hang and
| incorrectly recovering after restart.
|
| We were able to find a few data blocks that are no longer accessable, so
| we tried to exclude them for a next create table attempt, but again it
| did not work.
|
| We think best way should be to write an external prog to extract all
| data that can be accessed, but perhaps someone does have a better
| sugestion...
|
| Martin
|
|
Received on Sun Aug 25 2002 - 14:59:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US