Disabling ARCHIVELOG mode is usually done in test or development environments where backups and point-in-time recovery are not required.

Never disable ARCHIVELOG mode in production databases, because recovery options will be limited.

Now let’s start step by step.

STEP 1: Check Current Archive Log Mode

SQLPLUS / as sysdba
ARCHIVE LOG LIST;

Example:

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            C:\archive
Oldest online log sequence     26
Next log sequence to archive   26
Current log sequence           24

STEP 2: Shutdown the Database

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

STEP 3: Start Database in MOUNT Mode

SQL> startup mount
ORACLE instance started.

Total System Global Area 1603572120 bytes
Fixed Size                  5206424 bytes
Variable Size             973078528 bytes
Database Buffers          620756992 bytes
Redo Buffers                4530176 bytes
Database mounted.

STEP 4: Disable ARCHIVELOG Mode

SQL> alter database noarchivelog;

Database altered.

STEP 5: Open the Database

SQL> alter database open;

Database altered.

STEP 6: Verify ARCHIVELOG Mode Is Disabled

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            C:\archive
Oldest online log sequence     26
Current log sequence           24