Re: Block corruption on Rollback Tablespace

After a hardware problem when i restored the datafile from tape and did a recovery ,
I am having the same problem on 7.3.4 DB on HP-UX and i tried to export and import the table that
was having the problem . It did not solve it . It gave me the same error once but after that it is fine .
I am planning to drop the tablespace and recreate all the objects in the tablespace again .

• Sathish B

"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message news:988302288.21334.0.nnrp-07.c30bdde2_at_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 Fri May 11 2001 - 19:56:27 CDT