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

Report message to a moderator

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: 68653
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

Report message to a moderator

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 ?

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 20:02:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.