When trying to find the name of a restore point that has one or all of its flashback logs not available you will get this error:
SQL> select * from v$restore_point;
select * from v$restore_point
*
ERROR at line 1:
ORA-38701: Flashback database log 112 seq 10593 thread 1: "/fra/ERDB/flashback/o1_mf_gbd00tqk_.flb"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
You have to get the restore point name from RMAN which read the details from the controlfile instead of the dictionary:
RMAN> list restore point all;
using target database control file instead of recovery catalog
SCN RSP Time Type Time Name
---------------- --------- ---------- --------- ----
6418212255444 GUARANTEED 01-JUL-19 TEMP
Drop the restore point from SQLPLUS:
SQL> drop restore point temp;
SQL> select * from v$restore_point;
select * from v$restore_point
*
ERROR at line 1:
ORA-38701: Flashback database log 112 seq 10593 thread 1: "/fra/ERDB/flashback/o1_mf_gbd00tqk_.flb"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
You have to get the restore point name from RMAN which read the details from the controlfile instead of the dictionary:
RMAN> list restore point all;
using target database control file instead of recovery catalog
SCN RSP Time Type Time Name
---------------- --------- ---------- --------- ----
6418212255444 GUARANTEED 01-JUL-19 TEMP
Drop the restore point from SQLPLUS:
SQL> drop restore point temp;