How to use flashback in 12.2 PDB

Enable Flashback

SQL> Archive log list

SQL> SELECT flashback_on FROM v$database;

SQL> alter system set db_recovery_file_dest_size =200G scope=both sid='*';

SQL> show parameter db_recovery;

SQL> col name format a15

SQL> SELECT NAME, TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,

  TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE,'999,999,999,999') AS SPACE_AVAILABLE,

  ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;

SQL> ALTER DATABASE FLASHBACK ON;

SQL> SELECT flashback_on FROM v$database;

Create Restore Points

SQL> ALTER PLUGGABLE DATABASE PSBXPTL1 CLOSE;

SQL> CREATE CLEAN RESTORE POINT pdb_before_changes FOR PLUGGABLE DATABASE PSBXPTL1 GUARANTEE FLASHBACK DATABASE;

Flashback Pluggable Database

SQL> ALTER PLUGGABLE DATABASE PSBXPTL1 CLOSE;

SQL> FLASHBACK PLUGGABLE DATABASE PSBXPTL1 TO RESTORE POINT pdb_before_changes;

SQL> ALTER PLUGGABLE DATABASE PSBXPTL1 OPEN RESETLOGS;

SQL> select GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE, TIME, RESTORE_POINT_TIME, PRESERVED, NAME, PDB_RESTORE_POINT from V$RESTORE_POINT;

SQL> DROP RESTORE POINT pdb_before_changes FOR PLUGGABLE DATABASE PSBXPTL1;