Restoring data with the TDR process has the following restrictions:

  • Both the restored backup database and the target database must be enabled for multi-tenancy
  • The restored backup database and target database must have identical schema for the table(s) or sequence(s) being moved
  • The table partitions for tenants or groups must be allocated
  • The tables must have indexes activated
  • Dropped objects are not supported (only deleted data can be recovered, not table or sequence definitions)
  • The restored backup database and the target database must be local (no remote connections)
  • You can execute multiple data move commands simultaneously only if both databases are running in multi-user mode
Figure 1. Tenant Data Recovery Process