OraFAQ Forum: Server Administration » Oracle Data Block Corrupted, Can't Open DB

Home » RDBMS Server » Server Administration » Oracle Data Block Corrupted, Can't Open DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Data Block Corrupted, Can't Open DB [message #56975]

Fri, 09 May 2003 16:55

Alex
Messages: 190
Registered: August 1999

Senior Member

I am trying to Open database, but I get "Block Correpted Error" , does have any idea how to fix the problem?

------------

SVRMGR> startup mount;
...
SVRMGR> alter database open;
alter database open
*
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 3, block # 42686)
ORA-01110: data file 3: 'L:ORANT8DATABASERBS1ORCL.ORA'

Report message to a moderator

Re: Oracle Data Block Corrupted, Can't Open DB [message #56977 is a reply to message #56975]

Sat, 10 May 2003 06:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

better to talk to the big brothers @oracle support services.
Block level corruptions are supposed to be handled by them.

Report message to a moderator

Re: Oracle Data Block Corrupted, Can't Open DB [message #56990 is a reply to message #56975]

Mon, 12 May 2003 12:46

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi,
refer to the following doc
Doc-id:28814.1 "Handling Block Corruptions in Oracle7 / 8 / 8i / 9i" in the metalink..

Mahesh's solution is Standard and best :)

sai

Report message to a moderator

Previous Topic:	DEFAULT ROLE
Next Topic:	Oracle 9i on Linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:27:19 CDT 2024