restore point

 SQL> select NAME,TIME,SCN,PDB_RESTORE_POINT,GUARANTEE_FLASHBACK_DATABASE from V$RESTORE_POINT;

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 SRAM2I                         READ WRITE NO

SQL> alter session set container=SRAM2I;

Session altered.

SQL> alter pluggable database SRAM2I CLOSE;

Pluggable database altered.

SQL> SQL>

SQL> flashback pluggable database SRAM2I to restore point RESTORE_POINT2_REQ0088666;

Flashback complete.

SQL> alter pluggable database SRAM2I open resetlogs;

Pluggable database altered.

SQL> shut immediate;

Pluggable Database closed.

==================================================================================

znfodRAMfsd011  $ srvctl stop database -d SRAM2IC

znfodRAMfsd011  $ srvctl start database -d SRAM2IC

znfodRAMfsd011  $ srvctl start listener -l SRAM2IC