How to disable and enable archive log in Oracle RAC

This document describes how to enable and disable archive log in Oracle RAC database.

ENABLE ARCHIVE LOG MODE IN RAC.

Step1: stop database instance on node1 using sqlplus.

[oracle@rac-node1 bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST1
SQL> shutdown immediate;

Step2: Stop database instance on node2 using sqlplus.

[oracle@rac-node2 bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST2
SQL> shutdown immediate;

Step3: start only one instance i.e node1.

SQL>startup mount;
SQL>alter database archivelog;
SQL>alter database open;

Step4: Now connect node2 and start the instance only.

[oracle@rac-node2 bin]# sqlplus /nolog
SQL>startup
SQL> select log_mode from v$database;
SQL>archivelog     #it means database is in archive log mode

DISABLE ARCHIVELOG MODE IN RAC.

Step1: stop database instance on node1 using sqlplus.

[oracle@rac-node1 bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST1
SQL> shutdown immediate;

Step2: Stop database instance on node2 using sqlplus.

[oracle@rac-node2 bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST2
SQL> shutdown immediate;

Step3: start only one instance i.e node1.

SQL>startup mount;
SQL>alter database noarchivelog;
SQL>alter database open;

Step 4:Now connect node2 and start the instance only.

[oracle@rac-node2 bin]# sqlplus /nolog
SQL>startup
SQL> select log_mode from v$database;
SQL>noarchivelog #its showing database is in archivelog mode.

Completed

 

About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Database administration, Oracle RAC. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s