Home » RDBMS Server » Backup & Recovery » Block corrupted
Block corrupted [message #188252] Thu, 17 August 2006 11:00 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 11:42:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.