A restore point records the SCN of the database at the time the restore point was created. The restore point acts like a synonym for the particular SCN. It allows you to restore and recover to an SCN without having to specify a number. RMAN will restore and recover up to, but not including, the SCN associated with the restore point.
You can view restore point information in the V$RESTORE_POINT view. That view contains information such as NAME, SCN, TIME, and DATABASE_INCARNATION#.
CREATING A NORMAL RESTORE POINT
SQL> create restore point MY_RP;
This command creates a restore point named MY_RP that is associated with the SCN of the database at the time the command was issued. You can view the current SCN of your database as shown here:
SQL> select current_scn from v$database;
You can also view the SCN assigned to your restore point(s):
SQL> select name, scn from v$restore_point;
How to use RP?
RMAN> connect target /
RMAN> startup mount;
RMAN> restore database until restore point MY_RP;
RMAN> recover database until restore point MY_RP;
RMAN> alter database open resetlogs;