Enable archive log in Oracle RAC
In this Tutorial I explained about How to Enable Archivelog In RAC Environment
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
The Following Command shows the database whether archivelog or not SQL> select log_mode from v$database;
Comments
Post a Comment