重庆思庄Oracle、Redhat认证学习论坛

标题: DataGuard增加standby日志组报错"ORA-01156: recovery or flashback" [打印本页]

作者: jiawang 时间: 2024-4-19 09:18
标题: DataGuard增加standby日志组报错"ORA-01156: recovery or flashback"
本帖最后由 jiawang 于 2024-4-19 09:18 编辑

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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)