Re: ORACLE data block corrupted

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:rredct43jtu3pegad9niftsc3fg11b5coc_at_4ax.com...
> 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
>

What's so complicated about "alter database datafile rename 'c:\there\thisone.dbf' to 'd:\here\yupthisone.dbf'"?

OK, so the file has to be offline before it can work, but even so...

I take it you are a fan of that behemoth OEM?

Crikey. Rather you than me, that's for sure.... and I happen to love Windows!!

Regards
HJR Received on Sun Apr 01 2001 - 00:05:52 CST