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
Karma: 0


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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
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
Karma: 0
Senior Member
Does the block actually belong to a segment ?
Previous Topic: Backup to tape device
Next Topic: ORA-12154: TNS:could not resolve service name
Goto Forum:

Current Time: Tue Aug 22 13:51:20 CDT 2017

Total time taken to generate the page: 0.07810 seconds