Change to Archive Log Mode In Oracle Rac

Oracle RAC
  1. Disable clustering putting cluster_database parameter FALSE.

$export ORACLE_SID=ORCL1
$sqlplus “/ as sysdba”

Check the status of archive mode of the database:

SQL>archive log list

Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 407
Current log sequence 408

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

  1. Shutdown all instances using srvctl utilty

$ srvctl stop database -d cobra

  1. Mount tha database using one of the instance:

$ sqlplus “/ as sysdba”

SQL> startup mount

  1. Enable archivelog using following command:

SQL> alter database archivelog;

  1. Re-enable clustering putting instance parameter cluster_database to TRUE from the current instance:

SQL> alter system set cluster_database=true scope=spfile sid=’ORCL1′;

  1. Shutdown the local instance:

SQL> shutdown immediate

  1. Startup all instances using srvctl utility:

srvctl start database -d orcl

  1. If any service is not up then get up those using srvctl utility:

srvctl start service -dorcl

  1. And now check archivelog mode is enabled or not using following:

$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 407
Current log sequence 408