[oracle@rac1 ~]$ sqlplus '/as sysdba'
SQL> alter system set cluster_database=false scope=spfile sid='RAC1';[oracle@rac1 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 16 08:02:29 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
> Shutdown all instances accessing the clustered database:SQL> alter system set cluster_database=false scope=spfile sid='RAC1';
System altered.
[oracle@rac1 ~]$ srvctl stop database -d RAC
> Using the local instance, MOUNT the database:
[oracle@rac1 ~]$ sqlplus '/as sysdba'
SQL> startup mount;[oracle@rac1 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 16 08:17:04 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
> Enable archiving:SQL> startup mount;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1346140 bytes
Variable Size 390071716 bytes
Database Buffers 138412032 bytes
Redo Buffers 5832704 bytes
Database mounted.
SQL> alter database archivelog;
> Re-enable support for clustering by modifying the instance parameter cluster_database to TRUE from the current instance:SQL> alter database archivelog;
Database altered.
SQL> alter system set cluster_database=true scope=spfile sid='RAC1';
> Shutdown the local instance:SQL> alter system set cluster_database=true scope=spfile sid='RAC1';
System altered.
SQL> shutdown immediate;
> Bring all instance back up using srvctl:SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
[oracle@rac1 ~]$ srvctl start database -d RAC
> (Optional) Bring any services (i.e. rac_app) back up using srvctl:
[oracle@rac1 ~]$ srvctl start service -d RAC
> Login to the local instance and verify Archive Log Mode is enabled:
[oracle@rac1 dbs]$ sqlplus '/as sysdba'
SQL> archive log list;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 10
Next log sequence to archive 11
Current log sequence 11