Error: While trying to configure the Archivelog mode of Oracle Database, getting the following error:

SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog' SCOPE=SPFILE;

System altered.

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

Solution:

We need to shut down the database, then reopen it to start the recovery process. After that, we’ll shut it down again and open it in mount state to configure Archive log mode.

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area  704641784 bytes
Fixed Size		    9689848 bytes
Variable Size		  507510784 bytes
Database Buffers	  180355072 bytes
Redo Buffers		    7086080 bytes
Database mounted.
Database opened.
 
SQL> alter pluggable database all open;
Pluggable database altered.

SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog' SCOPE=SPFILE;
System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
 
SQL> startup mount
ORACLE instance started.
Total System Global Area  704641784 bytes
Fixed Size		    9689848 bytes
Variable Size		  511705088 bytes
Database Buffers	  176160768 bytes
Redo Buffers		    7086080 bytes
Database mounted.

SQL> alter database archivelog;
Database altered.

SQL> alter database open;