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

标题: ORA-00392: log 3 of thread 1 is being cleared, operation not allowed [打印本页]

作者: denglj 时间: 2022-8-23 13:54
标题: ORA-00392: log 3 of thread 1 is being cleared, operation not allowed

数据库：oracle 11.2.0.4

系统：AnolisOS7.9

问题描述：Rman恢复后，以resetlogs方式打开数据库，报错ORA-00392、ORA-00312，如下所示：

SQL>alter database open resetlogs;

alterdatabase open resetlogs

ERROR atline 1:

ORA-00392:log 3 of thread 1 is being cleared, operation not allowed

ORA-00312:online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'

异常原因：在线日志文件log 3正在被清除，无法open数据库.

解决过程如下：

SQL>select group#,status from v$log;

GROUP# STATUS

--------------------------

1 CLEARING

2 CLEARING

3 CLEARING_CURRENT

4 CLEARING

5 CLEARING

6 CLEARING

7 CLEARING

8 CLEARING

9 CLEARING

10 CLEARING

11 CLEARING

GROUP# STATUS

--------------------------

12 UNUSED

12 rows selected.

SQL>alter database clear logfile group 4;

Databasealtered.

SQL>alter database clear logfile group 3;

Databasealtered.

SQL>alter database clear logfile group 5;

Databasealtered.

SQL>select group#,status from v$log;

GROUP# STATUS

--------------------------

1 CLEARING

2 CLEARING

3 CURRENT

4 UNUSED

5 UNUSED

6 CLEARING

7 CLEARING

8 CLEARING

9 CLEARING

10 CLEARING

11 CLEARING

GROUP# STATUS

--------------------------

12 UNUSED

12 rowsselected.

SQL>alter database open resetlogs;

Databasealtered.

说明：成功以resetlogs方式打开数据库.

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