SAP Note 540463 - FAQ: Consistency Checks + Block Corruptions

Component : Oracle - BW ORACLE

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

Key words :
size 1000000set pagesize 0set feedback offaccept vprefix char prompt 'prefix, alter system dump logfile '<logfile>' dba min 1, analyze table <tablename> validate structure cascade online, extension 'analyze table validate structure cascade online', --x-----------x-----x------------x-----x------------------>  time, analyze table validate structure cascade online, sap pool/cluster table layer check tool, rebuild index=> oracle bug 547464 - nologging option, 'accept vsuffix char prompt 'suffix, analyze table validate structure cascade

Related Notes :

1116190Handling of database corruptions by the SAP Support
825653Oracle: Common misconceptions
694155Error due to corrupt redo logs
365481Block corruptions