Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the ORA-00392 error when the database executes alter database open resetlogs". In the daily operation, I believe that many people have doubts about how to solve the problem of ORA-00392 error when the database executes alter database open resetlogs. The editor consulted all kinds of materials and sorted out simple and useful operation methods. I hope it will be helpful for you to answer the question of "how to solve the ORA-00392 error when the database executes alter database open resetlogs"! Next, please follow the editor to study!

Problem phenomenon: open the database and prompt an error

RMAN > alter database open resetlogs; RMAN-00571: = = RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = RMAN-00571: = = RMAN-03002: failure of alter db command at 12 of thread 17 11:22:26ORA-00392 2018 11:22:26ORA-00392: log 2 of thread 1 is being cleared, operation not allowedORA-00312: online log 2 thread 1:'/ u02 online log

Problem description

[oracle@SIT130093 ~] $oerr ORA 0039200392, 00000, "log% s of thread% s is being cleared, operation not allowed" / / * Cause: An operation encountered this online log in the middle of being// cleared. The command that began the clearing may have terminated// without completing the clearing.// * Action: If the clear command is still executing then wait for its// completion. If it terminated then reissue the clear command, or// drop the log.

Solution

SYS@cams > select GROUP#,STATUS from vault log; GROUP# STATUS--1 CLEARING 3 CLEARING 2 CLEARING_CURRENT SYS@cams > alter database clear logfile group 1; Database altered. SYS@cams > alter database clear logfile group 2; Database altered. SYS@cams > alter database clear logfile group 3; Database altered. SYS@cams > select GROUP#,STATUS from vault log; GROUP# STATUS--1 UNUSED 3 UNUSED 2 CURRENTRMAN > alter database open resetlogs; database opened

If the scheme for using clear logfile does not work, you can use the following scheme:

Recreate the controflile with the RESETLOGS option.1) Get the controlfile trace from below command: SQL > ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS'/ tmp/control.sql' resetlogs; 2) Modify the CREATE CONTROLFILE script / tmp/control.sql and ensure that all directories for the online redo logs exist and Oracle has permission to write to it3) Create the controlfile in NOMOUNT state: SQL > STARTUP FORCE NOMOUNTSQL > @ / tmp/control.sqlcontrolfile created4) Run a fake recovery: SQL > RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; Type when prompted5) Open with RESETLOGS option:SQL > ALTER DATABASE OPEN RESETLOGS At this point, the study on "how to solve the ORA-00392 error when the database executes alter database open resetlogs" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.