If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Undo tablespace corruption during RMAN backup

The first time that I tried backing up this database using RMAN, I ran into a corruption issue on the UNDO tablespace. A dbverify detects corruption on the datafile as well. What is strange is that a "backup VALIDATE tablespace UNDO" doesn't indicate any corruption! That is pretty bizzare. Anyone know why?

Short of dropping the tablespace and recreating it (after addressing any objects that were using the undo), any other suggestions?

You seem to have got it..after backup validate check:
In Oracle 8i corruption found with the RMAN validate command is only reported in the alert log. In versions 9i+ you can query the view name v$database_block_corruption to determine what corruption, if any, was found by RMAN. The log files only record the process AFAIK !!

You can do this while RMAN is taking backup.This has to be set in your RMAN backup script.
This will check for corrupt blocks in the datafile specified and if its with the limit set then it would continue with the backup

set maxcorrupt for datafile
212,1,2 to 200;

212,1,2 are datafile nos and 200 is the max corrupt blocks that RMAN will check.If the max corrupt blocks exceeds 200 then it will give the same error as below.