Consistency check of ORACLE database with BRCONNECT

[ashish_vikas]

Hello friends,

In our BI test system, we have few Oracle Block corruption for 2ndry Index. We found out few which were coming in SM21 logs and fixed them by rebuilding them.

So, i wanted to check all INDEX for possibly Oracle Block corruption.

As per SAP Note 23345 - Consistency check of ORACLE database : I decided to use brconnect.

brconnect -u / -c -f stats -v cascade -t all -e null -p 10

However, this command did not checked any Index ... only All Tables.

Can you please help me to form a brconnect statement which can check ALL INDEX ONLY.

I tried "-i all" option in pleace of "-t all" but this is not correct.

Regards,

Ashish

[JamesZ]

hi Ashish,

The note 23345 you are referring is correct, however to 100% sure whether the database has corruption, BOTH rman/dbverify and analyze must check. analyze does not check index.

For you case, you need to run rman/dbverify check as well. Then use 365481 to run below sql to check the index name, so you can rebuild:

select segment_name, partition_name, segment_type, block_id, blocks

from dba_extents

where (<corrupted block> between

      block_id and (block_id + blocks - 1))

and file_id = <Filenummer from the first statement> and rownum < 2;

Best regards,
James

[Former Member]

Hi Ashish,

Please go through below wiki..

Block Corruption Helper - SAP on Oracle - SCN Wiki

Hope this helps.

Regards,

Prithviraj.