Re: ORACLE data block corrupted

On Sat, 31 Mar 2001 14:42:39 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
>news:nvbbctcerhgpag8q1p4q4dmcvs2ckvv5rr_at_4ax.com...
>> Dear all,
>>
>> I encountered a problem when I try to start up in Server Manager:
>> SVRMGR> startup pfile=d:\twdm\ctlfile\inittwdm.ora
>> ORACLE instance started.
>> Total System Global Area 93952944 bytes
>> Fixed Size 52144 bytes
>> Variable Size 26714112 bytes
>> Database Buffers 67108864 bytes
>> Redo Buffers 77824 bytes
>> Database mounted.
>> ORA-00604: error occurred at recursive SQL level 1
>> ORA-01578: ORACLE data block corrupted (file # 2, block # 615)
>> ORA-01110: data file 2: 'D:\TWDM\DATFILE\RBS1TWDM.ORA'
>> SVRMGR>
>>
>> However, the database can be started up if I add 3 lines and mark out
>> the rollback segment in the parameter file:
>> #rollback_segments = ( rb1, rb2, rb3, rb4, rb5 )
>> _allow_resetlogs_corruption=true
>> _corrupted_rollback_segments=( rb1, rb2, rb3, rb4, rb5 )
>> _offline_rollback_segments=( rb1, rb2, rb3, rb4, rb5 )
>>
>> Can anyone explain this to me? Thanks in advance.
>>
>> The problem happens after I re-installed Windows NT, and ORACLE EE
>> 8.0.6, but I switched the D: drive and E: drive inadvertently.The
>> database was on E: drive and ORACLE on D: drive before the
>> re-installation, and became the reverse after it. To get it back
>> working, I try CREATE CONTROLFILE and RECOVER DATABASE kind of stuffs.
>>
>> BTW, the database is still in 8.0.5 format, maybe I should run some
>> scripts to upgrade it to 8.0.6.
>>
>> Regards,
>> Dino
>>
>
>Datablock corrupted means there is an error on your disk.
>For now: you were lucky it is a rollback tablespace.
>Create an extra rollback segment in the tablespace system, drop the rollback
>tablespace, bringing the other rollback segments offline first of course,
>shutdown the database and make a backup (with verify!)
>Now remove the affected file
>Now check the disk
>If all is OK the bad spot doesn't belong to any file.
>Bring up the database and recreate your tablespace.
>And yes of course you will need to run upgrade scripts.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>

Sybrand,

I wonder why Oracle doesn't provide a GUI interface to change the datafile locations recorded in the controlfile? This truely makes a simple thing extremely complicated. Thanks.

Regards,
Dino Received on Sat Mar 31 2001 - 23:27:14 CST