PITR on non-essential tablespace

PITR on non-essential tablespace

Lets' first log scn before issue.

SQL> select timestamp_to_scn(sysdate) from v$database;

TIMESTAMP_TO_SCN(SYSDATE)
-------------------------
          2809058

SQL> delete from local_test.tab_test where rownum < 3;

2 rows deleted.

SQL> commit
  2  ;

Commit complete.

SQL> select * from local_test.tab_test;

     C
----------
     3
     4

[oracle@edbtr43p0 trace]$ rman target /

RMAN> alter pluggable database pdb2_2 close;

using target database control file instead of recovery catalog
Statement processed

RMAN> run {
2> set until scn = 2809058;
3> restore pluggable database pdb2_2;
4> recover pluggable database pdb2_2 auxiliary
5> destination='/u01/app/oracle/oradata';
6> alter pluggable database pdb2_2 open resetlogs;
7> }

RMAN> exit


$ sqlplus sys@pdb2_2 as sysdba
SQL> select * from local_test.tab_test;

     C
----------
     1
     2
     3
     4










RMAN> delete obsolete;
RMAN> backup database plus archivelog delete all input;