Entering content frame

Procedure documentation Restoring the Indexes after a Database Restore Locate the document in the library structure

You can use the Structure linkspecial database parameter AUTO_RECREATE_BAD_INDEXES to specify whether indexes marked as BAD are recreated automatically after a restore. 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 the indexes marked BAD are to be displayed. 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. A list of the indices that match your criteria is then displayed.

       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.

See also:

Activating, Deactivating, or Deleting Indexes

Database Administration in CCMS, Structure linkIndexes

 

Leaving content frame