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....
--=20
Mladen Gogala
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
