HOW TO ENABLE ARCHIVE LOG MODE IN ORACLE 19c RAC

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

SQL> select log_mode,name from v$database;

LOG_MODE     NAME

NOARCHIVELOG TESTDB

$ srvctl stop database -d TESTDB

$ srvctl start database -d TESTDB -o mount

SQL> alter database archivelog;
Database altered.

SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST' sid='*' scope=both;

---

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

$ srvctl stop database -d TESTDB

$ srvctl start database -d TESTDB