1. Checking log_mode:
[oracle@rac1 acfs]$ export ORACLE_SID=RAC1
[oracle@rac1 acfs]$ sqlplus "/as sysdba"
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 9
Current log sequence 10
SQL> [oracle@rac2 acfs]$ export ORACLE_SID=RAC2
[oracle@rac2 acfs]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 13 18:13:53 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select name, open_mode, log_mode from v$database;
NAME OPEN_MODE LOG_MODE
--------- -------------------- ------------
RAC READ WRITE NOARCHIVELOG
SQL> Using SRVCTL utility stop cluster database
[oracle@rac1 ~]$ srvctl stop database -d RAC
--checking statuses
[oracle@rac1 ~]$ srvctl status database -d RAC
Instance RAC1 is not running on node rac1
Instance RAC2 is not running on node rac2 Connect to node 1 and startup instance on mount mode, enable archiving and at the end shutdown the instance:
SQL> startup mount
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 570429008 bytes
Database Buffers 272629760 bytes
Redo Buffers 5132288 bytes
Database mounted.
SQL> ALTER DATABASE ARCHIVELOG;
SQL> SHUTDOWN IMMEDIATE; As you know we have shared files between instances so, this operation only has to be done from a single node.
Now start the clustered database
[oracle@rac1 ~]$ srvctl start database -d RAC
[oracle@rac1 ~]$ srvctl status database -d RAC
Instance RAC1 is running on node rac1
Instance RAC2 is running on node rac2 --Check again on both nodes
SQL> select name, open_mode, log_mode, instance_name from v$database, v$instance;
NAME OPEN_MODE LOG_MODE INSTANCE_NAME
--------- -------------------- ------------ ----------------
RAC READ WRITE ARCHIVELOG RAC1
SQL> select name, open_mode, log_mode, instance_name from v$database, v$instance;
NAME OPEN_MODE LOG_MODE INSTANCE_NAME
--------- -------------------- ------------ ----------------
RAC READ WRITE ARCHIVELOG RAC2
SQL>
That`s all.
