SAP Note 17212 - SPADBA: Termination during reorg. leads to missing ind.

Symptom:

Indices are missing from certain tablespaces that were previously reorganized.

Cause and prerequisites

Oracle error complicated by a user error:
ORACLE error ORA-00902 may occur during the import step, particularly when the export was to tape (tape read error). SAP DBA detects the error and reports it. If the user terminates the operation, then the information (indices, grants) on the subsequent scripts is, of course, missing. If you then start R/3, the danger of duplicate records then exists (ORA-1452 when creating the indices).

Solution
Depending on the ORACLE error that occurred, you may have to modify the restart script, as when the import fails, SAPDBA automatically sets the restart plan: $ORACLE_HOME/sapreorg//restart.* such that it starts at deletion of the object.
If you can ignore the ORACLE error, modify the restart plan in such a way that it starts with creating the indices: all scripts before ind*.sql must be set to "Y".