Restrictions
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 46. Tenant Data Recovery Process