Re: Identifying the content of a corrupted block in system tablespace

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: vlado@xxxxxxxxxx
  • Date: Fri, 07 Jan 2005 03:20:37 +0000

On 01/06/2005 09:23:33 PM, Vlado Barun wrote:

> BTW, this is 8.0.6, they identified this problem 3 months ago in =20
> their
> Peoplesoft application, and of course they don't have a good backup
> from
> which to recover...

They can try restarting and hope that the corruption is only in =20
software. If it isn't and given that it is a dictionary table that is =20
corrupt, they cannot really trust DBMS_REPAIR, even if they had it, =20
which they do not, because of the version. That leaves recovery as the =20
only option. If they don't have any backups, they are, and this is a =20
scientific term, royally screwed. The best solution for them is to rent
the movie "Deliverance" and start squealing....

Mladen Gogala
Oracle DBA


Other related posts: