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

Hi,

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.

Pokhraj
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: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From Reference:
Quote:
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.

Regards
Michel
Re: Block Corruption through RMAN [message #338722 is a reply to message #338449] Tue, 05 August 2008 16:50 Go to previous message
ebrian
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: Sun Dec 11 08:02:26 CST 2016

Total time taken to generate the page: 0.04267 seconds