Oracle DBA Operation: change archivelog mode

Change database archivelog mode

1. be sure to stop database firstly: 

sqlplus /nolog

conn / as sysdba

shutdown immediate

2. startup mount database without open database instance

startup mount

3. change the archivelog mode

alter database noarchivelog;

or

alter database archivelog;

4. open database

alter database open;

You can query archivelog mode by using

select log_mode from v$database;