Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ASM directory path info from ASM instance

Re: ASM directory path info from ASM instance

From: mhthomas <qnxodba_at_gmail.com>
Date: Mon, 28 Mar 2005 23:11:43 -0500
Message-ID: <d6bad08005032820115fa7e4d3@mail.gmail.com> 





    
  
  1.   I also googled and found this helpful doc (in german):
http://www.oracle-10g-buch.de/down/kurzer_auszug_asm.pdf

  
  2.   With this query:
SELECT

concat('+'||gname, sys_connect_by_path(aname, '/')) full_path
FROM

(SELECT g.name gname, a.parent_index pindex, a.name aname,
a.reference_index rindex
FROM v$asm_alias a, v$asm_diskgroup g
WHERE a.group_number = g.group_number)
START WITH (mod(pindex, power(2, 24))) = 0
CONNECT BY PRIOR rindex = pindex;






But, I can't decide which is harder, translating the german-english or
reading the query syntax. ;-)



3) The output is very nice:


FULL_PATH





+DGFAIL/R71G


+DGFAIL/R71G/PARAMETERFILE


+DGFAIL/R71G/PARAMETERFILE/spfile.256.1

+DGFAIL/R71G/spfiler71g.ora

+DGFAIL/R71G/ARCHIVELOG


+DGFAIL/R71G/ARCHIVELOG/2005_01_25


+DGFAIL/R71G/ARCHIVELOG/2005_01_25/thread_1_seq_145.259.3

+DGFAIL/R71G/ARCHIVELOG/2005_01_25/thread_1_seq_146.303.3

+DGFAIL/R71G/ARCHIVELOG/2005_01_25/thread_1_seq_147.302.3

+DGFAIL/R71G/ARCHIVELOG/2005_01_25/thread_1_seq_148.349.3

+DGFAIL/R71G/ARCHIVELOG/2005_01_25/thread_1_seq_143.394.1

+DGFAIL/R71G/ARCHIVELOG/2005_01_25/thread_1_seq_144.395.1

+DGFAIL/R71G/ARCHIVELOG/2005_03_25


+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_183.359.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_184.358.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_185.357.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_186.356.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_187.355.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_188.354.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_189.353.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_25/thread_1_seq_190.352.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_28


+DGFAIL/R71G/ARCHIVELOG/2005_03_28/thread_1_seq_191.351.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_24


+DGFAIL/R71G/ARCHIVELOG/2005_03_24/thread_1_seq_180.362.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_24/thread_1_seq_181.361.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_24/thread_1_seq_182.360.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21


+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_151.391.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_156.386.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_158.384.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_165.377.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_164.378.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_163.379.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_162.380.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_161.381.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_160.382.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_159.383.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_157.385.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_155.387.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_152.390.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_153.389.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_21/thread_1_seq_154.388.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_22


+DGFAIL/R71G/ARCHIVELOG/2005_03_22/thread_1_seq_166.376.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_22/thread_1_seq_167.375.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_22/thread_1_seq_168.374.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_22/thread_1_seq_169.373.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_22/thread_1_seq_170.372.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23


+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_171.371.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_172.370.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_173.369.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_174.368.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_175.367.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_176.366.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_177.365.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_178.364.3

+DGFAIL/R71G/ARCHIVELOG/2005_03_23/thread_1_seq_179.363.3

+DGFAIL/R71G/ARCHIVELOG/2005_01_26


+DGFAIL/R71G/ARCHIVELOG/2005_01_26/thread_1_seq_149.393.3

+DGFAIL/R71G/ARCHIVELOG/2005_01_26/thread_1_seq_150.392.3

+DGFAIL/R71G/1_147_548493917.dbf

+DGFAIL/R71G/1_149_548493917.dbf

+DGFAIL/R71G/1_151_548493917.dbf

+DGFAIL/R71G/1_153_548493917.dbf

+DGFAIL/R71G/1_155_548493917.dbf

+DGFAIL/R71G/1_164_548493917.dbf

