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

Error description:

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Cause:

The database was crashed itself or you issued shutdown abort or startup force commands.

In my case I issued the following command, to take database into mount state.

SQL> startup mount force;

Solution:

SQL> select status from v$instance;

STATUS
————————————
MOUNTED

SQL> alter database open;

Database altered.

SQL> shutdown immediate;

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 88081064 bytes
Database Buffers 197132288 bytes
Redo Buffers 7139328 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

 

 

 

Advertisement

About Mariami Kupatadze
Oracle Certified Master Linkedin: https://www.linkedin.com/in/mariami-kupatadze-01074722/

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

  1. Carolina says:

    Thanks a lot for your post, it helped me a lot.

  2. Prakash Aako says:

    Thanks for these comments.

  3. Mr Anderson says:

    Thank you very much much much!

  4. himanshu says:

    nice explanation worked for me. thanks

  5. u r post is very helpful for me.

  6. Fad Muhammad says:

    Thank you, my problem has solved!

  7. Pingback: Ora 00265 Instance Recovery Required Cannot Set Archivelog Mode | How To Resolve Ora-00265:Instance Recovery Required, Cannot Set Archivelog Mode In Oracle Db – Demo! 29207 투표 이 답변

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: