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