Setting Oracle Database to Archivelog / Noarchivelog

Setting ORACLE DB into noarchivelog / archivelog mode

NOTE: To change log_mode the database must be in Exclusive mount state


1. Login to sqlplus
-sqlplus /nolog
-connect / as sysdba
2. The db must be mounted EXCLUSIVE and not open for operation
-startup mount;
3. Check the log mode status of the database
-select log_mode from v$database;
4. Setting it to noarchivelog mode
-alter database noarchivelog;
5. Setting db open for user operation
-alter database open;
6. Reverting back to archivelog mode
-alter database archivelog;