Wednesday, 24 July 2019

ORA-38701 ORA-27037 when select * from v$restore_point;

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;

No comments:

Post a Comment