RECOVER—Restore a Copy of an Object

The RECOVER keyword recovers an object by restoring a copy of the object.
The RECOVER keyword recovers a database, tablespace, indexspace, or index by restoring a copy of the object.
Review the following considerations:
  • To use RECOVER INDEX, the index must be created with the COPY YES attribute. If an index does not have the COPY YES attribute, use REBUILD INDEX to reconstruct the index from its tablespace, or enable automatic index rebuilding to rebuild the index.
  • If you specify RECOVER INDEX, you must also specify SORTLOG YES.
  • You can use wildcards to specify database and tablespace names.
For the syntax of this keyword, see RECOVER and REBUILD.