Re: Block corruption on Rollback Tablespace

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 26 Apr 2001 17:23:58 +0100
Message-ID: <988302288.21334.0.nnrp-07.c30bdde2@news.demon.co.uk>

There's a parameter "_corrupted_rollback_segments=r01" you could put in init.ora.

HOWEVER. There may be a way to fix this WITHOUT having to resort to such trickery, so I'd hang fire until the more experienced dba's can advise if I were you...

Obviously, if you did use it, you a) cold backup the whole thing first, b) remove the parameter afterwards, and c) don't blame me if it all goes wrong. ;-)

"FS" <axk_at_fernbach.com> wrote in message news:3AE81CBE.A9377C28_at_fernbach.com...
> Hello,
>
> an customer have Oracle 7.3.4.2 on windows nt.
> After restore an backup (fullbackup of datafiles)
> we have an problem with block corruption
> I verify that and see that is in rollback tablespace.
> I would recreate the rollback tablespace and try the
> following steps:
>
> - set rollback public segments offline and drop them - OK
> - there was 2 system rollback segments (1 in system tablespace and 1 in
> rollback tablespace)
> - when i try to set the rollback segment r01 (rbs tablespace) offline, i
> receive the error for block corruption
>
> Error:
> ORA-01578: ORACLE data block corrupted (file # 4, block # 263848)
> ORA-01110: data file 4: 'H:\FERNBACH\DATABASE\RBS01.DBF'
>
>
> The Database from our customer is not in archive log!!!
>
> What can i do?
>
> I hope for an fast answer because its an production problem.
>
> Regards
>
> Axel
>
>
Received on Thu Apr 26 2001 - 11:23:58 CDT