Archivelog Mode On RAC

Oracle 10gR2

From 10gR2, you no longer need to reset the CLUSTER_DATABASE parameter during the process.

If the 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 DB_RECOVERY_FILE_DEST_SIZE = 134G;
ALTER SYSTEM SET db_recovery_file_dest = '+FRA' SCOPE=SPFILE;

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