Oracle 11g- Single instance  archivelog mode on ASM 

Oracle 11gR2 archivelog mode on ASM

Oracle 11gR2 archivelog mode

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  NORMAL  N         512   4096  1048576      9216     5657              896            2380              0             N  DATA/

MOUNTED  EXTERN  N         512   4096  1048576      9216     8988                0            8988              0             N  FRA/

ASMCMD> cd FRA

ASMCMD> mkdir Archive

ASMCMD> ls -lt

Type       Redund  Striped  Time             Sys  Name

                                             Y    ONLINELOG/

                                             N    Archive/

                                             Y    AUTOBACKUP/

                                             N    redo03b.log => +FRA/ORCL/ONLINELOG/group_3.257.741266861

                                             N    redo02b.log => +FRA/ORCL/ONLINELOG/group_2.258.741267209

                                             N    redo01b.log => +FRA/ORCL/ONLINELOG/group_1.256.741266959

ASMCMD> pwd

+FRA/ORCL/Archive

[oracle@oel5u4-orcl ~] . oraenv

ORACLE_SID = [orcl] ?

The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 24 19:43:11 2012

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> alter system set LOG_ARCHIVE_FORMAT ='Log%s_%t_%r.Arc' scope=spfile;

System altered.

SQL> alter system set log_archive_dest_1='location=+FRA/ORCL/Archive' SCOPE=SPFILE;

System altered.

SQL> alter system set log_archive_start=TRUE SCOPE=SPFILE;  --- no need in Oracle 11gr2

System altered.

SQL> alter system reset log_archive_start scope=spfile sid='*';

System altered.

SQL> shutdown immediate ;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  472887296 bytes

Fixed Size                  1337296 bytes

Variable Size             360712240 bytes

Database Buffers          104857600 bytes

Redo Buffers                5980160 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            +FRA/orcl/archive

Oldest online log sequence     32

Next log sequence to archive   34

Current log sequence           34

SQL> alter database open ;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

[oracle@oel5u4-orcl ~] . oraenv

ORACLE_SID = [orcl] ? +ASM

The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle

[oracle@oel5u4-+ASM ~] asmcmd -p

ASMCMD [+] > cd FRA

ASMCMD [+FRA] > ls -lt

Type  Redund  Striped  Time             Sys  Name

                                        Y    ORCL/

ASMCMD [+FRA] > cd ORCL

ASMCMD [+FRA/ORCL] > cd Archive

ASMCMD [+FRA/ORCL/Archive] > ls -lt

Type        Redund  Striped  Time             Sys  Name

                                              N    log36_1_731227289.arc => +FRA/ORCL/ARCHIVELOG/2012_11_24/thread_1_seq_36.262.800222675

                                              N    log35_1_731227289.arc => +FRA/ORCL/ARCHIVELOG/2012_11_24/thread_1_seq_35.261.800222653

                                              N    log34_1_731227289.arc => +FRA/ORCL/ARCHIVELOG/2012_11_24/thread_1_seq_34.260.800222627

ASMCMD [+FRA/ORCL/Archive] >