以resetlogs方式open数据库报错ORA-00392 ORA-00312
原创
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任
数据库:oracle 11.2.0.4
系统:AnolisOS
7.9
问题描述:Rman恢复后,以resetlogs方式打开数据库,报错ORA-00392、ORA-00312,如下所示:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 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;
Database altered.
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database clear logfile group 5;
Database altered.
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 rows selected.
SQL> alter database open resetlogs;
Database altered.
说明:成功以resetlogs方式打开数据库.
参考网址:
https://blog.csdn.net/Ruishine/article/details/125144863