Re: Block corruption on Rollback Tablespace

"Bonjour" from Paris,

The best solution is to call Oracle support because it seems to require special init.ora parameters (not documented parameters). Try to see the Oracle note
"recovering from a lost datafile in a rollback tablespace" on metalink relative to these parameters.

"Au revoir" from Paris
Hieraklion

FS a écrit :

> 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 - 08:54:49 CDT