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 don't have to set CLUSTER_DATABASE = FALSE if you are having only one instance up when you enable archiving as you have mentioned in your plan. So, your steps are correct.1 person found this helpful
Thanks Freddie. I didn't know that you have to set CLUSTER_DATABASE = FALSE in 10g for archive enabling.
Hi,1 person found this helpful
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
Mahir,1 person found this helpful
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
Thank you for the Documentation URL
Hi Freddie, Omega3
Thanks for the correct answer
Thanks for the example. It will come handy when I enable archiving in 10g.
You are welcome Kavanagh!
Dear Hemant thanks for correction. You are right CLUSTER_DATABASE=FALSE is not need.
I confused versions.