Symptom
During a recovery or a system refresh one of the following messages occurs:
-
DBV shows the following error:
BR0398W DBVERIFY has detected corrupt blocks
DBV-00201: Block, DBA 1154567432, marked corrupt for invalid redo
application - V$DATABASE_BLOCK_CORRUPTION contains such a row:
9 5 129573 4 3253280299 NOLOGGING
INDPART SAPTAP /BIC/FZD_BACK2~080 /BIC/FZD_BACK20
Environment
- SAP Release independent
- Oracle Release independent
- Operating System independent
Reproducing the Issue
Performing a recovery after some indexes were created with NOLOGGING option.
Cause
If you create an index with the 'nologging' option, Oracle does not
write the changes made to the index blocks during creation of the index
to the online redologs. As a consequence the information is not written
to the archivelogs either. As such, occurences of the before mentioned
messages are expected! This is not a real corruption.
Resolution
IMPORTANT NOTE
The aim of this KBA is not to solve NOLOGGING 'Soft Corruption' problems, but how to turn it off. Indexes in BW or BI SAP Systems are usually created with NOLOGGING option.
Also note, turning off this option is not the standard recommendation from SAP as it can cause performance issues and a huge number of redolog data. Use this KBA only if you are aware of the consequences!
The NOLOGGING option for index creation can be turned off with transaction SPRO as follows:
The aim of this KBA is not to solve NOLOGGING 'Soft Corruption' problems, but how to turn it off. Indexes in BW or BI SAP Systems are usually created with NOLOGGING option.
Also note, turning off this option is not the standard recommendation from SAP as it can cause performance issues and a huge number of redolog data. Use this KBA only if you are aware of the consequences!
The NOLOGGING option for index creation can be turned off with transaction SPRO as follows:
- Call transaction SPRO
- Click on button 'SAP Reference IMG'
- Navigate to the menu 'Settings for Database Interfaces (Oracle)' and click on the 'Clock Icon'
- Click on checkbox 'Logging while Index' and save the changes
Keywords
- Logging while Index
- SPRO
- IMG
Header Data
| Released On | 25.01.2013 14:12:08 | ||
| Release Status | Released to Customer | ||
| Component | BW-SYS-DB-ORA BW ORACLE | ||
| Other Components |
| ||
| Priority | Normal | ||
| Category | How To |
Product
This document is not restricted to a product or product version
References
This document refers to:
CSS SAP Notes
| 442763 | Avoid NOLOGGING during the index structure (Oracle) | |
| 23345 | Consistency check of ORACLE database |
No comments:
Post a Comment