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.

12 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.

  4. ORA-00283: recovery session canceled due to errors
    ORA-01115: IO error reading block from file 3 (block # 201)
    ORA-01110: data file 3: ‘E:\APP\USER\ORADATA\AISM\UNDOTBS01.DBF’
    ORA-27070: async read/write failed
    OSD-04016: Error queuing an asynchronous I/O request.
    O/S-Error: (OS 23) Data error (cyclic redundancy check).

  5. Hellow Masters.
    Can you help me solving this Issue, please .
    I have tried out many ways.but failed.
    i have no backup file to restore/recover.
    HOw to oversome this issue ?

    ORA-00283: recovery session canceled due to errors
    ORA-01115: IO error reading block from file 3 (block # 201)
    ORA-01110: data file 3: ‘E:\APP\USER\ORADATA\AISM\UNDOTBS01.DBF’
    ORA-27070: async read/write failed
    OSD-04016: Error queuing an asynchronous I/O request.
    O/S-Error: (OS 23) Data error (cyclic redundancy check).

Leave a Reply to PrinceCancel reply