How to enable ArchiveLog mode in Oracle Database RAC Environment?

Steps to enable Archivelog mode in RAC environment:


The following steps need to be taken to enable archive logging in a RAC database environment:


1. Shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>


2. Startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount


3. Enable archive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;


4. Stop database
$ srvctl stop database -d <db_unique_name>


5.Start all database instances
$ srvctl start database -d <db_unique_name>


6.Verify archiving is enabled/disabled 
sql> archive log list;

3 thoughts on “How to enable ArchiveLog mode in Oracle Database RAC Environment?”

  1. Just stumbled upon cpc6, seems promising! Still exploring, but the initial impression is decent. I’ll update if I find anything groundbreaking. Go see for yourself: cpc6

Leave a Reply

Your email address will not be published. Required fields are marked *