rman表级恢复

问题背景：

备份岗位寻求备份恢复的操作文档，根据官方文档自行简单整理      

文件系统，共享磁盘可将路径设置为+date

RECOVER TABLE HR.PDB_EMP OF PLUGGABLE DATABASE HR_PDB

	UNTIL TIME 'SYSDATE-4'

	AUXILIARY DESTINATION '/tmp/backups'

	REMAP TABLE 'HR'.'PDB_EMP':'EMP_RECVR';

恢复pdb数据库，并进行映射

RECOVER TABLE SCOTT.EMP, SCOTT.DEPT

    UNTIL TIME 'SYSDATE-1'

    AUXILIARY DESTINATION '/tmp/oracle/recover'

    DATAPUMP DESTINATION '/tmp/recover/dumpfiles'

    DUMP FILE 'emp_dept_exp_dump.dat'

    NOTABLEIMPORT;

恢复出dump文件

RECOVER TABLE SH.SALES:SALES_1998, SH.SALES:SALES_1999

    UNTIL SEQUENCE 354

    AUXILIARY DESTINATION '/tmp/oracle/recover'

    REMAP TABLE 'SH'.'SALES':'SALES_1998':'HISTORIC_SALES_1998',

              'SH'.'SALES':'SALES_1999':'HISTORIC_SALES_1999'  
    REMAP TABLESPACE 'SALES_TS':'SALES_PRE_2000_TS';

基于序列号恢复并进行映射表空间

RECOVER TABLE HR.DEPARTMENTS, SH.CHANNELS

UNTIL TIME 'SYSDATE – 1'  
AUXILIARY DESTINATION '/tmp/auxdest'

REMAP TABLE hr.departments:example.new_departments, sh.channels:example.new_channels;

基于时间恢复多表