Re: Block corruption on Rollback Tablespace

From: Syltrem <syltrem_at_videotron.ca.spammenot>
Date: Thu, 26 Apr 2001 09:29:32 -0400
Message-ID: <9iVF6.1984$f23.38785@wagner.videotron.net>

Hi!

I will let others give you advise on fixing the problem but...

Did you try restoring that datafile (rbs tablespace) again? You may have had problems reading back your tape or something. Could be worth a try to restore these files again, as they may be ok on your backup but were not restored correctly to the disk.

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site)
To reply to myself directly, remove .spammenot from my address

"FS" <axk_at_fernbach.com> a écrit dans le 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 - 08:29:32 CDT