[ORACLE 11g RAC] ENABLE ARCHIVELOG MODE

DB NAME: CDBRAC
instance1: CDBRAC1
instance2: CDBRAC2
ASM DISKGROUP: DISK01 -> For data files.
DISK02 -> Archivelog files.
OCR
DB MODE NOARCHIVELOG -> Need change mode to -> ARCHIVELOG.

CDBRAC1 - TAB1:

[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG

[oracle@rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is running on node rac1
Instance CDBRAC2 is running on node rac2

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL> show parameter log_archive_dest_1;

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1     string
log_archive_dest_10     string
log_archive_dest_11     string
log_archive_dest_12     string
log_archive_dest_13     string
log_archive_dest_14     string
log_archive_dest_15     string
log_archive_dest_16     string
log_archive_dest_17     string
log_archive_dest_18     string
log_archive_dest_19     string

SQL> alter system set log_archive_dest_1='location=+DISK02/archivelog';

System altered.

SQL> show parameter log_archive_dest_1;

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1     string location=+DISK02/archivelog
log_archive_dest_10     string
log_archive_dest_11     string
log_archive_dest_12     string
log_archive_dest_13     string
log_archive_dest_14     string
log_archive_dest_15     string
log_archive_dest_16     string
log_archive_dest_17     string
log_archive_dest_18     string
log_archive_dest_19     string



CDBRAC1 - TAB2:

[oracle@rac1 ~]$ grid_env
[oracle@rac1 ~]$ asmcmd

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576      5115     3269                0            3269              0             N  DISK01/
MOUNTED  EXTERN  N         512   4096  1048576      5115     4986                0            4986              0             N  DISK02/
MOUNTED  EXTERN  N         512   4096  1048576      1023      627                0             627              0    Y  OCR/

ASMCMD> cd +DISK02
ASMCMD> mkdir archivelog
ASMCMD> cd archivelog
ASMCMD> pwd
+DISK02/archivelog

Return CDBRAC1 - TAB1:

[oracle@rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is running on node rac1
Instance CDBRAC2 is running on node rac2
[oracle@rac1 ~]$ srvctl stop database -d CDBRAC
[oracle@rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is not running on node rac1
Instance CDBRAC2 is not running on node rac2

[oracle@rac1 ~]$ srvctl start instance -d CDBRAC -i CDBRAC1 -o mount
[oracle@rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is running on node rac1
Instance CDBRAC2 is not running on node rac2

[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 5 05:29:08 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database archivelog;

Database altered.

SQL> alter database open;


Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is running on node rac1
Instance CDBRAC2 is not running on node rac2
[oracle@rac1 ~]$ srvctl start instance -d CDBRAC -i CDBRAC2
[oracle@rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is running on node rac1
Instance CDBRAC2 is running on node rac2

Check Archivelog Mode is enabled:

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 5 05:33:24 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG
SQL> show parameter log_archive_dest_1;

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1     string location=+DISK02/archivelog
log_archive_dest_10     string
log_archive_dest_11     string
log_archive_dest_12     string
log_archive_dest_13     string
log_archive_dest_14     string
log_archive_dest_15     string
log_archive_dest_16     string
log_archive_dest_17     string
log_archive_dest_18     string
log_archive_dest_19     string

SQL> alter system archive log current;

ASMCMD> cd archivelog
ASMCMD> ls
1_10_891304305.dbf
1_9_891304305.dbf
2_7_891304305.dbf