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.
The database instance is in the ONLINE operational state.
...
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.
We recommend that you restore the indexes during periods where the load on the system is low.