ASM Archive Log Enable

[root@edudb ~]# lvcreate -n fra3 -L 20G vg00
  Logical volume "fra3" created.

[root@edudb ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@edudb ~]# oracleasm listdisks
ASM1
ASM2
ASM3
FRA1
FRA2
FRA3

[oragrid@edudb ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.2.0.1.0 Production on Thu Sep 20 15:11:51 2018
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> ALTER DISKGROUP FRA ADD DISK '/dev/oracleasm/disks/FRA3' rebalance power 2 ;
Diskgroup altered.

SQL> SELECT * FROM v$asm_operation ;

no rows selected

SQL> show parameter recovery

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest       string  +FRA
db_recovery_file_dest_size      big integer 8016M
recovery_parallelism       integer  0
remote_recovery_file_dest      string

SQL> alter system set db_recovery_file_dest_size = '30G' scope=both;
System altered.

[oragrid@edudb ~]$ srvctl stop database -db LDDH
[oragrid@edudb ~]$ srvctl start database -db LDDH -o mount
[oracle@edudb ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu Sep 20 15:17:27 2018
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter database archivelog;
Database altered.

SQL> alter database flashback on;
Database altered.

SQL> select name, created, log_mode from v$database;
NAME   CREATED   LOG_MODE
--------- --------- ------------
LDDH   20-SEP-18 ARCHIVELOG

SQL> select log_mode, flashback_on from v$database;
LOG_MODE     FLASHBACK_ON
------------ ------------------
ARCHIVELOG   YES

SQL> alter database open;
Database altered.

SQL> select status from v$instance;
STATUS
------------
OPEN

SQL> archive log list;
Database log mode        Archive Mode
Automatic archival        Enabled
Archive destination        USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence        1

SQL> alter system switch logfile;
System altered


SQL> select stamp, name,sequence#  from v$archived_log;
     STAMP NAME            SEQUENCE#
---------- ---------------------------------------------------------------------- ----------
 987348031 +FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_1.259.987348023      1
 987348031 +FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_2.260.987348031      2
 987348035 +FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_3.261.987348035      3
 987348076 +FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_4.262.987348077      4
 987348080 +FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_5.263.987348081      5
==========================================================

SELECT 'ALTER DISKGROUP ' || GNAME || ' DROP FILE ''+' || GNAME || SYS_CONNECT_BY_PATH(ANAME, '/') || ''';' A
FROM ( SELECT B.NAME GNAME, A.PARENT_INDEX PINDEX, A.NAME ANAME,
 A.REFERENCE_INDEX RINDEX , A.SYSTEM_CREATED, A.ALIAS_DIRECTORY
 FROM V$ASM_ALIAS A, V$ASM_DISKGROUP B
 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER)
 WHERE ALIAS_DIRECTORY = 'N' AND SYSTEM_CREATED = 'Y'
START WITH (MOD(PINDEX, POWER(2, 24))) = 0
 AND RINDEX IN
 ( SELECT A.REFERENCE_INDEX
 FROM V$ASM_ALIAS A, V$ASM_DISKGROUP B
 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER
 AND (MOD(A.PARENT_INDEX, POWER(2, 24))) = 0
 AND A.NAME = 'LDDH'
)
CONNECT BY PRIOR RINDEX = PINDEX;

SQL> alter diskgroup FRA drop file '+FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_2.260.987348031'
2018-09-21T13:31:44.516563+09:00

SUCCESS: alter diskgroup FRA drop file '+FRA/LDDH/ARCHIVELOG/2018_09_20/thread_1_seq_2.260.987348031'