ORA-01156: recovery or flashback in progress may need access to files
Cause:
I tried to drop a standy redolog member and got error due to active recovery in standby database
SQL> alter database drop logfile member '+FRA/ORCL/ONLINELOG/group_10.260.1031504657';
alter database drop logfile member '+FRA/ORCL/ONLINELOG/group_10.260.1031504657'
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files
Workaround:
Cancel the MRP
SQL> alter database recover managed standby database cancel;
Database altered.
Drop the logfile
SQL> alter database drop logfile member '+FRA/ORCL/ONLINELOG/group_10.260.1031504657';
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.