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
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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 28814.1 "Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g".

Regards
Michel
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..
Re: ORA-01578 [message #237865 is a reply to message #237853] Wed, 16 May 2007 00:56 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Take care that dbms_repair does NOT repair any block corruption.

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


Current Time: Wed Dec 07 16:47:55 CST 2016

Total time taken to generate the page: 0.10913 seconds