"Small error" from archive is encountered ora-00265:instance recovery required, cannot set ARCHIVELOG mode

Source: Internet
Author: User

Today I encountered ora-00265:instance recovery required, Cannot set ARCHIVELOG mode error while archiving

from the error we can see is because of Datafile,controlfile, The mismatch in the SCN number in the Redolog prevents the archive from being opened, so the workaround for this problem is that the startup force mount is used when I restart the database to mount, as this command actually takes two steps. For example the following:
1, Shutdown abort   ---Forcibly shut down database
2, startup Mount

  Since we implicitly did the shutdown abort operation. It means datafile. Controlfile. Redolog the SCN in this must be inconsistent, you need to do recover in the open database, because their SCN number is inconsistent, so it will not be able to open archivelog in the Mount state, for example:

SQL>alterdatabase  archivelog; Alter Database Archivelog *  1: ORA-00265set ARCHIVELOG mode

The solution is as follows:
Take the database to the open state, gracefully close shutdown immediate, and then mount the state:

Sql> Alter Database Open ;Databasealtered. SQL> shutdownImmediateDatabaseclosed.Databasedismounted. ORACLE instance shut down. SQL>startup Mount; ORACLE instance started. Total System Global Area830930944bytesfixed Size2257800bytesvariable Size536874104bytesDatabaseBuffers289406976Bytesredo Buffers2392064bytesDatabasemounted. SQL> Alter DatabaseArchivelog;Databasealtered. SQL>ArchiveLoglist;Database Logmode Archive modeautomatic archival enabledarchive destination Use_db_recovery_f Ile_destoldest OnlineLogSequence5Next LogSequence toArchive7 Current LogSequence7

Solve, bingo~~~~

"Small error" from archive is encountered ora-00265:instance recovery required, cannot set ARCHIVELOG mode

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.