GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Scenarios

 Print  |  
Question:  Block Corruption

Answer: where we can find block corruption? which view desc block corruption?


July 07, 2008 07:31:24 #1
 kishoredba   Member Since: July 2008    Total Comments: 4 
RE: Block Corruption
 
using Rman we can find it.
V$block_corruption view there to find out corrupted blocks.

Rman>block recover datafile <dbfileid> block <blockid>;

using above statement we recover corrupted blocks.
     

 

Back To Question