Re: Dropped Redo Log Group - files REMAINED in ASM Diskgroup ?

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 3 Dec 2012 10:43:20 -0800 (PST)
Message-ID: <1354560200.85283.YahooMailNeo_at_web121605.mail.ne1.yahoo.com>

Dropping log groups, using Oracle Managed Files, will drop the files from the operating system.  It doesn't appear to happen with ASM, so this seems to be normal behavior.  
David Fitzjarrell

---

From: "Christopher.Taylor2_at_parallon.net" <Christopher.Taylor2_at_parallon.net> To: oracle-l_at_freelists.org
Sent: Monday, December 3, 2012 11:04 AM
Subject: Dropped Redo Log Group - files REMAINED in ASM Diskgroup ?

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> http://www.parallon.net/

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

Received on Mon Dec 03 2012 - 19:43:20 CET