You can use the dbed_ckptrollback command to rollback an Oracle database to a Storage Checkpoint.
Before performing a Storage Rollback, the following conditions must be met:
To rollback a tablespace to a Storage Checkpoint
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD \ -H /oracle/product/ORA_HOME -T DATA01 -c Ckpt_903937870
If the Oracle database is running, you must take the tablespace offline before running this command. If the tablespace is online, the command will fail.
To rollback datafiles to a Storage Checkpoint
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD \ -H /oracle/product/ORA_HOME \ -F /share/oradata1/data01.dbf,/share/oradata2/index01.dbf \ -c Checkpoint_903937870
If the Oracle database is running, you must take the datafile offline before running this command. If the datafile is online, the command will fail.