Recovering Pluggable Database (PDB) table in Container Database (CDB)
Recovering Pluggable Database (PDB) table in Container Database (CDB) Connect to the PDB and create a test table SQL> connect HR/Password#123@pdb1 Connected. SQL> set echo on SQL> create table EMPLOYESS_TEST as select * from EMPLOYEES; Table created. SQL> select count (*) from EMPLOYESS_TEST; COUNT(*) ---------- 107 SQL> alter session set container=pdb1; Session altered. SQL> select timestamp_to_scn(sysdate) from v$database; TIMESTAMP_TO_SCN(SYSDATE) ------------------------- 3337108 SQL> SELECT NAME, CURRENT_SCN FROM V$DATABASE; NAME CURRENT_SCN --------- ----------- TESTDB03 3337119 NOTE this SCN which will be used to recover the table. Take an RMAN Backup of the PDB SQL> ho [oracle@TESTDB03 ~]$ rman target / Recovery Manager: ...