暂无图片
DG修改备库redo时,删除备库当前current redo日志时报错,求解
我来答
分享
吾喾
2022-06-01
DG修改备库redo时,删除备库当前current redo日志时报错,求解

SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01623: log 1 is current log for instance orcldg1 (thread 1) - cannot drop
ORA-00312: online log 1 thread 1: '+DATA/orcldg/onlinelog/group_1.261.1106230739'
ORA-00312: online log 1 thread 1: '+FRA/orcldg/onlinelog/group_1.342.1106230739'

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
吾喾

暂定为bug,DG同步不受影响。

Bug 16091872 - ORA-01623 / ORA-01624 / ORA-01567 dropping ORL on a STANDBY database (Doc ID 16091872.8)

Description

"alter database drop logfile" on a Standby Database to drop an Online Redo Log (ORL) may fail 
with bogus errors such as ORA-01623 or ORA-01624 or ORA-01567.
 
This fix enables to DROP ORL on Standby and ORL on Standby will not be updated with ORL 
on Primary changes. V$LOG will also show status UNUSED for ORLs in STANDBY.
 

 

暂无图片 评论
暂无图片 有用 0
暂无图片
吾喾

alter database clear logfile group 1;

alter database drop logfile group 1;

还是报同样的错误

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