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
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;


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


Current Time: Fri Dec 09 05:58:58 CST 2016

Total time taken to generate the page: 0.05591 seconds