Home » RDBMS Server » Backup & Recovery » How do we identify the corrupted block through RMAN? (oracle9i)
How do we identify the corrupted block through RMAN? [message #317159] Tue, 29 April 2008 13:59 Go to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Hello all,

How do we identify corrupted block in database through RMAN?

Here is my understanding..., only way to identify the corrupted block through RMAN is,during the RMAN backup, the backup would fail if any of the blocks are corrrupted in database. Am i correct?? Please correct me if i am wrong...

Thanks
Govind
Re: How do we identify the corrupted block through RMAN? [message #317161 is a reply to message #317159] Tue, 29 April 2008 14:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
only way to identify the corrupted block through RMAN is,during the RMAN backup, the backup would fail if any of the blocks are corrrupted in database. Am i correct??

Correct.

Regards
Michel
Re: How do we identify the corrupted block through RMAN? [message #317177 is a reply to message #317159] Tue, 29 April 2008 17:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could do it without actually doing a backup with the following:

BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Re: How do we identify the corrupted block through RMAN? [message #317434 is a reply to message #317177] Thu, 01 May 2008 03:56 Go to previous message
prashant.pawar
Messages: 6
Registered: May 2008
Junior Member
You can use following methods to identify the corrupted blocks in the database

1. dbv verify
dbv file=C:\ORACLEXE\ORADATA\XE\USERS.DBF blocksize=8192
dbv FILE='+DSKGRP1/elftp/datafile/liftdata01.dbf' blocksize=8192 userid=system/sys --this for ASM file need asm username and password

2. using RAMN
rman > BACKUP VALIDATE CHECK LOGICAL DATABASE; --checks logical and physical
rman> backup validate database archivelog all-- check physical corruption
rman> backup validate datafile 6;-- find all corrupted blocks in datafile

after this commands check the view
SELECT * FROM V$DATABASE_BLOCK_CORRUPTION

3. using alert log
It will give the error message in alert log with file id and corrupted block.

-Prashant
Previous Topic: control file corrupted
Next Topic: RMAN deleting ASM directory
Goto Forum:
  


Current Time: Wed Dec 07 04:58:02 CST 2016

Total time taken to generate the page: 0.07524 seconds