Home » RDBMS Server » Backup & Recovery » Block Corruption through RMAN (Oracle, AIX)
Block Corruption through RMAN [message #338449] Tue, 05 August 2008 02:30 Go to next message
Messages: 64
Registered: February 2008


I run a command through RMAN for checking "BLOCK CORRUPTION".
The bwlow are the command:-
RMAN> backup validate database archivelog all;

But when I am checking the v$database_block_corruption or the v$backup_corruption, I found "no rows selected".

Still I am getting error when I am checking with dbv utility.

My question is :-

Is there is any initialization parameter I have to set for populating the above views?

Kindly suggest.

Re: Block Corruption through RMAN [message #338455 is a reply to message #338449] Tue, 05 August 2008 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64967
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From Reference:
V$BACKUP_CORRUPTION displays information about corrupt block ranges in datafile backups from the control file. Note that corruptions are not tolerated in the control file and archived redo log backups.

If there is no row then there is no corruption in your datafiles backup.

Re: Block Corruption through RMAN [message #338722 is a reply to message #338449] Tue, 05 August 2008 16:50 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Does the block actually belong to a segment ?
Previous Topic: ORA-12154: TNS:could not resolve service name
Next Topic: Command(s) to applying level 1 backup to level 0 backup set.
Goto Forum:

Current Time: Thu Jun 29 00:37:37 CDT 2017

Total time taken to generate the page: 0.14904 seconds