Wednesday, December 12, 2012

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

SQL> shutdown immediate ;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount ;
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2095704 bytes
Variable Size             155190696 bytes
Database Buffers          121634816 bytes
Redo Buffers                6291456 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 immediate ;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup ;
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2095704 bytes
Variable Size             155190696 bytes
Database Buffers          121634816 bytes
Redo Buffers                6291456 bytes
Database mounted.
Database opened.
SQL>

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

Total System Global Area  285212672 bytes
Fixed Size                  2095704 bytes
Variable Size             155190696 bytes
Database Buffers          121634816 bytes
Redo Buffers                6291456 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

8 comments:

  1. thank you... now archive is enabled

    ReplyDelete
  2. Thank u so much Osama!!! :)

    Am also face this issue i follwed your steps now it's working fine...






    ReplyDelete
  3. sir i want to know that why shutdown immediate command is given two times

    ReplyDelete
  4. shut immediate;
    ORA-01109: database not open


    Database dismounted.
    ORACLE instance shut down.
    SQL> startup mount;
    ORACLE instance started.

    Total System Global Area 414298112 bytes
    Fixed Size 1336904 bytes
    Variable Size 247466424 bytes
    Database Buffers 159383552 bytes
    Redo Buffers 6111232 bytes
    Database mounted.
    SQL> alter database archivelog;
    alter database archivelog
    *
    ERROR at line 1:
    ORA-00265: instance recovery required, cannot set ARCHIVELOG mode


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

    ReplyDelete
    Replies
    1. Follow the below :-
      SQL> startup mount force;
      SQL> select status from v$instance;
      SQL> alter database open;
      SQL> shutdown immediate;
      SQL> startup mount;
      SQL> alter database archivelog;
      SQL> alter database open;

      Delete