ORA-38701:Flashback database log 1 seq 1 thread 1 and ORA-27037: unable to obtain file status

• Postgres SQL installation on Linux
• PRIF-33: Failed to set or delete interface because hosts could not be discovered | CRS-02325: Unable to get Grid Plug and Play (GPnP) profile from requested cluster nodes
• Post Patch PRCR-1105 : Failed to relocate resource ora.mgmtdb to node oracledbworld02 PRCR-1089 : Failed to relocate resource ora.mgmtdb Oracle 19c
• OEM13c : Admin Server Port is occupied by another process. Please stop process to free port
• Expdp using VIEWS_AS_TABLES in Oracle 19c

Hello Readers,

I know I was away from blog due to personal issues. Now it is resolved and we are back to posting. Today, we found an issues on UAT server where someone removed the /FRA mount point which was given to us for Flashback logs.

ERROR at line 1:
ORA-38701: Flashback database log 1 seq 1 thread 1:
"/FRA/<database_name>/FRA/<instance_name>/flashback/ol_mf_hdkko_.flb"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7

Background story

1 DB had 1 restore point
2 DB was in archive log mode.
3 DB was in hung state when it was highlighted to us.

Since mount point didn’t exists we were unable to fire any select related to flashback logs/restore point. If we try to do that, for instance if I try to fire following command –>

SQL> select * from v$restore_point;
select * from v$restore_point;

ERROR at line 1:
ORA-38701: Flashback database log 1 seq 1 thread 1:
"/FRA/<database_name>/FRA/<instance_name>/flashback/ol_mf_hdkko_.flb"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7

Since it none of our commands were working for us, we were unable to find the restore point details through SQLPLUS

Solution –>

1. Change the archive destination to existing mount point.
   

show parameter dest_1
alter system set log_archive_dest_1='location=/DATA';

2. Connect to the database using RMAN and check for list restore point all;

RMAN> list restore point all;
using target database control file instead of recovery catalog
SCN           RSP TIME            TYPE            TIME      NAME
123456789                      GUARANTEED      23-JAN-21  RESTORE_POINT

3. Connect as sqlplus and drop the restore point.

SQL>drop restore point RESTORE_POINT;

And Finally application team were able to connect.