Moving Oracle RAC databases into and out of archive log mode requires a few more steps due to the existence of multiple instances. This procedure covers the steps required to move a non-archive log mode database into archive log mode.
1. Logon to Oracle node1 server as the oracle software owner.
2. Validate the current archive log mode of the database, by logging onto the database and issuing the [archive log list] command.
[oracle@mylinux1 ~]$ export ORACLE_SID=orcl1
[oracle@mylinux1 ~]$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 20 22:57:07 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u05/oradata/orcl/archive
Oldest online log sequence 66
Current log sequence 68
3. Move the node out of cluster mode by changing the parameter cluster_database equal to false and exit.
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@mylinux1 ~]$
4. Stop the clustered database with srvctl utility.
[oracle@mylinux1 ~]$ srvctl stop database -d orcl
5. Logon to sqlplus on node1 and startup the instance in single instance mode with mount option.
[oracle@mylinux1 ~]$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 20 22:59:08 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 367476736 bytes
Fixed Size 2213376 bytes
Variable Size 293603840 bytes
Database Buffers 67108864 bytes
Redo Buffers 4550656 bytes
Database mounted.
SQL>
6. Alter the database to archive log mode.
SQL> alter database archivelog;
Database altered.
SQL>
7. Change the parameter cluster_database back to true, shutdown the instance, and exit.
SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
8. Use the srvctl utility to startup the clustered database.
[oracle@mylinux1 ~]$ srvctl start database -d orcl
9. Logon to sqlplus on node1 and check the archive log mode with the command [archive log list].
[oracle@mylinux1 ~]$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 20 23:01:22 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u05/oradata/orcl/archive
Oldest online log sequence 66
Next log sequence to archive 68
Current log sequence 68
SQL>
This completes moving an Oracle RAC database into archive log mode.
Larry J. Catt, OCP
oracle@allcompute.com
www.allcompute.com