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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s