Change Archive Log Mode in Oracle Database

In this topic, I will show how to change Archive Log Mode in Oracle Database.

Enable Archive Log Mode in RAC:

Archive Log Status:

SQL> SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
------------
NOARCHIVELOG

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     23
Current log sequence           24

Stop database using srvctl:

[oracle@ocmnode1 dbs]$ srvctl stop database -d orcl

[oracle@ocmnode1 dbs]$ ps -ef | grep smon
grid      5695     1  0 11:18 ?        00:00:00 asm_smon_+ASM1
root      5742     1  0 11:18 ?        00:01:52 /u01/app/12.1.0/grid/bin/osysmond.bin
grid      6440     1  0 11:19 ?        00:00:00 mdb_smon_-MGMTDB
oracle   30967  8552  0 17:46 pts/1    00:00:00 grep smon

Start Database with mount mode in one node and change the mode:

startup mount;
alter database archivelog;
alter database open;
archive log list;
shutdown immediate;
[oracle@ocmnode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 14 17:47:39 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  2929936 bytes
Variable Size             692062960 bytes
Database Buffers          138412032 bytes
Redo Buffers                5455872 bytes
Database mounted.

SQL> alter database archivelog;
Database altered.

SQL> alter database open;
Database altered.

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

Startup using srvctl for RAC:

[oracle@ocmnode1 dbs]$ srvctl start database -d orcl

Validation:

SQL> SELECT LOG_MODE FROM V$DATABASE;

LOG_MODE
------------
ARCHIVELOG

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     24
Next log sequence to archive   25
Current log sequence           25

Disable Archive Log Mode in RAC:

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     22
Next log sequence to archive   23
Current log sequence           23

Shutdown Database Using SRVCTL:

[oracle@ocmnode1 dbs]$ srvctl stop database -d orcl

Startup database in mount mode in one node and change the mode:

[oracle@ocmnode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 14 17:35:59 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  2929936 bytes
Variable Size             692062960 bytes
Database Buffers          138412032 bytes
Redo Buffers                5455872 bytes
Database mounted.
SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     23
Current log sequence           24

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

Start database using SRVCTL:

[oracle@ocmnode1 dbs]$ srvctl start database -d orcl

1 ping

  1. […] Change Archive Log Mode in Oracle Database […]

Leave a Reply