RAC-Enable Archive Log-Configure to ASM Location

I will List the steps to Enable Archive Log RAC Configured VM’s

Create  folders in ASM location.

Initially archives are not enabled

1. Login to one of the nodes (i.e. rac1) and disable the cluster instance parameter by setting cluster_database to FALSE from the current instance:

2. $ sqlplus “/ as sysdba”

SQL> alter system set cluster_database=false scope=spfile sid=’prod1′;

3. Shutdown all instances accessing the clustered database:

$ srvctl stop database -d prod

4.

We start in nomount mode one single instance of the RAC:

[oracle@rac1 ~]$ sqlplus ‘/as sysdba’

SQL> startup nomount;

SQL> alter system set log_archive_start=TRUE SCOPE=SPFILE;

System altered.

SQL> alter system set log_archive_dest_1=’LOCATION=+FRA/prod/archivelog’ SCOPE=SPFILE;

System altered.

alter system set cluster_database=true scope=spfile sid=’prod1′;

Now we mount the database instance:

SQL> alter database mount;

Database altered.
Now, we set the database to archive log mode:

SQL> alter database archivelog;
Database altered.
We can perform some checks after that…

srvctl start database -d prod

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/prod/archivelog
Oldest online log sequence 16
Next log sequence to archive 17
Current log sequence 17
SQL> alter system switch logfile;

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/prod/archivelog
Oldest online log sequence 17
Next log sequence to archive 18
Current log sequence 18

SQL> alter system switch logfile;

Now Check