Procedure documentation Restoring the Indexes After a Database Restore Locate the document in its SAP Library structure

Use

During a restore of a Structure linkdatabase instance, the indexes contained in the Structure linklog area are not restored for optimization reasons. Indexes that have not been restored are marked BAD and can be restored explicitly by following the procedure described here.

Prerequisites

The database instance is in the ONLINE Structure linkoperational state.

Procedure

Choose Instance ® Recovery ® Indexes.

You can choose the tables for which the indexes marked BAD are to be displayed. To do so, enter appropriate search arguments under Owner, Table Name, and Index Name.

Owner

Owner

Table Name

Name of the table

Index Name

Name of the index

Then choose Indexes ® Select. The system displays a list of the indexes that match your criteria.

Select the indexes you want to restore in the list. If you want to restore all of the indexes displayed, choose Indexes ® Mark All.

Choose Indexes ® Execute to perform the action.

Recommendation

It is advisable to restore the indexes during periods where the workload on the system is lower.