Deleting Guaranteed Flashback restoepoints when v$restore_point view showing error

If you delete the flashback logs unexpectedly with out dropping Guaranteed Flashback Restore Points in Database, you will get following Error while select restore points from v$restore_point view.

SQL> select * from v$restore_point;
select * from v$restore_point
              *
ERROR at line 1:
ORA-38701: Flashback database log 142 seq 326 thread 1:
"C:\APP\ORACLE\FLASH_RECOVERY_AREA\ECPIX\FLASHBACK\O1_MF_8O59SSWM_.FLB"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Solution:

If we don't know restore points names, we can get the Restore points through RMAN Commands as mentioned below.

RMAN> list restore point all;
SCN              RSP Time  Type       Time      Name
---------------- --------- ---------- --------- ----
34541743                   GUARANTEED 28-MAR-13 BEFORE_CHANGES

Connect to sql prompt and drop the restore points.

SQL>drop restore point BEFORE_CHANGES;
SQL>select * from v$restore_point;


Note: After recieving this error if you turn off the flashback of the database, after that you can't turn on the flashback. To turn on the Flashback of database we have to drop the old restore points using above steps.