rman备份异机恢复部分pdb

vi_vi0310

已于 2022-02-11 13:57:23 修改

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

文章标签： oracle

于 2022-02-10 14:03:48 首次发布

本文链接：https://blog.csdn.net/vi_vi0310/article/details/122859603

本文档介绍了如何使用RMAN在多租户环境中将单个PDB从源数据库恢复到备用服务器。具体步骤包括：全量备份CDB$ROOT和PDB$SEED以及目标PDB，恢复控制文件，注册备份集，然后恢复CDB$ROOT、PDB$SEED和目标PDB，并进行相关数据文件和临时文件的重命名操作。该过程可用于恢复已删除的PDB并将其插入源数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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