Entering content frame

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

You can use the special database parameter AUTO_RECREATE_BAD_INDEXES to specify whether indexes marked as BAD are recreated automatically after data has been restored. If this database parameter is set to NO and you have carried out a database recovery, you can then also recreate indexes marked as BAD explicitly.

Prerequisites

The database instance is in the ONLINE operational state.

Procedure

...

       1.      Choose Instance ® Recovery ® Index.

       2.      You can choose the tables for which you want to display indexes marked as BAD. To do so, enter appropriate search arguments for the owner, table name, and index name.

Owner

Owner

Table Name

Name of the table

Index Name

Name of the index

       3.      Choose Actions ® Search. The system displays a list of the indexes that match your criteria.

       4.      Select the indexes that you want to recreate.

       5.      Choose Actions ® Recreate to perform the action.

Recommendation

We recommend that you restore the indexes during periods where the load on the system is low.

 

Leaving content frame