oracle dmp恢复 Oracle数据库使用DMP文件恢复数据

 

关于12c中数据泵DataPump impdp导入工具增强

 

使用统一审计对所有impdp/expdp操作进行审计
例如:

CREATE AUDIT POLICY <policy_name> ACTIONS COMPONENT=DATAPUMP { EXPORT | IMPORT | ALL };

启用此策略

AUDIT POLICY <policy_name> BY SYSTEM;

你可以查询UNIFIED_AUDIT_TRAIL数据字典视图找到和Oracle Data Pump相关的审计事件:

SELECT DP_TEXT_PARAMETERS1, DP_BOOLEAN_PARAMETERS1 FROM UNIFIED_AUDIT_TRAIL WHERE AUDIT_TYPE = 'Datapump';

DP_TEXT_PARAMETERS1 DP_BOOLEAN_PARAMETERS1
---------------------------------------------- ----------------------------------
MASTER TABLE: SCOTT.SYS_EXPORT_TABLE_01, MASTER_ONLY: FALSE,
JOB_TYPE: EXPORT, DATA_ONLY: FALSE,
METADATA_JOB_MODE: TABLE_EXPORT, METADATA_ONLY: FALSE,
JOB VERSION: 12.1.0.0, DUMPFILE_PRESENT: