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

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools