Db is in archive log mode, have pluggable database backup.
backup:
backup as compressed backupset PLUGGABLE database PRDBORCL1 format '/tmp/testing_pdb/testing_%U';
restore:
connecting to cdb or direct pdb and restore did not help to get tablspace TSPITR successfully..
RUN
{
SQL 'ALTER TABLESPACE testing OFFLINE IMMEDIATE';
RESTORE TABLESPACE testing;
recover tablespace testing until time "to_date('09:40 12-10-2016 ','hh24:mi dd-mm-yyyy')" auxiliary destination '/tmp/';
SQL 'ALTER TABLESPACE testing ONLINE';
}
ORA-00959: tablespace 'testing' does not exist
prefixing like pdb.tablespacename also did not help..
run{
sql 'alter database datafile 14 offline';
restore datafile 14;
recover datafile 14 until time "to_date('09:40 12-10-2016 ','hh24:mi dd-mm-yyyy')" auxiliary destination '/tmp/';
sql 'alter database datafile 14 online';
}
RMAN-11003: failure during parse/execution of SQL statement: alter database datafile 14 offline
ORA-01516: nonexistent log file, data file, or temporary file "14"
note, datafile 14 is the file of tablespace we want to restore and it exists...
when running with pdb:
RMAN-03002: failure of recover command at 10/12/2016 16:51:04
RMAN-07536: command not allowed when connected to a Pluggable Database
restore and recover at whole pdb level works and TBPITR level is not working..
is't not tablespace point in time recovery supported in pluggable database in 12c ??