How to Enable/Disable Archive log mode in Oracle

How to Disable Archive Log Mode:

sqlplus  / as sysdba

SQL > archive log list

Database log mode         Archive mode
Automatic archival         Enabled
Archive Destination        USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence   19
Next log sequence                 20
Current log sequence            20

here you will see Automatic archival log mode ON or Enable.

Exceute below command from SQLPLUS : (Disable the Archive log)

SQL> shutdown immediate;
SQL> startup mount
SQL> alter database NOARCHIVELOG;
SQL> shutdown immediate
SQL> startup;
SQL> exit;

How to Enable Archive Log Mode :


sqlplus / as sysdba

SQL> archive log list

Database log mode           NO Archive Mode
Automatic archival           Disabled
Archive  destination          USE_DB_RECOVERY_FILE_DEST
Oldest online Log Sequence        19
Next log sequence to archive       20
current log sequence                    20

here you will see automatic archival -Disable.That means Archive is OFF or Disabled.

Execute the below command from SQLPLUS: (To enable the Archive Log Mode)

SQL> shutdown immediate;
SQL> startup mount
SQL> alter database ARCHIVELOG;
SQL> shutdown immediate
SQL> startup;
SQL> exit;