Configuring Archivelog Mode On RAC
LOG_ARCHIVE_DEST_n parameters are not set, the archived redo logs will be placed in the FRA. If you want to specify their location and the file name format manually, you can do it as follows.
ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/MYDB/archive/' SCOPE=spfile; ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;
From the command line we can stop the entire clustered database and start it in mount mode using the following.
$ srvctl stop database -d MYDB $ srvctl start database -d MYDB -o mount
With the database mounted issue the following commands.
sqlplus / as sysdba ALTER DATABASE ARCHIVELOG; EXIT;
Since the datafiles and spfile are shared between all instances this operation only has to be done from a single node.
From the command line we stop and start the clustered database again using the following commands.
$ srvctl stop database -d MYDB $ srvctl start database -d MYDB