Thursday, November 9, 2017

ORA-00265: how to resolve

SQL> startup mount;      
ORACLE instance started. 

Total System Global Area 1.3429E+10 bytes
Fixed Size                  2265944 bytes
Variable Size            6945770664 bytes
Database Buffers         6476005376 bytes
Redo Buffers                4612096 bytes
Database mounted.                       
SQL> alter database archivelog;         
alter database archivelog               
*                                       
ERROR at line 1:                        
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode


SQL> shutdown abort;
ORACLE instance shut down.
SQL>  startup mount force;
ORACLE instance started. 

Total System Global Area 1.3429E+10 bytes
Fixed Size                  2265944 bytes
Variable Size            6945770664 bytes
Database Buffers         6476005376 bytes
Redo Buffers                4612096 bytes
Database mounted.
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 1.3429E+10 bytes
Fixed Size                  2265944 bytes
Variable Size            6945770664 bytes
Database Buffers         6476005376 bytes
Redo Buffers                4612096 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL>  alter database open;

Database altered.

SQL>

No comments: