I just finished a RAC testing. Some stuff to share with you.
Enable archive log
1. Shut down all instances.
2. modify some initial parameters on one instance in the parameter file with following steps:
a. SQL> create pfile='rman.ora' from spfile;
File created.
b. edit rman.ora and change some variables as follow:
*.cluster_database=TRUE
BEB1.log_archive_dest_1='LOCATION=?/arc_dest_1'
BEB2.log_archive_dest_1='LOCATION=?/arc_dest_2'
*.log_archive_start=TRUE
Set LOG_ARCHIVE_FORMAT and make sure the parameter containing the %t
parameter includes the thread number in the archived logfile name.
Ensure that each instance's archive log destination is mounted as read-write
for its node and read only for other nodes. In our case, Cluster2 mounts Cluster1's '?/arc_dest_2' on local directory, and Cluster1 mount Cluster2's '?/arc_dest_1' on local directory.
c. Recreate the SPFILE from the modified PFILE 'rman.ora':
SQL> create spfile from pfile='rman.ora';
File created.
3. Mount the database in exclusive mode for the instance on which you have set
CLUSTER_DATABASE to false.
4.Set the database in ARCHIVELOG mode :
SQL> ALTER DATABASE ARCHIVELOG;
5. Shutdown the instance.
6. Change the value of the CLUSTER_DATABASE parameter to true(use the steps described in step 2).
7. Startup all your instances.
To disable archive logging, follow the same steps but use the NOARCHIVELOG
clause of the ALTER DATABASE statement.