这篇文章主要介绍“怎么解决数据库执行alter database open resetlogs时提示ORA-00392错误”，在日常操作中，相信很多人在怎么解决数据库执行alter database open resetlogs时提示ORA-00392错误问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么解决数据库执行alter database open resetlogs时提示ORA-00392错误”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

问题现象：打开数据库，提示错误

RMAN>alterdatabaseopenresetlogs;RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofalterdbcommandat12/17/201811:22:26ORA-00392:log2ofthread1isbeingcleared,operationnotallowedORA-00312:onlinelog2thread1:'/u02/app/oracle/oradata/cams/redo02.log'

问题描述

[oracle@SIT130093~]$oerrORA0039200392,00000,"log%softhread%sisbeingcleared,operationnotallowed"//*Cause:Anoperationencounteredthisonlineloginthemiddleofbeing//cleared.Thecommandthatbegantheclearingmayhaveterminated//withoutcompletingtheclearing.//*Action:Iftheclearcommandisstillexecutingthenwaitforits//completion.Ifitterminatedthenreissuetheclearcommand,or//dropthelog.

解决方案

SYS@cams>selectGROUP#,STATUSfromv$log;GROUP#STATUS--------------------------1CLEARING3CLEARING2CLEARING_CURRENTSYS@cams>alterdatabaseclearlogfilegroup1;Databasealtered.SYS@cams>alterdatabaseclearlogfilegroup2;Databasealtered.SYS@cams>alterdatabaseclearlogfilegroup3;Databasealtered.SYS@cams>selectGROUP#,STATUSfromv$log;GROUP#STATUS--------------------------1UNUSED3UNUSED2CURRENT

RMAN>alterdatabaseopenresetlogs;databaseopened

如果使用clear logfile的方案不好使，可采用如下方案：

RecreatethecontroflilewiththeRESETLOGSoption.1)Getthecontrolfiletracefrombelowcommand:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACEAS'/tmp/control.sql'resetlogs;2)ModifytheCREATECONTROLFILEscript/tmp/control.sqlandensurethatalldirectoriesfortheonlineredologsexistandOraclehaspermissiontowritetoit3)CreatethecontrolfileinNOMOUNTstate:SQL>STARTUPFORCENOMOUNTSQL>@/tmp/control.sqlcontrolfilecreated4)Runafakerecovery:SQL>RECOVERDATABASEUSINGBACKUPCONTROLFILEUNTILCANCEL;Type<CANCEL>whenprompted5)OpenwithRESETLOGSoption:SQL>ALTERDATABASEOPENRESETLOGS;

到此，关于“怎么解决数据库执行alter database open resetlogs时提示ORA-00392错误”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！