ASM files db wise

ASM files db wise to see all list of files in db


---for ar database
column path format a70
column file_type format a15


select concat('+'||gname, sys_connect_by_path(aname, '/')) path,
       system_created, alias_directory, file_type
from ( select b.name gname, a.parent_index pindex, a.name aname,
              a.reference_index rindex , a.system_created, a.alias_directory,
              c.type file_type
       from v$asm_alias a, v$asm_diskgroup b, v$asm_file c
       where a.group_number = b.group_number
             and a.group_number = c.group_number(+)
             and a.file_number = c.file_number(+)
             and a.file_incarnation = c.incarnation(+)
     )
start with (mod(pindex, power(2, 24))) = 0
            and rindex in
                ( select a.reference_index
                  from v$asm_alias a, v$asm_diskgroup b
                  where a.group_number = b.group_number
                        and (mod(a.parent_index, power(2, 24))) = 0
                        and a.name = '&dbname'
                )
connect by prior rindex = pindex;

---

emca -DBCONSOLE_HTTP_PORT 5500 -RMI_PORT 5520 -JMS_PORT 5540
-AGENT_PORT 1830


emca -config dbcontrol db -repos create

emca -config dbcontrol db -repos recreate