Change Archive Mode in Oracle Database

1. Check status of archivelog

select log_mode from v$database;

2. Shutdown Database

shutdown immediate;

3. Startup Database in Mount-Mode

startup mount;

4. Alter Database

alter database noarchivelog;

or

alter database archivelog;

5. Open Database

alter database open;

6. Check if the archivlog is correct

select log_mode from v$database;