+DGFAIL/R71G/1_163_548493917.dbf

+DGFAIL/R71G/1_162_548493917.dbf

+DGFAIL/R71G/1_161_548493917.dbf

+DGFAIL/R71G/1_160_548493917.dbf

+DGFAIL/R71G/1_159_548493917.dbf

+DGFAIL/R71G/1_158_548493917.dbf

+DGFAIL/R71G/1_157_548493917.dbf

+DGFAIL/R71G/1_156_548493917.dbf

+DGFAIL/R71G/1_173_548493917.dbf

+DGFAIL/R71G/1_172_548493917.dbf

+DGFAIL/R71G/1_171_548493917.dbf

+DGFAIL/R71G/1_170_548493917.dbf

+DGFAIL/R71G/1_169_548493917.dbf

+DGFAIL/R71G/1_168_548493917.dbf

+DGFAIL/R71G/1_167_548493917.dbf

+DGFAIL/R71G/1_166_548493917.dbf

+DGFAIL/R71G/1_165_548493917.dbf

+DGFAIL/R71G/1_144_548493917.dbf

+DGFAIL/R71G/1_143_548493917.dbf

+DGFAIL/R71G/1_191_548493917.dbf

+DGFAIL/R71G/1_190_548493917.dbf

+DGFAIL/R71G/1_189_548493917.dbf

+DGFAIL/R71G/1_188_548493917.dbf

+DGFAIL/R71G/1_187_548493917.dbf

+DGFAIL/R71G/1_186_548493917.dbf

+DGFAIL/R71G/1_185_548493917.dbf

+DGFAIL/R71G/1_184_548493917.dbf

+DGFAIL/R71G/1_183_548493917.dbf

+DGFAIL/R71G/1_182_548493917.dbf

+DGFAIL/R71G/1_181_548493917.dbf

+DGFAIL/R71G/1_180_548493917.dbf

+DGFAIL/R71G/1_179_548493917.dbf

+DGFAIL/R71G/1_178_548493917.dbf

+DGFAIL/R71G/1_177_548493917.dbf

+DGFAIL/R71G/1_176_548493917.dbf

+DGFAIL/R71G/1_175_548493917.dbf

+DGFAIL/R71G/1_174_548493917.dbf

+DGFAIL/R71G/1_154_548493917.dbf

+DGFAIL/R71G/1_152_548493917.dbf

+DGFAIL/R71G/1_150_548493917.dbf

+DGFAIL/R71G/1_148_548493917.dbf

+DGFAIL/R71G/1_146_548493917.dbf

+DGFAIL/R71G/1_145_548493917.dbf

+DGRAID/R71G


+DGRAID/R71G/DATAFILE


+DGRAID/R71G/DATAFILE/SYSTEM.256.1


+DGRAID/R71G/DATAFILE/SYSAUX.257.1


+DGRAID/R71G/DATAFILE/UNDOTBS1.258.1


+DGRAID/R71G/DATAFILE/USERS.259.1


+DGRAID/R71G/DATAFILE/EXAMPLE.269.1


+DGRAID/R71G/ONLINELOG


+DGRAID/R71G/ONLINELOG/group_1.262.1

+DGRAID/R71G/ONLINELOG/group_1.263.1

+DGRAID/R71G/ONLINELOG/group_2.264.1

+DGRAID/R71G/ONLINELOG/group_2.265.1

+DGRAID/R71G/ONLINELOG/group_3.266.1

+DGRAID/R71G/ONLINELOG/group_3.267.1

+DGRAID/R71G/CONTROLFILE


+DGRAID/R71G/CONTROLFILE/Current.261.3

+DGRAID/R71G/CONTROLFILE/Current.260.3

+DGRAID/R71G/TEMPFILE


+DGRAID/R71G/TEMPFILE/TEMP.268.1



130 rows selected.




Regards,



Mike Thomas

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


Received on Mon Mar 28 2005 - 23:15:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US