Wednesday, February 19, 2014

How to recover a table in a pluggable database from a backup

I'm going to test some useful recovery scenarios for the Oracle Database 12c release.
An interesting option introduced with this release is the possibility to restore even a single table, without impacting other objects, tablespace or database when that table is no more in the recycle bin.

The current release I'm using is Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit based on a Linux platform.

Let's start with an example.
I'm going to create into a pluggable database a new user (MARCOV) and two tables with few rows.

Before dropping your tables be sure to have a backup containing the missing tables.
I was not able to find any recommendation on Oracle documentation ("Backup and Recovery User's Guide" and "Backup and Recovery Reference") about having a backup of the container database if you want to restore a table previously created into a pluggable database !

In the following scenario I had indeed a full backup of the container database and I was able to recover the "lost" table;
then I tried to perform the same steps having only the backup of the pluggable database and it was not possible to complete the recovery task.

Here is my test case. I'm currently connected to a CDB named CDB001.

In this container I've a pluggable database named PDB0101. The new user MARCOV on PDB0101 is created with few grants and the possibility to run the dbms_flashback package to obtain the current System Change Number (SCN).
[oracle@vsi08devpom ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Feb 12 10:15:04 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name, open_mode from V$PDBS;

NAME          OPEN_MODE
------------------------------ ----------
PDB$SEED         READ ONLY
PDB0101          READ WRITE

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=PDB0101;

Session altered.

SQL> show con_name

CON_NAME
------------------------------
PDB0101
SQL> create user marcov 
  2  identified by "marcov"
  3  default tablespace users
  4  temporary tablespace temp
  5  profile default
  6  account unlock;

User created.

SQL> grant create session, create table to marcov;

Grant succeeded.

SQL> alter user marcov quota 50M on users;

User altered.

SQL> grant execute on dbms_flashback to marcov;

Grant succeeded.
Once the new user is created, I can connect to the pluggable database with that user, creating one table with one row.
The current SCN after the table has been created is 8009717.
SQL> conn marcov/marcov@PDB0101_CDB001
Connected.
SQL> show con_name

CON_NAME
------------------------------
PDB0101
SQL> create table t1 (a number);

Table created.

SQL> insert into t1 values (1);

1 row created.

SQL> commit;

Commit complete.

SQL> select dbms_flashback.get_system_change_number scn from dual;

       SCN
----------
   8009717
I want to take a backup of the container database. I'm going to use the 'report schema' and 'list backup' to show you what datafile and backups are available.
[oracle@vsi08devpom ~]$ export NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'
[oracle@vsi08devpom ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Feb 12 10:39:12 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDB001 (DBID=4134963396)

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CDB001

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    790      SYSTEM               ***     /opt/app/oracle/oradata/CDB001/system01.dbf
3    2070     SYSAUX               ***     /opt/app/oracle/oradata/CDB001/sysaux01.dbf
4    150      UNDOTBS1             ***     /opt/app/oracle/oradata/CDB001/undotbs01.dbf
5    250      PDB$SEED:SYSTEM      ***     /opt/app/oracle/oradata/CDB001/pdbseed/system01.dbf
6    5        USERS                ***     /opt/app/oracle/oradata/CDB001/users01.dbf
7    590      PDB$SEED:SYSAUX      ***     /opt/app/oracle/oradata/CDB001/pdbseed/sysaux01.dbf
8    270      PDB0101:SYSTEM       ***     /opt/app/oracle/oradata/CDB001/PDB0101/system01.dbf
9    640      PDB0101:SYSAUX       ***     /opt/app/oracle/oradata/CDB001/PDB0101/sysaux01.dbf
10   5        PDB0101:USERS        ***     /opt/app/oracle/oradata/CDB001/PDB0101/PDB0101_users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    60       TEMP                 32767       /opt/app/oracle/oradata/CDB001/temp01.dbf
2    20       PDB$SEED:TEMP        32767       /opt/app/oracle/oradata/CDB001/pdbseed/pdbseed_temp01.dbf
3    20       PDB0101:TEMP         32767       /opt/app/oracle/oradata/CDB001/PDB0101/temp01.dbf

RMAN> list backup of database;

specification does not match any backup in the repository
No backup is available so I need to take at least one backup. I'm going to take a full database backup of the CDB and its PDBs.
RMAN> backup database plus archivelog;

Starting backup at 12-02-2014 10:39:47
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=274 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=659 RECID=10 STAMP=838910191
input archived log thread=1 sequence=660 RECID=11 STAMP=838910385
input archived log thread=1 sequence=661 RECID=12 STAMP=838911248
input archived log thread=1 sequence=662 RECID=13 STAMP=838911290
input archived log thread=1 sequence=663 RECID=14 STAMP=838936876
input archived log thread=1 sequence=664 RECID=15 STAMP=838954825
input archived log thread=1 sequence=665 RECID=16 STAMP=838969262
input archived log thread=1 sequence=666 RECID=17 STAMP=838990856
input archived log thread=1 sequence=667 RECID=18 STAMP=839010107
input archived log thread=1 sequence=668 RECID=19 STAMP=839025149
input archived log thread=1 sequence=669 RECID=20 STAMP=839052023
input archived log thread=1 sequence=670 RECID=21 STAMP=839066666
input archived log thread=1 sequence=671 RECID=22 STAMP=839084422
input archived log thread=1 sequence=672 RECID=23 STAMP=839106050
input archived log thread=1 sequence=673 RECID=24 STAMP=839134863
input archived log thread=1 sequence=674 RECID=25 STAMP=839159419
input archived log thread=1 sequence=675 RECID=26 STAMP=839159631
input archived log thread=1 sequence=676 RECID=27 STAMP=839160939
input archived log thread=1 sequence=677 RECID=28 STAMP=839160961
input archived log thread=1 sequence=678 RECID=29 STAMP=839162174
input archived log thread=1 sequence=679 RECID=30 STAMP=839162192
input archived log thread=1 sequence=680 RECID=31 STAMP=839196037
input archived log thread=1 sequence=681 RECID=32 STAMP=839199610
input archived log thread=1 sequence=682 RECID=33 STAMP=839232033
input archived log thread=1 sequence=683 RECID=34 STAMP=839275218
input archived log thread=1 sequence=684 RECID=35 STAMP=839289656
input archived log thread=1 sequence=685 RECID=36 STAMP=839322019
input archived log thread=1 sequence=686 RECID=37 STAMP=839327987
channel ORA_DISK_1: starting piece 1 at 12-02-2014 10:39:47
channel ORA_DISK_1: finished piece 1 at 12-02-2014 10:40:22
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_annnn_TAG20140212T103947_9hpjc3vp_.bkp tag=TAG20140212T103947 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 12-02-2014 10:40:22

Starting backup at 12-02-2014 10:40:22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/opt/app/oracle/oradata/CDB001/sysaux01.dbf
input datafile file number=00001 name=/opt/app/oracle/oradata/CDB001/system01.dbf
input datafile file number=00004 name=/opt/app/oracle/oradata/CDB001/undotbs01.dbf
input datafile file number=00006 name=/opt/app/oracle/oradata/CDB001/users01.dbf
channel ORA_DISK_1: starting piece 1 at 12-02-2014 10:40:23
channel ORA_DISK_1: finished piece 1 at 12-02-2014 10:42:08
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp tag=TAG20140212T104022 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/opt/app/oracle/oradata/CDB001/PDB0101/sysaux01.dbf
input datafile file number=00008 name=/opt/app/oracle/oradata/CDB001/PDB0101/system01.dbf
input datafile file number=00010 name=/opt/app/oracle/oradata/CDB001/PDB0101/PDB0101_users01.dbf
channel ORA_DISK_1: starting piece 1 at 12-02-2014 10:42:08
channel ORA_DISK_1: finished piece 1 at 12-02-2014 10:42:53
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp tag=TAG20140212T104022 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/opt/app/oracle/oradata/CDB001/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/opt/app/oracle/oradata/CDB001/pdbseed/system01.dbf
channel ORA_DISK_1: starting piece 1 at 12-02-2014 10:42:53
channel ORA_DISK_1: finished piece 1 at 12-02-2014 10:43:28
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E1CE36B940C96E0430100007FE168/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjjxhq_.bkp tag=TAG20140212T104022 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 12-02-2014 10:43:28

Starting backup at 12-02-2014 10:43:28
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=687 RECID=38 STAMP=839328208
channel ORA_DISK_1: starting piece 1 at 12-02-2014 10:43:28
channel ORA_DISK_1: finished piece 1 at 12-02-2014 10:43:29
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_annnn_TAG20140212T104328_9hpjl0x9_.bkp tag=TAG20140212T104328 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 12-02-2014 10:43:29

Starting Control File and SPFILE Autobackup at 12-02-2014 10:43:30
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 12-02-2014 10:43:33
Once the backup is completed I know I have a valid copy of MARCOV.T1 table in one RMAN backup set.
Let's check the current SCN after the backup is taken.
SQL> show user
USER is "MARCOV"

SQL> select dbms_flashback.get_system_change_number scn from dual;

       SCN
----------
   8010280
I want to create another table, T2, on MARCOV schema inside the pluggable database PDB0101.
SQL> create table t2 (a number);

Table created.

SQL> insert into t2 values (1);

1 row created.

SQL> commit;

Commit complete.

SQL> select dbms_flashback.get_system_change_number scn from dual;

       SCN
----------
   8010338
At SCN number 8010338 I have a valid backup containing the MARCOV.T1 table but not the MARCOV.T2 and still the two available tables on the MARCOV schema.

I'm dropping "inadvertently" MARCOV.T1 table, but without the PURGE option. Only one table is still owned by MARCOV user querying the USER_TABLES view. Anyway something is present into the so called recyclebin: it's original name is T1.
SQL> drop table t1;      

Table dropped.

SQL> select table_name from user_tables;

TABLE_NAME
--------------------------------------------------
T2

SQL> select * from tab;

TNAME         TABTYPE  CLUSTERID
-------------------------------------------------- ------- ----------
T2         TABLE
BIN$8b6luRpCd8ngQwEAAH9AuA==$0      TABLE

SQL> show recyclebin
ORIGINAL NAME  RECYCLEBIN NAME  OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
T1   BIN$8b6luRpCd8ngQwEAAH9AuA==$0 TABLE      2014-02-12:10:48:38
Using the flashback table command I can "extract" from the recyclebin the T1 table so that its rows could be selected again.
SQL> flashback table "BIN$8b6luRpCd8ngQwEAAH9AuA==$0" to before drop;

Flashback complete.

SQL> select table_name from user_tables;

TABLE_NAME
--------------------------------------------------
T1
T2

SQL> select count(*) from t1;

  COUNT(*)
----------
  1
Now I want to finally test the RMAN recover table command so I need to use again the drop command with the purge option to avoid the recyclebin and definitively lose my tables.
SQL> drop table t1 purge;

Table dropped.

SQL> drop table t2 purge;

Table dropped.

SQL> show recyclebin
I've lost both tables and I'm wondering if the recover table command will be able to recover them.
During the recovery process RMAN will create and start a new "temporary" instance: the instance needs a valid location where to write its datafiles taken from the previous backup. I want to create this location just under the default location of the pluggable database PDB0101.
[oracle@vsi08devpom ~]$ mkdir /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE
As first attempt I want to try a recover of MARCOV.T1 table using a SCN before the available backup was taken.
I'm expecting that the recover operation is going to fail.
RMAN> recover table marcov.t1 of pluggable database PDB0101 until scn 8009717 auxiliary destination '/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE';

Starting recover at 12-02-2014 11:07:32
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1

Creating automatic instance, with SID='FBzE'

initialization parameters used for automatic instance:
db_name=CDB001
db_unique_name=FBzE_pitr_PDB0101_CDB001
compatible=12.1.0.0.0
db_block_size=8192
db_files=200
sga_target=1G
processes=80
diagnostic_dest=/opt/app/oracle
db_create_file_dest=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE
log_archive_dest_1='location=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CDB001

Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                281019648 bytes
Database Buffers             780140544 bytes
Redo Buffers                   5480448 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  scn 8009717;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log 
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 12-02-2014 11:07:46
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=11 device type=DISK


Removing automatic instance
shutting down automatic instance 
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/12/2014 11:07:48
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
The recover command failed because no available backup was created before the SCN proposed. Let's see what happens if I try to recover both tables specifying a SCN after I completed the backup and just after the creation of the second table.
RMAN> recover table marcov.t1, marcov.t2 of pluggable database PDB0101 until scn 8010338 auxiliary destination '/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE';

Starting recover at 12-02-2014 11:15:55
current log archived
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1

Creating automatic instance, with SID='aBwj'

initialization parameters used for automatic instance:
db_name=CDB001
db_unique_name=aBwj_pitr_PDB0101_CDB001
compatible=12.1.0.0.0
db_block_size=8192
db_files=200
sga_target=1G
processes=80
diagnostic_dest=/opt/app/oracle
db_create_file_dest=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE
log_archive_dest_1='location=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CDB001

Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                281019648 bytes
Database Buffers             780140544 bytes
Redo Buffers                   5480448 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  scn 8010338;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log 
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 12-02-2014 11:16:08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=82 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp tag=TAG20140212T104330
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hplh8ry_.ctl
Finished restore at 12-02-2014 11:16:09

sql statement: alter database mount clone database

sql statement: alter system archive log current

contents of Memory Script:
{
# set requested point in time
set until  scn 8010338;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile  1 to new;
set newname for clone datafile  4 to new;
set newname for clone datafile  3 to new;
set newname for clone datafile  8 to new;
set newname for clone datafile  9 to new;
set newname for clone tempfile  1 to new;
set newname for clone tempfile  3 to new;
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  1, 4, 3, 8, 9;
switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 3 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_%u_.tmp in control file

Starting restore at 12-02-2014 11:16:14
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp tag=TAG20140212T104022
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00009 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp tag=TAG20140212T104022
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 12-02-2014 11:18:25

datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=839330305 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hplhh9p_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=9 STAMP=839330305 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_undotbs1_9hplhhbk_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=839330305 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hplhh8t_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=11 STAMP=839330305 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hpllgjp_.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=12 STAMP=839330305 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hpllg7d_.dbf

contents of Memory Script:
{
# set requested point in time
set until  scn 8010338;
# online the datafiles restored or switched
sql clone "alter database datafile  1 online";
sql clone "alter database datafile  4 online";
sql clone "alter database datafile  3 online";
sql clone 'PDB0101' "alter database datafile 
 8 online";
sql clone 'PDB0101' "alter database datafile 
 9 online";
# recover and open database read only
recover clone database tablespace  "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB0101":"SYSTEM", "PDB0101":"SYSAUX";
sql clone 'alter database open read only';
}
executing Memory Script

executing command: SET until clause

sql statement: alter database datafile  1 online

sql statement: alter database datafile  4 online

sql statement: alter database datafile  3 online

sql statement: alter database datafile  8 online

sql statement: alter database datafile  9 online

Starting recover at 12-02-2014 11:18:25
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 687 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc
archived log for thread 1 with sequence 688 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc thread=1 sequence=687
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc thread=1 sequence=688
media recovery complete, elapsed time: 00:00:02
Finished recover at 12-02-2014 11:18:29

sql statement: alter database open read only

contents of Memory Script:
{
sql clone 'alter pluggable database  PDB0101 open read only';
}
executing Memory Script

sql statement: alter pluggable database  PDB0101 open read only

contents of Memory Script:
{
   sql clone "create spfile from memory";
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  control_files = 
  ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hplh8ry_.ctl'' comment=
 ''RMAN set'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
# mount database
sql clone 'alter database mount clone database';
}
executing Memory Script

sql statement: create spfile from memory

database closed
database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                285213952 bytes
Database Buffers             775946240 bytes
Redo Buffers                   5480448 bytes

sql statement: alter system set  control_files =   ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hplh8ry_.ctl'' comment= ''RMAN set'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                285213952 bytes
Database Buffers             775946240 bytes
Redo Buffers                   5480448 bytes

sql statement: alter database mount clone database

contents of Memory Script:
{
# set requested point in time
set until  scn 8010338;
# set destinations for recovery set and auxiliary set datafiles
set newname for datafile  10 to new;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  10;
switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

Starting restore at 12-02-2014 11:19:08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=11 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00010 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/ABWJ_PITR_PDB0101_CDB001/datafile/o1_mf_users_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp tag=TAG20140212T104022
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 12-02-2014 11:19:09

datafile 10 switched to datafile copy
input datafile copy RECID=14 STAMP=839330350 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/ABWJ_PITR_PDB0101_CDB001/datafile/o1_mf_users_9hplnwvb_.dbf

contents of Memory Script:
{
# set requested point in time
set until  scn 8010338;
# online the datafiles restored or switched
sql clone 'PDB0101' "alter database datafile 
 10 online";
# recover and open resetlogs
recover clone database tablespace  "PDB0101":"USERS", "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB0101":"SYSTEM", "PDB0101":"SYSAUX" delete archivelog;
alter clone database open resetlogs;
}
executing Memory Script

executing command: SET until clause

sql statement: alter database datafile  10 online

Starting recover at 12-02-2014 11:19:09
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 687 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc
archived log for thread 1 with sequence 688 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc thread=1 sequence=687
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc thread=1 sequence=688
media recovery complete, elapsed time: 00:00:00
Finished recover at 12-02-2014 11:19:10

database opened

contents of Memory Script:
{
sql clone 'alter pluggable database  PDB0101 open';
}
executing Memory Script

sql statement: alter pluggable database  PDB0101 open

contents of Memory Script:
{
# create directory for datapump import
sql 'PDB0101' "create or replace directory 
TSPITR_DIROBJ_DPDIR as ''
/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''";
# create directory for datapump export
sql clone 'PDB0101' "create or replace directory 
TSPITR_DIROBJ_DPDIR as ''
/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''";
}
executing Memory Script

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''

Performing export of tables...
   EXPDP> Starting "SYS"."TSPITR_EXP_aBwj_wdxk":  
   EXPDP> Estimate in progress using BLOCKS method...
   EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
   EXPDP> Total estimation using BLOCKS method: 128 KB
   EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
   EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
   EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
   EXPDP> . . exported "MARCOV"."T1"                               5.031 KB       1 rows
   EXPDP> . . exported "MARCOV"."T2"                               5.031 KB       1 rows
   EXPDP> Master table "SYS"."TSPITR_EXP_aBwj_wdxk" successfully loaded/unloaded
   EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TSPITR_EXP_aBwj_wdxk is:
   EXPDP>   /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/tspitr_aBwj_36569.dmp
   EXPDP> Job "SYS"."TSPITR_EXP_aBwj_wdxk" successfully completed at Wed Feb 12 11:20:04 2014 elapsed 0 00:00:26
Export completed


contents of Memory Script:
{
# shutdown clone before import
shutdown clone abort
}
executing Memory Script

Oracle instance shut down

Performing import of tables...
   IMPDP> Master table "SYS"."TSPITR_IMP_aBwj_woyn" successfully loaded/unloaded
   IMPDP> Starting "SYS"."TSPITR_IMP_aBwj_woyn":  
   IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
   IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
   IMPDP> . . imported "MARCOV"."T1"                               5.031 KB       1 rows
   IMPDP> . . imported "MARCOV"."T2"                               5.031 KB       1 rows
   IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
   IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
   IMPDP> Job "SYS"."TSPITR_IMP_aBwj_woyn" successfully completed at Wed Feb 12 11:21:16 2014 elapsed 0 00:01:00
Import completed


Removing automatic instance
Automatic instance removed
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_9hplmz8c_.tmp deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_9hplmph9_.tmp deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/ABWJ_PITR_PDB0101_CDB001/onlinelog/o1_mf_3_9hplo18l_.log deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/ABWJ_PITR_PDB0101_CDB001/onlinelog/o1_mf_2_9hplo04t_.log deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/ABWJ_PITR_PDB0101_CDB001/onlinelog/o1_mf_1_9hplnz1q_.log deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/ABWJ_PITR_PDB0101_CDB001/datafile/o1_mf_users_9hplnwvb_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hpllg7d_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hpllgjp_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hplhh8t_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_undotbs1_9hplhhbk_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hplhh9p_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hplh8ry_.ctl deleted
auxiliary instance file tspitr_aBwj_36569.dmp deleted
Finished recover at 12-02-2014 11:21:17
The recover command successfully completed its steps.
It was able to create an auxiliary database named aBwj, use it to restore all the backup and the archivelog for the two tables, export and import their rows into the target pluggable database PDB0101. As you can see during the recovery steps a new aBwj instance is created...
[root@vsi08devpom ~]# ps -ef|grep smon
oracle   20271     1  0 11:19 ?        00:00:00 ora_smon_aBwj
root     20592 19983  0 11:19 pts/2    00:00:00 grep smon
oracle   29331     1  0 Feb06 ?        00:00:26 ora_smon_CDB001
... and then removed.
[root@vsi08devpom ~]# ps -ef|grep smon
root     20873 19983  0 11:38 pts/2    00:00:00 grep smon
oracle   29331     1  0 Feb06 ?        00:00:26 ora_smon_CDB001
Inside MARCOV schema of the pluggable database PDB0101 the two tables are available again.
SQL> show user
USER is "MARCOV"
SQL> select dbms_flashback.get_system_change_number scn from dual;

       SCN
----------
   8013207
SQL> select * from t1;        

  A
----------
  1

SQL> select * from t2;

  A
----------
  1
Let's drop again MARCOV.T1 table and try its recover at a SCN after the backup but prior the creation of MARCOV.T2 table.
Will be MARCOV.T2 table still available ?
SQL> drop table t1 purge;

Table dropped.
Here is the recover command to a different specific SCN.
Find 8010280 inside this web page to see when this SCN was calculated.
RMAN> recover table marcov.t1 of pluggable database PDB0101 until scn 8010280 auxiliary destination '/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE';

Starting recover at 12-02-2014 11:43:54
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1

Creating automatic instance, with SID='plxu'

initialization parameters used for automatic instance:
db_name=CDB001
db_unique_name=plxu_pitr_PDB0101_CDB001
compatible=12.1.0.0.0
db_block_size=8192
db_files=200
sga_target=1G
processes=80
diagnostic_dest=/opt/app/oracle
db_create_file_dest=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE
log_archive_dest_1='location=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CDB001

Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                281019648 bytes
Database Buffers             780140544 bytes
Redo Buffers                   5480448 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  scn 8010280;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log 
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 12-02-2014 11:44:06
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=82 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp tag=TAG20140212T104330
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hpn3pjf_.ctl
Finished restore at 12-02-2014 11:44:07

sql statement: alter database mount clone database

sql statement: alter system archive log current

contents of Memory Script:
{
# set requested point in time
set until  scn 8010280;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile  1 to new;
set newname for clone datafile  4 to new;
set newname for clone datafile  3 to new;
set newname for clone datafile  8 to new;
set newname for clone datafile  9 to new;
set newname for clone tempfile  1 to new;
set newname for clone tempfile  3 to new;
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  1, 4, 3, 8, 9;
switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 3 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_%u_.tmp in control file

Starting restore at 12-02-2014 11:44:12
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp tag=TAG20140212T104022
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00009 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp tag=TAG20140212T104022
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 12-02-2014 11:46:22

datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=839331983 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hpn3x6z_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=9 STAMP=839331983 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_undotbs1_9hpn3x7s_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=839331983 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hpn3x60_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=11 STAMP=839331983 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hpn6w4d_.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=12 STAMP=839331983 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hpn6w3t_.dbf

contents of Memory Script:
{
# set requested point in time
set until  scn 8010280;
# online the datafiles restored or switched
sql clone "alter database datafile  1 online";
sql clone "alter database datafile  4 online";
sql clone "alter database datafile  3 online";
sql clone 'PDB0101' "alter database datafile 
 8 online";
sql clone 'PDB0101' "alter database datafile 
 9 online";
# recover and open database read only
recover clone database tablespace  "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB0101":"SYSTEM", "PDB0101":"SYSAUX";
sql clone 'alter database open read only';
}
executing Memory Script

executing command: SET until clause

sql statement: alter database datafile  1 online

sql statement: alter database datafile  4 online

sql statement: alter database datafile  3 online

sql statement: alter database datafile  8 online

sql statement: alter database datafile  9 online

Starting recover at 12-02-2014 11:46:23
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 687 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc
archived log for thread 1 with sequence 688 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc thread=1 sequence=687
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc thread=1 sequence=688
media recovery complete, elapsed time: 00:00:01
Finished recover at 12-02-2014 11:46:25

sql statement: alter database open read only

contents of Memory Script:
{
sql clone 'alter pluggable database  PDB0101 open read only';
}
executing Memory Script

sql statement: alter pluggable database  PDB0101 open read only

contents of Memory Script:
{
   sql clone "create spfile from memory";
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  control_files = 
  ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hpn3pjf_.ctl'' comment=
 ''RMAN set'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
# mount database
sql clone 'alter database mount clone database';
}
executing Memory Script

sql statement: create spfile from memory

database closed
database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                285213952 bytes
Database Buffers             775946240 bytes
Redo Buffers                   5480448 bytes

sql statement: alter system set  control_files =   ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hpn3pjf_.ctl'' comment= ''RMAN set'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                285213952 bytes
Database Buffers             775946240 bytes
Redo Buffers                   5480448 bytes

sql statement: alter database mount clone database

contents of Memory Script:
{
# set requested point in time
set until  scn 8010280;
# set destinations for recovery set and auxiliary set datafiles
set newname for datafile  10 to new;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  10;
switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

Starting restore at 12-02-2014 11:46:57
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=11 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00010 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/PLXU_PITR_PDB0101_CDB001/datafile/o1_mf_users_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp tag=TAG20140212T104022
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 12-02-2014 11:46:59

datafile 10 switched to datafile copy
input datafile copy RECID=14 STAMP=839332019 file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/PLXU_PITR_PDB0101_CDB001/datafile/o1_mf_users_9hpn92hl_.dbf

contents of Memory Script:
{
# set requested point in time
set until  scn 8010280;
# online the datafiles restored or switched
sql clone 'PDB0101' "alter database datafile 
 10 online";
# recover and open resetlogs
recover clone database tablespace  "PDB0101":"USERS", "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB0101":"SYSTEM", "PDB0101":"SYSAUX" delete archivelog;
alter clone database open resetlogs;
}
executing Memory Script

executing command: SET until clause

sql statement: alter database datafile  10 online

Starting recover at 12-02-2014 11:46:59
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 687 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc
archived log for thread 1 with sequence 688 is already on disk as file /opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_687_9hpjl0pr_.arc thread=1 sequence=687
archived log file name=/opt/app/oracle/fast_recovery_area/CDB001/archivelog/2014_02_12/o1_mf_1_688_9hplgw0k_.arc thread=1 sequence=688
media recovery complete, elapsed time: 00:00:00
Finished recover at 12-02-2014 11:47:00

database opened

contents of Memory Script:
{
sql clone 'alter pluggable database  PDB0101 open';
}
executing Memory Script

sql statement: alter pluggable database  PDB0101 open

contents of Memory Script:
{
# create directory for datapump import
sql 'PDB0101' "create or replace directory 
TSPITR_DIROBJ_DPDIR as ''
/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''";
# create directory for datapump export
sql clone 'PDB0101' "create or replace directory 
TSPITR_DIROBJ_DPDIR as ''
/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''";
}
executing Memory Script

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE''

Performing export of tables...
   EXPDP> Starting "SYS"."TSPITR_EXP_plxu_rzrl":  
   EXPDP> Estimate in progress using BLOCKS method...
   EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
   EXPDP> Total estimation using BLOCKS method: 64 KB
   EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
   EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
   EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
   EXPDP> . . exported "MARCOV"."T1"                               5.031 KB       1 rows
   EXPDP> Master table "SYS"."TSPITR_EXP_plxu_rzrl" successfully loaded/unloaded
   EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TSPITR_EXP_plxu_rzrl is:
   EXPDP>   /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/tspitr_plxu_39412.dmp
   EXPDP> Job "SYS"."TSPITR_EXP_plxu_rzrl" successfully completed at Wed Feb 12 11:47:49 2014 elapsed 0 00:00:23
Export completed


contents of Memory Script:
{
# shutdown clone before import
shutdown clone abort
}
executing Memory Script

Oracle instance shut down

Performing import of tables...
   IMPDP> Master table "SYS"."TSPITR_IMP_plxu_ixEA" successfully loaded/unloaded
   IMPDP> Starting "SYS"."TSPITR_IMP_plxu_ixEA":  
   IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
   IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
   IMPDP> . . imported "MARCOV"."T1"                               5.031 KB       1 rows
   IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
   IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
   IMPDP> Job "SYS"."TSPITR_IMP_plxu_ixEA" successfully completed at Wed Feb 12 11:48:53 2014 elapsed 0 00:00:58
Import completed


Removing automatic instance
Automatic instance removed
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_9hpn88ho_.tmp deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_9hpn82js_.tmp deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/PLXU_PITR_PDB0101_CDB001/onlinelog/o1_mf_3_9hpn96tp_.log deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/PLXU_PITR_PDB0101_CDB001/onlinelog/o1_mf_2_9hpn95pb_.log deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/PLXU_PITR_PDB0101_CDB001/onlinelog/o1_mf_1_9hpn94lp_.log deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/PLXU_PITR_PDB0101_CDB001/datafile/o1_mf_users_9hpn92hl_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hpn6w3t_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hpn6w4d_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_sysaux_9hpn3x60_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_undotbs1_9hpn3x7s_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_system_9hpn3x6z_.dbf deleted
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hpn3pjf_.ctl deleted
auxiliary instance file tspitr_plxu_39412.dmp deleted
Finished recover at 12-02-2014 11:48:54
The recover command is completed successfully again.
During its recovery operations RMAN created and removed the auxiliary instance named this time plxu.
[root@vsi08devpom ~]# ps -ef|grep smon
oracle   20997     1  0 11:44 ?        00:00:00 ora_smon_plxu
root     21051 19983  0 11:44 pts/2    00:00:00 grep smon
oracle   29331     1  0 Feb06 ?        00:00:26 ora_smon_CDB001

[root@vsi08devpom ~]# ps -ef|grep smon
root     21796 19983  0 11:58 pts/2    00:00:00 grep smon
oracle   29331     1  0 Feb06 ?        00:00:26 ora_smon_CDB001
Naturally the recover table process is not a flashback of the database so the MARCOV.T2 table is still there and always available to be queried.
SQL> select * from t1;

  A
----------
  1

SQL> select * from t2;

  A
----------
  1
Now the interesting scenario... I want to remove the previous full container database backup...
RMAN> delete noprompt backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
24      24      1   1   AVAILABLE   DISK        /opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_annnn_TAG20140212T103947_9hpjc3vp_.bkp
25      25      1   1   AVAILABLE   DISK        /opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp
26      26      1   1   AVAILABLE   DISK        /opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp
27      27      1   1   AVAILABLE   DISK        /opt/app/oracle/fast_recovery_area/CDB001/E18E1CE36B940C96E0430100007FE168/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjjxhq_.bkp
28      28      1   1   AVAILABLE   DISK        /opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_annnn_TAG20140212T104328_9hpjl0x9_.bkp
29      29      1   1   AVAILABLE   DISK        /opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp
deleted backup piece
backup piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_annnn_TAG20140212T103947_9hpjc3vp_.bkp RECID=24 STAMP=839327987
deleted backup piece
backup piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjd76g_.bkp RECID=25 STAMP=839328023
deleted backup piece
backup piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjhjbw_.bkp RECID=26 STAMP=839328128
deleted backup piece
backup piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E1CE36B940C96E0430100007FE168/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T104022_9hpjjxhq_.bkp RECID=27 STAMP=839328173
deleted backup piece
backup piece handle=/opt/app/oracle/fast_recovery_area/CDB001/backupset/2014_02_12/o1_mf_annnn_TAG20140212T104328_9hpjl0x9_.bkp RECID=28 STAMP=839328208
deleted backup piece
backup piece handle=/opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839328210_9hpjl2xk_.bkp RECID=29 STAMP=839328210
Deleted 6 objects


RMAN> list backup;

specification does not match any backup in the repository
... and execute a backup of just the pluggable database PDB0101.
RMAN> backup pluggable database PDB0101;

Starting backup at 12-02-2014 12:00:29
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/opt/app/oracle/oradata/CDB001/PDB0101/sysaux01.dbf
input datafile file number=00008 name=/opt/app/oracle/oradata/CDB001/PDB0101/system01.dbf
input datafile file number=00010 name=/opt/app/oracle/oradata/CDB001/PDB0101/PDB0101_users01.dbf
channel ORA_DISK_1: starting piece 1 at 12-02-2014 12:00:29
channel ORA_DISK_1: finished piece 1 at 12-02-2014 12:01:24
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T120029_9hpo2fnm_.bkp tag=TAG20140212T120029 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 12-02-2014 12:01:24

Starting Control File and SPFILE Autobackup at 12-02-2014 12:01:24
piece handle=/opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839332884_9hpo458m_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 12-02-2014 12:01:27

RMAN> list backup of pluggable database PDB0101;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
30      Full    718.37M    DISK        00:00:49     12-02-2014 12:01:18
        BP Key: 30   Status: AVAILABLE  Compressed: NO  Tag: TAG20140212T120029
        Piece Name: /opt/app/oracle/fast_recovery_area/CDB001/E18E282148FD10A5E0430100007FC94D/backupset/2014_02_12/o1_mf_nnndf_TAG20140212T120029_9hpo2fnm_.bkp
  List of Datafiles in backup set 30
  Container ID: 3, PDB Name: PDB0101
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  8       Full 8014530    12-02-2014 12:00:29 /opt/app/oracle/oradata/CDB001/PDB0101/system01.dbf
  9       Full 8014530    12-02-2014 12:00:29 /opt/app/oracle/oradata/CDB001/PDB0101/sysaux01.dbf
  10      Full 8014530    12-02-2014 12:00:29 /opt/app/oracle/oradata/CDB001/PDB0101/PDB0101_users01.dbf
The current SCN after that backup is 8015786.
SQL> select dbms_flashback.get_system_change_number scn from dual;

       SCN
----------
   8015786
I'm going to simulate the lost of MARCOV.T2: I'm confident to recover it because I have the full pluggable database backup containing all the information of that table.
SQL> drop table t2 purge;

Table dropped.
By now it's just the time to execute the usual recover table command and wait for the creation of the auxiliary instance.
RMAN> recover table marcov.t2 of pluggable database PDB0101 until scn 8015786 auxiliary destination '/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE';

Starting recover at 12-02-2014 12:22:00
current log archived
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1

Creating automatic instance, with SID='pknF'

initialization parameters used for automatic instance:
db_name=CDB001
db_unique_name=pknF_pitr_PDB0101_CDB001
compatible=12.1.0.0.0
db_block_size=8192
db_files=200
sga_target=1G
processes=80
diagnostic_dest=/opt/app/oracle
db_create_file_dest=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE
log_archive_dest_1='location=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CDB001

Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                281019648 bytes
Database Buffers             780140544 bytes
Redo Buffers                   5480448 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  scn 8015786;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log 
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 12-02-2014 12:22:11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=11 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839332884_9hpo458m_.bkp
channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/fast_recovery_area/CDB001/autobackup/2014_02_12/o1_mf_s_839332884_9hpo458m_.bkp tag=TAG20140212T120124
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hppc4b3_.ctl
Finished restore at 12-02-2014 12:22:13

sql statement: alter database mount clone database

sql statement: alter system archive log current

contents of Memory Script:
{
# set requested point in time
set until  scn 8015786;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile  1 to new;
set newname for clone datafile  4 to new;
set newname for clone datafile  3 to new;
set newname for clone datafile  8 to new;
set newname for clone datafile  9 to new;
set newname for clone tempfile  1 to new;
set newname for clone tempfile  3 to new;
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  1, 4, 3, 8, 9;
switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 3 to /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/datafile/o1_mf_temp_%u_.tmp in control file

Starting restore at 12-02-2014 12:22:18
using channel ORA_AUX_DISK_1

One or more auxiliary set of datafiles could not be removed

Removing automatic instance
shutting down automatic instance 
Oracle instance shut down
Automatic instance removed
auxiliary instance file /opt/app/oracle/oradata/CDB001/PDB0101/RECOVERY_PURGED_TABLE/CDB001/controlfile/o1_mf_9hppc4b3_.ctl deleted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/12/2014 12:22:18
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
What's happening ? What's wrong ? Why the auxiliary instance named pknF doesn't start ?
[root@vsi08devpom ~]# ps -ef|grep smon
oracle   22255     1  0 12:22 ?        00:00:00 ora_smon_pknF
root     22307 19983  0 12:22 pts/2    00:00:00 grep smon
oracle   29331     1  0 Feb06 ?        00:00:26 ora_smon_CDB001
[root@vsi08devpom ~]# ps -ef|grep smon
root     22309 19983  0 12:22 pts/2    00:00:00 grep smon
oracle   29331     1  0 Feb06 ?        00:00:26 ora_smon_CDB001

The problem is that to use the recover table command you need a full backup of the container database: having only a backup of the pluggable database is not sufficient because it doesn't have enough information to build an auxiliary instance (just think about at the "shared" UNDO tablespace not backed up for the pluggable database).

It's not mentioned (at least I was not able to find this information) into the Oracle documentation that you need a valid backup of the container database if you want to recover a table "lost" in a schema of a pluggable database.

I'm going to suggest an integration to contributors of the "Backup and Recovery User's Guide" and "Backup and Recovery Reference" so it could be more clear that you cannot recover a table if you have only a backup of the pluggable database.

That's all.


10 comments:

esp said...

Great job. Very interesting tests.

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

Anonymous said...

excelent article. i got 2 questipn
can we take backup of a pluggable db in clos mode and restore to different cdb

2. i like take close backup od=f pdb and ewstore in many time at different run of ugade for next 3-4 monts. this will be my golden BACKUP.
THNAKS
SYED

oakleyses said...

jordan shoes, christian louboutin, uggs outlet, michael kors outlet online, uggs on sale, louis vuitton outlet, louis vuitton outlet, louis vuitton, ray ban sunglasses, replica watches, christian louboutin uk, chanel handbags, michael kors outlet online, uggs outlet, longchamp outlet, nike air max, michael kors outlet, burberry handbags, tiffany and co, polo outlet, nike free, nike air max, ugg boots, oakley sunglasses, ray ban sunglasses, michael kors outlet online, oakley sunglasses, christian louboutin outlet, longchamp outlet, prada handbags, gucci handbags, prada outlet, oakley sunglasses wholesale, michael kors outlet, oakley sunglasses, kate spade outlet, christian louboutin shoes, louis vuitton outlet, tory burch outlet, ugg boots, michael kors outlet online, burberry outlet, cheap oakley sunglasses, louis vuitton, ray ban sunglasses, nike outlet, longchamp outlet

yanmaneee said...

jordan shoes
louboutin shoes
birkin bag
air yeezy
cheap mlb jerseys
fila
golden goose
curry 4
yeezy boost 350
off white nike

بروكر said...

I definitely love this site.
http://prokr2020.inube.com/
https://lamissibrahim11.wixsite.com/prokr2020
https://prokr2020.hatenablog.com/
https://www.prokr.net/ksa/jeddah-water-leaks-detection-isolate-companies/

shimaa shaker said...

شركة عزل فوم بجدة
شركة عزل فوم بخميس مشيط
شركة عزل فوم براس تنورة
شركة عزل فوم بمكة
شركة عوازل الرياض
شركة غسيل الخزانات بالرياض
شركة غسيل خزانات الرياض
شركة كشف تسربات المياه بالرياض
شركة كشف تسربات المياه بالرياض عماله فلبينيه
شركه تنظيف خزانات بالرياض
عزل الاسطح بالرياض

Quickbooks Phone Number said...


Nice Blog!
Facing error while using QuickBooks get instant solution with our QuickBooks experts.Dial +1-(855)533-6333 Quickbooks Enterprise Support Phone Number

Unknown said...

Nice Post !
QuickBooks Error 80029c4a 1-855-662-2O4O. It is a common error but a complex one. The error is reported by many users. If it occurs to you.

Unknown said...

Need instant help in QuickBooks? Don’t worry!! Just get in touch with our QuickBooks Support Phone Number California +1(844)233-3033, and get all your queries settled at once. Our technicians are skilled enough to handle any sort of user’s complexities.
https://tinyurl.com/yyavgpto
https://tinyurl.com/y68z6hd4
https://tinyurl.com/yyavgpto
https://tinyurl.com/y3arnu38