Entering content frameProcedure documentation Restoring the Indices After a Database Restore Locate the document in its SAP Library structure

Use

For optimization reasons, the indices contained in the Structure linklog area are not restored with a Structure linkdatabase instance. Indices 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 ONLINE mode.

Procedure

Choose Instance ® Recovery ® Index.

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

Owner

Owner

Table Name

Name of the table

Index Name

Name of the index

Then choose Select. A list of the indices that match your criteria is then displayed.

Select the indices you want to restore in the list. If you want to restore all of the indices, choose Mark All.

Choose Execute to restore the indices.

Recommendation

It is advisable to restore the indices during periods where the load on the system is lower.

 

 

Leaving content frame