Solution : https://service.sap.com/sap/support/notes/23345 (SAP Service marketplace login required)
Summary :
This SAP Note outlines crucial Oracle database and backup consistency check strategies to prevent data loss from corruptions, which might occur due to failures across system components. It emphasizes regular consistency evaluations via multiple recommended methods, including transaction DB13 for database checks and RMAN for backup verifications. For inherent Oracle environments, it advises setting the db_block_checksum parameter and utilizing BR*TOOLS for operational efficiency. Critical details include implementing exhaustive checks when database corruptions are detected and interacting with SAP Oracle support for guidance on managing database integrity issues.
Key words :
owner segment_name blocks---------- ------------ ----------sapr3 mcsi 486400command------------------------------------------------------------dbv blocksize=8192 userid=sapr3/sap segment_id=23, customer component bc-db-ora oracle priority recommendations / additional info category, parallel create index 923919 advanced oracle block checking features 914174 minor functional enhancements, validating partitioned tables 923919 advanced oracle block checking features 605062 faq, rman nocatalogrman> connect target /rman> backup check logical validate, htm#admin022 oracle pl/sql package dbms_hm oracle 11g, use_rmv oracle pl/sql package dbms_space_admin oracle delivers, file=/dev/null volsize=0 buffer=3000000 log=<log filename>windows, set linesize 200set pagesize 0select 'dbv file=', importing sql scripts attachments file namefile size
Related Notes :
| 1566406 | DBV enhancements in transaction layer |
| 1464091 | Minor functional enhancements in BR*Tools (3) |
| 1395074 | ORA-00201: Block, dba <address>, marked corrupt for invalid |
| 1235952 | Minor functional enhancements in BR*Tools (2) |
| 1151509 | ORA-600[Kcbz_check_objd_typ_1] Upgrading from 9i to 10g |
| 1116190 | Handling of database corruptions by the SAP Support |
| 1001558 | DBA_SEGMENTS.BLOCKS wrong after parallel create index |
| 923919 | Advanced Oracle block checking features |
| 914174 | Minor functional enhancements in BR*Tools |
| 871455 | Poor performance when accessing DBA and V$ views |
| 817262 | Check tool for segment corruption in ASSM tablespace |
| 817253 | FAQ: Open a Database Read only |
| 724972 | ORA-00200: Block, dba <address>, already marked corrupted |
| 605062 | FAQ: Restore and recovery |
| 591600 | Error due to inappropriate column values |
| 589320 | Composite SAP note: DBV-00102 |
| 546006 | Problems with Oracle due to operating system errors |
| 527250 | DBV-00100 Composite SAP note |
| 514178 | ORA-14508 when validating partitioned tables |
| 496967 | |
| 376755 | ORA-00600 - what to do? |
| 365481 | Block corruptions |
| 357194 | ORA-00900 when importing SQL scripts |
| 356481 | RSTXTCPY: Long text names cannot be entered |
| 354293 | DBVerify reports corrupt block in freespace area |
| 317554 | BYTES, BLOCK, EXTENTS of DBA_SEGMENTS empty |
| 96296 | CC-ERROR: Database problem in client copy |
| 12741 | Current versions of BR*Tools and SAPDBA |