|
昨天在做数据库升级时,执行 alter database open resetlogs upgrade 命令时,直接就报:
ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 3 thread 1: '/u01/oradata/orcl/redo03.log'
查看当前日志组状态:
SQL> select group#,bytes/1024/1024||'M',status from v$log;
GROUP# BYTES/1024/1024||'M' STATUS
---------- ----------------------------------------- ----------------
1 50M CLEARING
3 50M CLEARING_CURRENT
2 50M CLEARING
经搜迅baidu,才知道,这个问题,只需要手工直接清除该日志即可
SQL> alter database clear logfile group 3;
之后,再去查看
SQL> select group#,bytes/1024/1024||'M',status from v$log;
GROUP# BYTES/1024/1024||'M' STATUS
---------- ----------------------------------------- ----------------
1 50M CLEARING
3 50M CURRENT
2 50M CLEARING
重新执行
alter database open resetlogs upgrade ;
就好了。
|
|