How to change Archivelog mode from RAC Database

  1. Login to one of the nodes (i.e. linux1) and disable the cluster instance parameter by setting cluster_database to FALSE from the current instance:
     $ sqlplus "/ as sysdba"
     SQL> alter system set cluster_database=false scope=spfile sid='orcl1';
  2. Shutdown all instances accessing the clustered database: 
     $ srvctl stop database -d orcl
  3. Using the local instance, MOUNT the database: 
     $ sqlplus "/ as sysdba"
     SQL> startup mount
  4. Enable archiving: 
     SQL> alter database archivelog;
  5. Re-enable support for clustering by modifying the instance parameter cluster_database to TRUE from the current instance: 
     SQL> alter system set cluster_database=true scope=spfile sid='orcl1';
  6. Shutdown the local instance: 
     SQL> shutdown immediate
  7. Bring all instance back up using srvctl: 
     $ srvctl start database -d orcl
  8. (Optional) Bring any services (i.e. TAF) back up using srvctl: 
     $ srvctl start service -d orcl
  9. Login to the local instance and verify Archive Log Mode is enabled: 
     $ 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     83
     Next log sequence to archive   84
     Current log sequence           84

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: