DataGuard增加standby日志组报错"ORA-01156: recovery or flashback"

jiawang

SQL> alter database add standby logfile thread 1 group 7 '/oradata/orcl/logfile/stdy7.log' size 100m;
alter database add standby logfile thread 1 group 7 '/oradata/emr/logfile/stdy7.log' size 100m
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files


解决方法：
关闭备库日志应用进程

SQL> alter database recover managed standby database cancel;
Database altered.

SQL> alter database add standby logfile thread 1 group 7'/oradata/orcl/logfile/stdy14.log' size 100m;
Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.