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