单独恢复一个PDB

例子：

a.  查看某测试表wh.wh_PAY_GROUP_LOG的数据
SQL> alter session set container=plugdb ;
Session altered.

SQL> select count(1) from  wh.wh_PAY_GROUP_LOG ;
  COUNT(1)
----------
    330594

b.  备份pluggable database PLUGDB .

[oracle@nkgttv2024rhl tmp]$ rman target /
RMAN> backup as compressed backupset pluggable database plugdb format '/tmp/pdb_bak_%U';

SQL> alter session set container=plugdb ;
SQL> shut immediate

c. 模拟删除数据文件
[oracle@nkgttv2024rhl plugdb]$ pwd
/data01/oracle12c/oradata/test12/plugdb
[oracle@nkgttv2024rhl plugdb]$ ls -l
total 3929392
-rw-r----- 1 oracle oinstall  524296192 Mar  6 17:13 hw01.dbf
-rw-r----- 1 oracle oinstall 2461540352 Mar  6 17:13 plugdb_users01.dbf
-rw-r----- 1 oracle oinstall  749740032 Mar  6 17:13 sysaux01.dbf
-rw-r----- 1 oracle oinstall  283123712 Mar  6 17:13 system01.dbf
-rw-r----- 1 oracle oinstall  209723392 Mar  6 17:08 temp01.dbf
[oracle@nkgttv2024rhl plugdb]$
[oracle@nkgttv2024rhl plugdb]$ rm  *.dbf

d. 恢复PDB :plugdb，查看测试表数据量 。

[oracle@nkgttv2024rhl plugdb]$ rman target  /

RMAN> restore pluggable database plugdb ;
RMAN>
RMAN> recover pluggable database plugdb;

RMAN> alter pluggable database plugdb  open ;
Statement processed

SQL> alter session set container=plugdb ;
Session altered.

SQL> select count(1) from  wh.wh_PAY_GROUP_LOG ;
  COUNT(1)
----------
    330594
SQL>