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

标题: Dropping Redo Log Files Failing With ORA-1623 [打印本页]

作者: 刘泽宇 时间: 2021-7-4 13:28
标题: Dropping Redo Log Files Failing With ORA-1623
本帖最后由刘泽宇于 2021-7-4 13:29 编辑

现象：Unable to drop redo log files as failing with ORA-01623

SQL>Alter database drop logfile group 20;
Alter database drop logfile group 20
*
ERROR at line 1:
ORA-01623: log 20 is current log for instance i4 (thread 4) - cannot drop
ORA-00312: online log 20 thread 4:

处理方法：

Disable Thread <Thread Number> using below command and drop the Logfiles associated to that Thread.

conn / as sysdba

alter database disable thread 4;

alter database drop logfile group ;

参照官方文档： ID 2341816.1

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