Use
For optimization reasons, the indices contained in the
log area are not restored with a database 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.
It is advisable to restore the indices during periods where the load on the system is lower.