单独恢复一个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>