Convert Oracle Database from No Archive Mode to Archive Mode

 Step:1 Check the current archive status.

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     210

Current log sequence           212

Step:2 Change the archive log location.

SQL> alter system set log_archive_dest_1='location=/oradata/archive' scope=both;

System altered.

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /oradata/archive

Oldest online log sequence     210

Current log sequence           212

Step:3 Stop the database and start in Mount mode.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 6157238272 bytes

Fixed Size                  8615744 bytes

Variable Size            1291847872 bytes

Database Buffers         4848615424 bytes

Redo Buffers                8159232 bytes

Database mounted.

Step:4 Change database from no archivelog to archivelog .

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oradata/archive

Oldest online log sequence     210

Next log sequence to archive   212

Current log sequence           212