In the cluster log in from anyone of the instances. In my case it is DELL1 [oracle@rac1 ~]$ export ORACLE_SID=dell1 [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 16:38:15 2012 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 # Remove this instance from the cluster. SQL> alter system set cluster_database=false scope=spfile sid='dell1'; System altered. # Stop the whole database. [oracle@rac1 ~]$ srvctl stop database -d dell # Start this instance in mount mode and enable archive log mode. [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 16:41:08 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 535662592 bytes Fixed Size 1337720 bytes Variable Size 390071944 bytes Database Buffers 138412032 bytes Redo Buffers 5840896 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter system set cluster_database=true scope=spfile sid='dell1'; System altered. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. # Start the whole database. [oracle@rac1 ~]$ srvctl start database -d dell [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 16:44:49 2012 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> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Next log sequence to archive 2 Current log sequence 2
Search This Blog
Friday, October 5, 2012
Oracle 11gR2 RAC Enable Archive log Mode.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment