How To Set Database To Noarchivelog

Login to sqlplus

# sqlplus /nolog
SQL> connect / as sysdba

The db must be mounted EXCLUSIVE and not open for operation

SQL> shutdown immediate;
SQL> startup mount;

Check the log mode of the database

SQL> select log_mode from v$database;

Set it to noarchivelog mode

SQL> alter database noarchivelog;

Set db open for user operation

SQL> alter database open;