Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Oracle to Postgresql migration

PostgreSQL Enterprise Manager - PEM Monitoring Tools

7 Steps to configure BDR replication in postgresql