OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Block corrupted

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

Block corrupted [message #188252]

Thu, 17 August 2006 11:00

fabiosax
Messages: 15
Registered: March 2006

Junior Member

Hello there,
I got the following error message:
ORA-01578: ORACLE data block corrupted (file # 42, block # 16373) ORA-01110: data file 42: '/Oracle9i/OraHome/oradata_nas/ERIDBCQ/CQ_LTBDB2.ora'

Could you please someone help me to how to fix these corrupted block?
May I use the run {blockrecover datafile 42 block 16373;}?

I have Oralce9i on Solaris 9.
Thanks in advance
Fabio

Report message to a moderator

Re: Block corrupted [message #188820 is a reply to message #188252]

Mon, 21 August 2006 20:38

mymot
Messages: 225
Registered: July 2005

Senior Member

Fabio,

you are right, use below command

BLOCKRECOVER DATAFILE 42 BLOCK 16373;

Check corrupt blocks detail in below view


SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;

Report message to a moderator

Previous Topic:	RMAN NOCATALOG - what V$ views to query:
Next Topic:	RMAN-Differential,Cumulative and Full Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 13 02:16:20 CDT 2026