你好,
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 theSYSEXTtablespace exists in your database) and the tablespace that contains the table or table partition.
If the indexes or partitions for a table in tablespacetbs1are contained in tablespacetbs2, then you can recover the table only if tablepsacetbs2is 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.
另外如果要对某些表做备份以及增量,可以通过expdp之后再用Networker文件系统的方式备份;
从恢复的角度来说,只要有全备份、增量备份以及归档日志,都可以满足客户的第二点恢复的要求;
如果数据库业务中断,只要本地磁盘或者归档日志的存放路径没有问题,在应用这些日志以后都可以将数据库实例恢复出来;
如果每15分钟备份一次归档,数据更加不会丢失;
关于备份恢复速度还得具体参考硬件性能;
关于第三点不建议每15分钟做增量备份,对于数据库压力太大,一般在企业中采用的是每15分钟备份归档日志;