rman备份异机恢复部分pdb

rman备份异机恢复部分pdb

参考资料：
How to use Rman to Restore Of Single PDB in Multitenant to Alternate Server (文档 ID 2142675.1)

 

Two PDB available are PDB1 and PDB2
In this case we are assuming a full backup of the database including the PDB1/PDB2 has been taken on the
target(source) database
To restore a single PDB we need to restore the backup of CDB$ROOT and PDB$SEED along with the PDB which
needs to be restored.
A full backup of the database completed at sequence 100 and we need to restore single PDB PDB1 until
sequence 120 on test server
A full backup was taken using the 'backup database plus archivelog' command.
Please note that you can use this same procedure to manually restore a subset of PDBs from multiple PDBs in
the multitenant environment.
You can restore a dropped PDB using this approach and later plug it into the source database.

--实验，部分过程省略........

--1.rman使用cdb备份整个数据库，通过cdb库的备份，可以实现对应的cdb和所包含的pdb
SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 MYPDB1 READ WRITE NO


[oracle@oracle19c]$ rman target /

RMAN> run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup database filesperset 3 format '/home/oracle/backup/db_%d_%T_%U';
backup archivelog all format '/home/oracle/backup/arc_%t_%s';
backup current controlfile format '/home/oracle/backup/cntrl_%s