Home » RDBMS Server » Server Administration » ORA-01578
ORA-01578 [message #237360] Mon, 14 May 2007 04:31 Go to next message
UAE1
Messages: 10
Registered: March 2007
Location: UAE
Junior Member
Dear All,

i have aproblem and i would like from you to help me ,, my problem is :-

Oracle Database is giving the exception ORA-01578: ORACLE data block corrupted (file # 9, block # 3580127)

ORA-01110: data file 9: '/opt/ora9/oradata/STLM/users01.dbf'

and i don't have a backup from AUR_HISTORY and STATUS_HISTORY

in this case what i have to do ?? please provide me the soluation as soon as possible ..

best Regard's

UAE1

Report message to a moderator

Re: ORA-01578 [message #237366 is a reply to message #237360] Mon, 14 May 2007 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Metalink note 28814.1 "Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g".

Regards
Michel

Report message to a moderator

Re: ORA-01578 [message #237853 is a reply to message #237360] Wed, 16 May 2007 00:18 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member
hi,
Have a look at this documentation too..

Report message to a moderator

Re: ORA-01578 [message #237865 is a reply to message #237853] Wed, 16 May 2007 00:56 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Take care that dbms_repair does NOT repair any block corruption.

Regards
Michel

Report message to a moderator

Previous Topic: Drop Temporary Tablespace
Next Topic: controlfile old error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 12:46:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.