How to disable and enable archive log in Oracle RAC

After the core DBA, continue our journey towards RAC environment. Today we are going to explore the steps use for “How to disable and enable archive log in oracle RAC“

Let’s follow the steps. Hopefully, you will feel the difference in RAC.

Step1: First we need to 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: As we are working on 2 node environment now we 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

Now we can see our database is in archive log.

Today’s thought

“Knowing yourself is the beginning of all wisdom.” ― Aristotle

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp