Disable archive configuration in Oracle RAC Environment

1. Stop the Oracle database with SRVCTL command to stop DB on all instances:

[oracle@host01 ~]$ srvctl stop database -db orcl

2. Connect with Oracle database and Connect with SQLPLUS utility

--- Set the environment 
[oracle@host01 ~]$ . oraenv

ORACLE_SID = [orcl1] ? 

The Oracle base remains unchanged with value /u01/app/oracle


-- connect with sqlplus and start database in mount state
[oracle@host01 ~]$ sqlplus / as sysdba


SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 10 10:14:44 2024

Version 19.3.0.0.0


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


Connected to an idle instance.


SQL> 

3. Starting database in mount stage

SQL> startup mount
ORACLE instance started.
Total System Global Area 2399140616 bytes
Fixed Size		    8899336 bytes
Variable Size		  587202560 bytes
Database Buffers	 1795162112 bytes
Redo Buffers		    7876608 bytes
Database mounted.

4. Disable the archive log

SQL> alter database noarchivelog;
Database altered.

5. Verify and exit the sqlplus

SQL> archive log list;
Database log mode	       No Archive Mode
Automatic archival	       Disabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     9
Current log sequence	       10
SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

6. Start the database with SRVCTL command and verify the status for all instances:

[oracle@host01 ~]$ srvctl start database -d orcl

[oracle@host01 ~]$ 


[oracle@host01 ~]$ srvctl status database -d orcl

Instance orcl1 is running on node host01

Instance orcl2 is running on node host02

Instance orcl3 is running on node host03