Restore Point Creation in Oracle

Connect to the DB

> sqlplus / as sysdba

> show pdbs

Connect to the PDB

> alter session set container=pdb_name;

> create restore point RP_Name guarantee flashback database;

Check RP creation status

select NAME,TIME,GUARANTEE_FLASHBACK_DATABASE,storage_size/1024/1024/1024 from v$restore_point;