Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Enabling the archive log mode in the RAC database is slightly different from the normal database.
You can enable archive log mode in the rac database by following the steps below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | $ sqlplus / as sysdba SQL> alter system set cluster_database=false scope=spfile sid='racdb1'; $ srvctl stop database -d racdb $ sqlplus / as sysdba SQL> startup mount SQL> alter database archivelog; SQL> alter system set cluster_database=true scope=spfile sid='racdb1'; SQL> shutdown immediate $ srvctl start database -d racdb $ sqlplus / as sysdba SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 3058 Next log sequence to archive 3061 Current log sequence 3061 |
As above, Automatic archival Enabled means everything is OK.
