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

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform