[oracle@oratest2 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 2 19:13:36 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
set lines 300
col gnum for 9999
col filenum for 9999
col reference_index for 9999
col file_name for a80
col con_id for 999
set pages 500 long 100000
SELECT con_id,gnum, filnum, concat('+'||gname,sys_connect_by_path(aname, '/')) as file_name
FROM (SELECT a.con_id,g.name gname, a.parent_index pindex, a.name aname,
a.reference_index rindex, a.group_number gnum,a.file_number filnum
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;
CON_ID GNUM FILNUM FILE_NAME
------ ----- ---------- --------------------------------------------------------------------------------
0 1 4294967295 +DATA/ora-cluster
0 1 4294967295 +DATA/ora-cluster/ASMPARAMETERFILE
0 1 253 +DATA/ora-cluster/ASMPARAMETERFILE/REGISTRY.253.1180612989
0 1 4294967295 +DATA/ora-cluster/OCRFILE
0 1 255 +DATA/ora-cluster/OCRFILE/REGISTRY.255.1180613007
0 1 4294967295 +DATA/ASM
0 1 4294967295 +DATA/ASM/PASSWORD
0 1 256 +DATA/ASM/PASSWORD/pwdasm.256.1180612999
0 1 257 +DATA/ASM/PASSWORD/pwdasm.257.1180613329
0 1 4294967295 +DATA/ORA_PRIM
0 1 4294967295 +DATA/ORA_PRIM/PASSWORD
0 1 258 +DATA/ORA_PRIM/PASSWORD/pwdora_prim.258.1180874433
0 1 258 +DATA/ORA_PRIM/PASSWORD/pwdora_prim
0 1 4294967295 +DATA/ORA_PRIM/DATAFILE
0 1 262 +DATA/ORA_PRIM/DATAFILE/USERS.262.1180617133
0 1 260 +DATA/ORA_PRIM/DATAFILE/SYSAUX.260.1180617107
0 1 259 +DATA/ORA_PRIM/DATAFILE/SYSTEM.259.1180617071
0 1 261 +DATA/ORA_PRIM/DATAFILE/UNDOTBS1.261.1180617131
0 1 274 +DATA/ORA_PRIM/DATAFILE/UNDOTBS2.274.1180617675
0 1 4294967295 +DATA/ORA_PRIM/CONTROLFILE
0 1 263 +DATA/ORA_PRIM/CONTROLFILE/Current.263.1180617197
0 1 264 +DATA/ORA_PRIM/CONTROLFILE/Current.264.1180617197
0 1 4294967295 +DATA/ORA_PRIM/TEMPFILE
0 1 269 +DATA/ORA_PRIM/TEMPFILE/TEMP.269.1180617211
0 1 4294967295 +DATA/ORA_PRIM/86B637B62FE07A65E053F706E80A27CA
0 1 4294967295 +DATA/ORA_PRIM/86B637B62FE07A65E053F706E80A27CA/DATAFILE
0 1 272 +DATA/ORA_PRIM/86B637B62FE07A65E053F706E80A27CA/DATAFILE/UNDOTBS1.272.1180617403
0 1 271 +DATA/ORA_PRIM/86B637B62FE07A65E053F706E80A27CA/DATAFILE/SYSAUX.271.1180617403
0 1 270 +DATA/ORA_PRIM/86B637B62FE07A65E053F706E80A27CA/DATAFILE/SYSTEM.270.1180617403
0 1 4294967295 +DATA/ORA_PRIM/22EDD25528C83F07E0630701A8C0B617
0 1 4294967295 +DATA/ORA_PRIM/22EDD25528C83F07E0630701A8C0B617/TEMPFILE
0 1 273 +DATA/ORA_PRIM/22EDD25528C83F07E0630701A8C0B617/TEMPFILE/TEMP.273.1180617423
0 1 4294967295 +DATA/ORA_PRIM/PARAMETERFILE
0 1 279 +DATA/ORA_PRIM/PARAMETERFILE/spfile.279.1180617937
0 1 4294967295 +DATA/ORA_PRIM/ARCHIVELOG
0 1 4294967295 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_25
0 1 280 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_25/thread_2_seq_1.280.1180617937
0 1 281 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_25/thread_1_seq_6.281.1180618015
0 1 4294967295 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_26
0 1 291 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_26/thread_1_seq_8.291.1180695815
0 1 290 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_26/thread_1_seq_7.290.1180695815
0 1 289 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_26/thread_2_seq_2.289.1180695813
0 1 4294967295 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_28
0 1 294 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_28/thread_2_seq_4.294.1180868387
0 1 292 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_28/thread_1_seq_9.292.1180868385
0 1 293 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_28/thread_2_seq_3.293.1180868387
0 1 4294967295 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_29
0 1 296 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_29/thread_1_seq_10.296.1180953921
0 1 297 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_29/thread_1_seq_11.297.1180953921
0 1 295 +DATA/ORA_PRIM/ARCHIVELOG/2024_09_29/thread_2_seq_5.295.1180953921
0 1 4294967295 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01
0 1 4294967295 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/DATAFILE
0 1 282 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/DATAFILE/UNDOTBS1.282.1180618165
0 1 284 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/DATAFILE/SYSAUX.284.1180618165
0 1 286 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/DATAFILE/UNDO_2.286.1180618195
0 1 287 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/DATAFILE/USERS.287.1180618197
0 1 283 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/DATAFILE/SYSTEM.283.1180618165
0 1 4294967295 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/TEMPFILE
0 1 285 +DATA/ORA_PRIM/22EDFFF300C9602EE0630701A8C01F01/TEMPFILE/TEMP.285.1180618169
0 1 4294967295 +DATA/ORA_PRIM/AUTOBACKUP
0 1 4294967295 +DATA/ORA_PRIM/AUTOBACKUP/2024_09_25
0 1 288 +DATA/ORA_PRIM/AUTOBACKUP/2024_09_25/s_1180618726.288.1180618727
0 1 4294967295 +DATA/UK_PRIM
0 1 4294967295 +DATA/UK_PRIM/AUTOBACKUP
0 1 4294967295 +DATA/UK_PRIM/AUTOBACKUP/2024_09_29
0 1 298 +DATA/UK_PRIM/AUTOBACKUP/2024_09_29/s_1180954647.298.1180954649
0 1 4294967295 +DATA/UK_PRIM/ONLINELOG
0 1 268 +DATA/UK_PRIM/ONLINELOG/group_2.268.1180954621
0 1 267 +DATA/UK_PRIM/ONLINELOG/group_1.267.1180954617
0 1 276 +DATA/UK_PRIM/ONLINELOG/group_3.276.1180954623
0 1 275 +DATA/UK_PRIM/ONLINELOG/group_3.275.1180954625
0 1 278 +DATA/UK_PRIM/ONLINELOG/group_4.278.1180954627
0 1 277 +DATA/UK_PRIM/ONLINELOG/group_4.277.1180954629
0 1 265 +DATA/UK_PRIM/ONLINELOG/group_2.265.1180954621
0 1 266 +DATA/UK_PRIM/ONLINELOG/group_1.266.1180954619
0 1 4294967295 +DATA/UK_PRIM/ARCHIVELOG
0 1 4294967295 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29
0 1 301 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_1_seq_2.301.1180980869
0 1 302 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_1_seq_3.302.1180981123
0 1 299 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_2_seq_1.299.1180980861
0 1 300 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_1_seq_1.300.1180980867
0 1 306 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_1_seq_4.306.1180983965
0 1 305 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_2_seq_4.305.1180983845
0 1 304 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_2_seq_3.304.1180981925
0 1 303 +DATA/UK_PRIM/ARCHIVELOG/2024_09_29/thread_2_seq_2.303.1180981921
0 1 4294967295 +DATA/UK_PRIM/ARCHIVELOG/2024_10_01
0 1 308 +DATA/UK_PRIM/ARCHIVELOG/2024_10_01/thread_2_seq_5.308.1181240721
0 1 309 +DATA/UK_PRIM/ARCHIVELOG/2024_10_01/thread_2_seq_6.309.1181240721
0 1 307 +DATA/UK_PRIM/ARCHIVELOG/2024_10_01/thread_1_seq_5.307.1181240717
0 1 4294967295 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02
0 1 312 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_8.312.1181306697
0 1 313 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_9.313.1181308743
0 1 314 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_10.314.1181308745
0 1 323 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_11.323.1181328003
0 1 316 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_8.316.1181309227
0 1 317 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_9.317.1181309229
0 1 322 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_10.322.1181327357
0 1 321 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_14.321.1181327355
0 1 320 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_13.320.1181327355
0 1 319 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_12.319.1181327351
0 1 318 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_11.318.1181327351
0 1 311 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_2_seq_7.311.1181306697
0 1 310 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_6.310.1181306693
0 1 324 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_12.324.1181328003
0 1 315 +DATA/UK_PRIM/ARCHIVELOG/2024_10_02/thread_1_seq_7.315.1181308745
0 1 257 +DATA/orapwasm_backup
0 1 256 +DATA/orapwasm
107 rows selected.
