ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
August 30, 2012 7 Comments
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
————————————
MOUNTEDSQL> 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.
Thanks a lot for your post, it helped me a lot.
Thanks for these comments.
Thank you very much much much!
nice explanation worked for me. thanks
u r post is very helpful for me.
Thank you, my problem has solved!
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 투표 이 답변