This content has been marked as final. Show 6 replies
My colleague suggested me to set CLUSTER_DATABASE = FALSE before the activity and revert it back to TRUE after archive enabling. But is it really required ?Yes !!
Amendment: I'll retract that statement. That was the case for 9i and 10g. Just tested and doesn't look to be the case for 11g.
Edited by: Freddie Essex on 17-Apr-2013 17:08
You must use documented way.
Steps in documentation.
1. Connect to database from node1
1. Set cluster_database false
[oracle@rac1 ~]$ export ORACLE_SID=racdb1 [oracle@rac1 ~]$ sqlplus / as sysdba
2. Stop Database all instamces
SQL> alter system set cluster_database=false scope=spfile sid='racdb1';
3. Start instance 1 in mount mode via sqlplus
[oracle@rac1 ~]$ srvctl stop database -d racdb
4. Start the whole database.
[oracle@rac1 ~]$ sqlplus / as sysdba SQL> startup mount SQL> alter database archivelog; SQL> alter system set cluster_database=true scope=spfile sid='racdb1'; SQL> shutdown immediate
5. Check log mode
[oracle@rac1 ~]$ srvctl start database -d racdb
[oracle@rac1 ~]$ sqlplus / as sysdba SQL> archive log list; Database log mode Archive Mode
Mahir M. Quluzade
As Freddie pointed out, you don't need to set CLUSTER_DATABASE=TRUE in 11g.
See "Archiving Mode in RAC" at http://docs.oracle.com/cd/E11882_01/rac.112/e16795/rman.htm#i491246
"You can run the ALTER DATABASE SQL statement to change the archiving mode in Oracle RAC, because the database is mounted by the local instance but not open in any instances. _You do not need to modify parameter settings to run this statement_." (Underlining of sentence by me)
(although it doesn't make the exact sequence of commands clear here in this document but refers to the Oracle Database Administrator's Guide http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN008)
Hemant K Chitale