Enabling Archiving

Remember that during the database creation with DBCA, we enabled archiving to ensure that the database will be configured with this option from the beginning. When you want to change the archiving mode, you can run the ALTER DATABASE SQL statements to change the archiving mode in Oracle RAC as long as the database is mounted by the local instance but not open in any instances. On the last open instance of the Oracle RAC, do the following to enable archiving:

   [oracle@ratlnx01 bin]$ ./sqlplus /nolog
   SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 2 13:00:51 2010
   Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   SQL> connect / as sysdba
   Connected.
   SQL> shutdown immediate
   Database closed.
   Database dismounted.
   ORACLE instance shut down.
   SQL> startup mount
   ORACLE instance started.
   Total System Global Area  221294592 bytes
   Fixed Size                  2212048 bytes
   Variable Size             142610224 bytes
   Database Buffers           71303168 bytes
   Redo Buffers                5169152 bytes
   Database mounted.
   SQL> alter database archivelog;
   Database altered.
   SQL> alter database open;
   Database altered.