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

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

Migrating From Oracle to PostgreSQL using ora2pg open source tools

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

How to configure Replication Manager (repmgr) ?