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.