Recovering Tables and Table Partitions

RMAN可以通过创建auxiliary database使用备份对表进行时间点恢复而不影响其它对象

RMAN enables you to recover one or more tables or table partitions to a specified point in time without affecting the remaining database objects.

You can use previously-created RMAN backups to recover tables and table partitions to a specified point in time. RMAN creates an auxiliary database that is used to recover tables or table partitions to the specified point in time. 

Recovering tables and table partitions from RMAN backups is useful in the following scenarios:

1. You need to recover a very small number of tables to a particular point in time.
2. You need to recover tables that have been logically corrupted or have been dropped and purged.
3. Flashback Table is not possible because the desired point-in-time is older than available undo.
4. You want to recover data that is lost after a DDL operation modified the structure of tables. Using Flashback Table is not possible because a DDL was run on the tables between the desired point in time and the current time. Flashback Table cannot rewind tables through structural changes such as a truncate table operation.

（一）Limitations of Recovering Tables and Table Partitions

To recover table or table partitions, you need a full backup of undo, SYSTEM, SYSAUX, and the tablespace that contains the table or table partition.

To recover a table, all partitions that contain the dependent objects of the table must be included in the recovery set. If the indexes or partitions for a table in tablespace tbs1 are contained in tablespace tbs2, then you can recover the table only if tablepsace tbs2 is also included in the recovery set.

To recover tables in a PDB, you need backups of the following:

SYSTEM, SYSAUX, and undo tablespace of the root, CDB seed, and the PDB containing the tables

Tablespace containing the tables or partitions

When you use the RECOVER command to recover tables or table partitions contained in an RMAN backup, the following limitations exist.

1. Tables and table partitions belonging to SYS schema cannot be recovered.
2. Tables and table partitions from SYSTEM and SYSAUX tablespaces cannot be recovered.
3. Tables and table partitions on standby databases cannot be recovered.
4. Tables with named NOT NULL constraints cannot be recovered with the REMAP option.

（二）Steps By