SAP Note 1395074 - ORA-00201: Block, dba <address>, marked corrupt for invalid

Component : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/1395074 (SAP Service marketplace login required)

Summary :
When executing 'brbackup -u / -c -w only_dbv -t online' or using 'dbv', users may encounter the DBV-00201 error, indicating a block marked corrupt due to invalid redo application. Oracle versions 10.2.0.4 and above include this error, stemming from known Oracle bugs. This error, primarily informational, does not denote actual corruption requiring restoration. Instead, it suggests checking whether certain indexes need to be rebuilt. ACritical system updates and further information can be found in various SAP Notes and Oracle documentation, emphasizing index reconstruction and validation processes.

Key words :
consistency checks + block corruptionsnote 365481 - block corruptionsnote 354293 - dbverify reports corrupt block, ziphp-ux pa-risc 64-bit /oracle/oracle 64-bit/oracle 10, ziphp ux itanium 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris x86-64 /oracle/oracle 64-bit/oracle 10, zipsun solaris 64-bit /oracle/oracle 64-bit/oracle 10, analyze table <table_name> validate structure cascade online, ziplinux itanium 64 /oracle/oracle 64-bit/oracle 10, ziplinux x86-64 /oracle/oracle 64-bit/oracle 10, ziplinux 32-bit /oracle/oracle 32-bit/oracle 10, oracle 64 bit /oracle/oracle 64-bit/oracle 10

Related Notes :

849485Reconstruction of the NOLOGGING indexes after recovery
724972ORA-00200: Block, dba <address>, already marked corrupted
547464Nologging Option when creating indexes
365481Block corruptions
354293DBVerify reports corrupt block in freespace area
23345Consistency check of ORACLE database