How to manage restore points
A practical guide to creating and managing restore points in Oracle, including PDB-level considerations
Before creating a restore point, you need to be sure you're in the correct instance:
select name, INSTANCE_NAME from v$database, v$instance;