前提条件前面有相关备份

1.pdb示例恢复

注意:还原一个完整的pdb,必须先关闭pdb.

  1. alter pluggable database robertpdb close;
  2. restore pluggable database robertpdb ;
  3. recover pluggable database robertpdb;
  4. alter pluggable database robertpdb open;

同时多个pdb恢复

  1. alter pluggable database robertpdb,test close;
  2. restore pluggable database robertpdb,test ;
  3. recover pluggable database robertpdb,test;
  4. alter pluggable database robertpdb,test open;

pdb 不完全恢复

  1. select current_scn from v$database;
  2. RMAN> ALTER PLUGGABLE DATABASE PDBLHR3 CLOSE;
  3. RMAN> RUN {
  4. SET UNTIL SCN = 1851648 ;
  5. RESTORE pluggable DATABASE PDBLHR3;
  6. RECOVER pluggable DATABASE PDBLHR3 AUXILIARY DESTINATION='/u01/app/oracle/oradata';
  7. ALTER PLUGGABLE DATABASE PDBLHR3 OPEN RESETLOGS;
  8. }