ARCHIVELOG MODE FROM RAC DATABASE


bash-3.2$ ps -afe | grep smon
  oracle 19016     1   0   Jun 20 ?           6:38 asm_smon_+ASM1
  oracle 16578     1   0   Sep 15 ?          35:01 ora_smon_AZKKDB1
  oracle 27602 28381   0 12:32:57 pts/2       0:00 grep smon
    root  5429     1   0   Oct 01 ?        25847:32 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin
bash-3.2$
bash-3.2$ sqll
SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 16 12:33:09 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter log_archi;
NAME                                 TYPE        VALUE
----------------------------------- ----------- ------------------------------
log_archive_config                   string
log_archive_dest                     string      +FRA
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
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_18                  string
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string
log_archive_dest_27                  string
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_28                  string
log_archive_dest_29                  string
log_archive_dest_3                   string
log_archive_dest_30                  string
log_archive_dest_31                  string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_11            string      enable
log_archive_dest_state_12            string      enable
log_archive_dest_state_13            string      enable
log_archive_dest_state_14            string      enable
log_archive_dest_state_15            string      enable
log_archive_dest_state_16            string      enable
log_archive_dest_state_17            string      enable
log_archive_dest_state_18            string      enable
log_archive_dest_state_19            string      enable
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2             string      enable
log_archive_dest_state_20            string      enable
log_archive_dest_state_21            string      enable
log_archive_dest_state_22            string      enable
log_archive_dest_state_23            string      enable
log_archive_dest_state_24            string      enable
log_archive_dest_state_25            string      enable
log_archive_dest_state_26            string      enable
log_archive_dest_state_27            string      enable
log_archive_dest_state_28            string      enable
log_archive_dest_state_29            string      enable
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_3             string      enable
log_archive_dest_state_30            string      enable
log_archive_dest_state_31            string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      %t_%s_%r.dbf
NAME                                 TYPE        VALUE
----------------------------------- ----------- ------------------------------
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     4
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0

SQL> alter database archivelog;
Database altered.
SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL> shu immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2.0583E+10 bytes
Fixed Size                  2168240 bytes
Variable Size            2550139472 bytes
Database Buffers         1.7985E+10 bytes
Redo Buffers               45907968 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

bash-3.2$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    azkkdb1
ora.FRA.dg     ora....up.type ONLINE    ONLINE    azkkdb1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    azkkdb1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    azkkdb2
ora....N2.lsnr ora....er.type ONLINE    ONLINE    azkkdb1
ora....N3.lsnr ora....er.type ONLINE    ONLINE    azkkdb1
ora.asm        ora.asm.type   ONLINE    ONLINE    azkkdb1
ora.azkkdb.db  ora....se.type ONLINE    ONLINE    azkkdb1
ora....SM1.asm application    ONLINE    ONLINE    azkkdb1
ora....B1.lsnr application    ONLINE    ONLINE    azkkdb1
ora....db1.gsd application    OFFLINE   OFFLINE
ora....db1.ons application    ONLINE    ONLINE    azkkdb1
ora....db1.vip ora....t1.type ONLINE    ONLINE    azkkdb1
ora....SM2.asm application    ONLINE    ONLINE    azkkdb2
ora....B2.lsnr application    ONLINE    ONLINE    azkkdb2
ora....db2.gsd application    OFFLINE   OFFLINE
ora....db2.ons application    ONLINE    ONLINE    azkkdb2
ora....db2.vip ora....t1.type ONLINE    ONLINE    azkkdb2
ora.cvu        ora.cvu.type   ONLINE    ONLINE    azkkdb1
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    azkkdb1
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    azkkdb1
ora.ons        ora.ons.type   ONLINE    ONLINE    azkkdb1
ora....ry.acfs ora....fs.type ONLINE    ONLINE    azkkdb1
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    azkkdb2
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    azkkdb1
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    azkkdb1

bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 8 16:39:38 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.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> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
bash-3.2$ cd
bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 8 16:40:10 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter system switch logfile;
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
bash-3.2$ export ORACLE_HOME=/u02/app/oracle/product/grid/db_1
bash-3.2$ export ORACLE_SID=+ASM1
bash-3.2$ asmcmd
ASMCMD> ls
DATA/
FRA/
ASMCMD> cd FRA
ASMCMD> ls
AZKKDB/
ASMCMD> cd AZKKDB
ASMCMD> ls
ARCHIVELOG/

ASMCMD> cd ARCHIVELOG
ASMCMD> ls
2012_05_08/
ASMCMD> cd 2012_05_08
ASMCMD> ls
thread_1_seq_8.257.782757617
thread_2_seq_1.256.782757507
ASMCMD>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: