ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Today, I came across the “ORA-00265: instance recovery required, cannot set ARCHIVELOG mode” while converting database into archive log mode.

This error usually caused when database crashed unfortunately or we shutdown database with the help of database shutdown command as: shutdown abort, startup force mount or shutdown abort. These types of command will required instance recovery in next startup. In short it need clean database startup.

In my case, i am trying to alter database in archive log mode with “startup force mount” command:
SQL> startup force mount
ORACLE instance started.

Total System Global Area 1503199232 bytes
Fixed Size 2288584 bytes
Variable Size 905970744 bytes
Database Buffers 587202560 bytes
Redo Buffers 7737344 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

 

// Solution:

SQL> select open_mode from v$database;

OPEN_MODE
——————–
MOUNTED

// Open your database and shutdown it normally, as follow:

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

// Now startup database in mount state:
SQL> startup mount
ORACLE instance started.

Total System Global Area 1503199232 bytes
Fixed Size 2288584 bytes
Variable Size 905970744 bytes
Database Buffers 587202560 bytes
Redo Buffers 7737344 bytes
Database mounted.

// Now issue following to convert database into archivelog mode:
SQL> alter database archivelog;

Database altered.

// Now open database:
SQL> alter database open;

Database altered.

Database has been configured in archivelog without oracle error:ORA-00265, because this time we shutdown our database in normal way.

 

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

8 thoughts on “ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

  1. This solution did not work in my case. Am unable to start up database immediate or normal as it hungs with this option. Only shutdown abort works. How can this be resolved?

  2. Thank you Prince for writing…
    If you issue shutdown abort than you will get same error for which you have reached my post.
    Just issue shutdown immediate; command to shutdown database properly. When it done, than follow the given steps.

  3. why it is giving “ORA-00265: instance recovery required, cannot set ARCHIVELOG mode” on giving archivelog after startup force mount.

    • Because “Startup force” command is combination of “Shutdown abort” and “Startup”, and while converting database in archivelog mode, clean shutdown(immediate) is expected.

Leave a Reply to Jignesh Jethwa Cancel reply

%d bloggers like this: