How to Enable Archive Log Mode in Oracle 19c RAC Database: Step-by-Step Guide

 

In this article, we will learn how to enable Archive Log Mode in an Oracle 19c RAC Database.

 

Step 1: Check the current Archive Log Mode status of the RAC database.

 

SQL> select log_mode,name from v$database;

LOG_MODE NAME
———— ———
NOARCHIVELOG prod

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/product/19c/dbhome_1/dbs/arch
Oldest online log sequence 4
Current log sequence 5

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.18.0.0.0

 

Step 2: Stop the Oracle RAC database services.

 

[oracle@rac1 ~]$ srvctl stop database -d prod

[oracle@rac1 ~]$ srvctl status database -d prod
Instance prod1 is not running on node rac1
Instance prod2 is not running on node rac2

 

Step 3: Start the RAC database in MOUNT state.

 

[oracle@rac1 ~]$ srvctl start database -d prod -o mount

[oracle@rac1 ~]$ srvctl status database -d prod
Instance prod1 is running on node rac1
Instance prod2 is running on node rac2

 

Step 4: Enable Archive Log Mode and set the archive destination to an ASM Disk Group.

 

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 – Production on Wed Dec 25 15:33:31 2019
Version 19.18.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.18.0.0.0

SQL> alter system set log_archive_dest_1=’LOCATION=+DATA’ scope=both sid=’*’;
System altered.

SQL> alter database archivelog;
Database altered.

 

Step 5: Stop the Oracle RAC database services again.

 

[oracle@rac1 ~]$ srvctl stop database -d prod

 

Step 6: Restart the RAC database services.

 

[oracle@rac1 ~]$ srvctl start database -d prod

[oracle@rac1 ~]$ srvctl status database -d prod
Instance prod1 is running on node rac1
Instance prod2 is running on node rac2

[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Dec 25 16:54:23 2019
Version 19.18.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.18.0.0.0

 

Step 7: Verify the Archive Log Mode status to confirm the changes.

 

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 5

SQL> select log_mode,name from v$database;
LOG_MODE NAME
———— ———
ARCHIVELOG prod