1.查看删除前系统是时间点

  1. alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
  2. select  sysdate  from dual;

2.删除数据

  1. drop TABLE FIXF.fixf_svr_szh;
  2. truncate TABLE FIXF.fixf_svr_szhjymx;

3.经行恢复

完整语句
注意多个表恢复和恢复时重命名可用逗号隔开

  1. recover table fx.fxtbs
  2. until time "to_date('2018-05-20 15:53:29','yyyy-mm-dd hh24:mi:ss')"
  3. auxiliary destination '/u01/tsbak'
  4. remap table fx.fxtbs:fx.fstbs_new 
  5. datapump destination '/tmp'
  6. dumpfile 'exp.dat'
  7. notableimport;

实际使用语句

  1. recover table FIXF.fixf_svr_szh
  2. until time "to_date('2019-09-23 02:59:42','yyyy-mm-dd hh24:mi:ss')"
  3. auxiliary destination '/opt/oracle/recover'

pdb还原需要加 of pluggable database

  1. alter session set container=fixf;
  2. recover table fx.fxtbs of pluggable database fixf 
  3. until time "to_date('2018-05-20 15:53:29','yyyy-mm-dd hh24:mi:ss')"
  4. auxiliary destination '/u01/tsbak'
  5. remap table fx.fxtbs:fx.fstbs_new 
  6. datapump destination '/tmp'
  7. dumpfile 'exp.dat'
  8. notableimport;