Dropped Redo Log Group - files REMAINED in ASM Diskgroup ?

From: <Christopher.Taylor2_at_parallon.net>
Date: Mon, 3 Dec 2012 12:04:14 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856736BD56_at_NADCWPMSGCMS10.hca.corpad.net>

Ok, so being still "newbish" to ASM, I was suprised to see that when I dropped an online redolog group, that the redo log files remained on the ASM disk group. Is this normal behavior or did I miss a step somewhere?

SQL> set feed on
SQL> set verify on
SQL> set head on
SQL> set lines 120
SQL> set pages 24
SQL> select * from v$logfile

  2 where group# = 13
  3 ;

no rows selected

ASMCMD [+] > ls DG_CCMNASQ4_REDO_01/CCMNASQ4/ONLINELOG (looks like we have lots of left overs) group10a
group11a
group12a
group13a
group13b
group14a
group14b
group15a
group16a
group17a
group18a
group19a
group1a
group2a
group3a
group4a
group5a
group6a

group_1.267.749561173
group_10.257.801054211
group_11.261.801054285
group_12.259.801054343
group_13.256.801055391
group_13.268.801054425
group_14.260.801055435
group_14.269.801054471
group_15.270.801055099
group_16.271.801055157
group_17.272.801055203
group_18.273.801055251
group_19.258.801055553
group_2.262.749560971
group_3.264.749561071
group_4.266.749561139
group_5.263.749561025
group_6.265.749561103

Chris Taylor
Oracle DBA
Parallon IT&S
christopher.taylor2_at_parallon.net<mailto:christopher.taylor2_at_parallon.net> www.parallon.net

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 03 2012 - 19:04:14 CET