如果是Oracle，通常是使用 Networker + NMDA（NetWorker Module for Databases and Applications）来备份。但之前的版本是做不到表级恢复，因为RMAN不支持表级备份。只是从Oracle 12C R1之后有了对表级的恢复支持，Networker NMDA 1.6以及8.2都是支持这个特性的。但需要注意的是有Oracle有一些前提条件使用这个特性，只要这些满足了Networker就能支持;
Prerequisites for Recovering Tables and Table Partitions
Prior to recovering a table or table partition, you must perform a full backup of undo, SYSTEM, SYSAUX, SYSEXT (if the SYSEXT tablespace exists in your database) and the tablespace that contains the table or table partition.
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 a table, all partitions that contain the dependent objects of the table must be included in they set.
As part of the recovery process, RMAN creates an auxiliary database that is used to recover tables or table partitions to the specified point in time.
DELL-Leo
Community Manager
•
9K 消息
0
2025年5月28日 02:00
您好！
这个要看你具体是什么数据库（Oracle？SQL？）以及数据库版本以及你Networker的版本，跟这些都有一些关系。
如果是SQL server，可以用NetWorker modules for SQL 结合 ItemPoint 功能来实现对SQL的表级恢复，参考下面文章：
https://nsrd.info/blog/2017/07/11/using-itempoint-table-level-recovery-with-sql-server/
如果是Oracle，通常是使用 Networker + NMDA（NetWorker Module for Databases and Applications）来备份。但之前的版本是做不到表级恢复，因为RMAN不支持表级备份。只是从Oracle 12C R1之后有了对表级的恢复支持，Networker NMDA 1.6以及8.2都是支持这个特性的。但需要注意的是有Oracle有一些前提条件使用这个特性，只要这些满足了Networker就能支持;
Prerequisites for Recovering Tables and Table Partitions
Prior to recovering a table or table partition, you must perform a full backup of undo, SYSTEM, SYSAUX, SYSEXT (if the SYSEXT tablespace exists in your database) and the tablespace that contains the table or table partition.
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 a table, all partitions that contain the dependent objects of the table must be included in they set.
As part of the recovery process, RMAN creates an auxiliary database that is used to recover tables or table partitions to the specified point in time.
Database Backup and Recovery User's Guide
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV686