oracle12c rman 恢复 单个pdb

oracle cdb 恢复单个 pdb

1.rman 备份脚本

run {
backup  tag 'pdb02'  format '/home/oracle/20180904/bk_%s_%p_%t_pdb02db.bak'  database pdb02;
sql 'alter system archive log current';
backup  tag 'SEEDPDB' format '/home/oracle/20180904/bk_%s_%p_%t_PDBSEED.bak' database "PDB$SEED";
sql 'alter system archive log current';
backup  tag 'rootdb' format '/home/oracle/20180904/bk_%s_%p_%t_rootdb.bak' database root;
sql 'alter system archive log current';
backup spfile format '/home/oracle/20180904/bk_spfile_%s_%p_%t_.bak' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/20180904/arch_%s_%p_%t_.bak' tag='archivelog';
copy current controlfile to '/home/oracle/20180904/controlfilefile_%s_%p_%t_.bak' ;
delete noprompt archivelog until time 'sysdate-1';
}

restore spfile from '/home/oracle/20180904/bk_spfile_7_1_985967268_.bak';

create pfile='/home/oracle/init.ora' from spfile;

 restore controlfile from '/home/oracle/20180904/controlfilefile_10_1_985967277_.bak';

startup force；

RMAN> report schema;

Starting implicit crosscheck backup at 04-SEP-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=42 device type=DISK
Crossche