| How do we identify the corrupted block through RMAN? [message #317159] |
Tue, 29 April 2008 13:59  |
shrinika
Messages: 306
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 #317434 is a reply to message #317177] |
Thu, 01 May 2008 03:56  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
