Deletion Fields (See SM21) errors during client copy

[Former Member]

Hi All,

I am performing a local client copy and I am getting the message "Deletion Fields (See SM21)" in the errors and warning section.When I see SM21 it shows me the below error message

Database error 8102 at DEL access to table "XXXXXXXXXX"

> ORA-08102: index key not found, obj# 60980, file 34, block

> 2222907 (2)

This is happening for around 200 tables.

I have checked SM66 and all work process are busy trying to delete data, but failing because of the error mentioned.

Please advise how can I solve this issue..

Regards,

Pradeep

[Former Member · Accepted solution]

Also, look at the Oracle parameter recommendations from SAP and see if they are set accordingly on the system.

SAP Note 830576 - Parameter recommendations for Oracle 10g

You can do this by simply executing the script attached to the following note.

1171650 Automated Oracle DB parameter check

A simple parameter which is not properly set can cause unpredictable errors sometimes.

Note 1413928 - Index corruption/wrong results after rebuild index ONLINE

Br,

Venky

[Former Member · Accepted solution]

Hi Venky,

Thanks for your replies.

We solved this issue by rebuilding the index for the irrupted tables.

Client copy is running fine now.

Regards,

Pradeep

[Former Member]

Hi Pradeep,

There is a chance of block corruption. Since this is happening for more number of table, you should try to find out the corrupted blocks.

First, see if there are any datafiles in recover mode.

SELECT FILE#, ERROR, ONLINE_STATUS, CHANGE#, TIME  FROM   V$RECOVER_FILE;

Try to run rman validate

Command Prompt> rman nocatalog

RMAN> connect target /

backup check logical validate (datafile 34) ;

select * from V$DATABASE_BLOCK_CORRUPTION;

If you want to run the validation for the entire database,

backup check logical validate

Based upon the results, we can propose a way ahead.

Br,

Venky