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_ANARDB1
 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 ANARDB1
ora.FRA.dg ora....up.type ONLINE ONLINE ANARDB1
ora....ER.lsnr ora....er.type ONLINE ONLINE ANARDB1
ora....N1.lsnr ora....er.type ONLINE ONLINE ANARDB2
ora....N2.lsnr ora....er.type ONLINE ONLINE ANARDB1
ora....N3.lsnr ora....er.type ONLINE ONLINE ANARDB1
ora.asm ora.asm.type ONLINE ONLINE ANARDB1
ora.ANARDB.db ora....se.type ONLINE ONLINE ANARDB1
ora....SM1.asm application ONLINE ONLINE ANARDB1
ora....B1.lsnr application ONLINE ONLINE ANARDB1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE ANARDB1
ora....db1.vip ora....t1.type ONLINE ONLINE ANARDB1
ora....SM2.asm application ONLINE ONLINE ANARDB2
ora....B2.lsnr application ONLINE ONLINE ANARDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE ANARDB2
ora....db2.vip ora....t1.type ONLINE ONLINE ANARDB2
ora.cvu ora.cvu.type ONLINE ONLINE ANARDB1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE ANARDB1
ora.oc4j ora.oc4j.type ONLINE ONLINE ANARDB1
ora.ons ora.ons.type ONLINE ONLINE ANARDB1
ora....ry.acfs ora....fs.type ONLINE ONLINE ANARDB1
ora.scan1.vip ora....ip.type ONLINE ONLINE ANARDB2
ora.scan2.vip ora....ip.type ONLINE ONLINE ANARDB1
ora.scan3.vip ora....ip.type ONLINE ONLINE ANARDB1

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
ANARDB/
ASMCMD> cd ANARDB
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: