Oracle RAC: Árvore de dependência de recursos

A opção -dependency do comando de visualização dos recursos do Oracle RAC está muito legal na 12c, exibindo em forma de árvore a dependência de recursos de todo o ambiente (por exemplo, o banco ORCL depende de DISKGROUPs, que dependem de ASM, que depende do Listener, que depende da Network).

[oracle@nerv02 ~]$ /u01/app/12.1.0.2/grid/bin/crsctl status res -dependency
================================================================================
Resource Start Dependencies
================================================================================
----------------------------ora.ASMNET1LSNR_ASM.lsnr----------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)->
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.CONFIG.dg----------------------------------
ora.CONFIG.dg(ora.diskgroup.type)->
| ora.asm(ora.asm.type)[hard,pullup]
| | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | ora.gns[weak:global]
| | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | ora.gns[weak:global]
--------------------------------------------------------------------------------
----------------------------------ora.DATA.dg-----------------------------------
ora.DATA.dg(ora.diskgroup.type)->
| ora.asm(ora.asm.type)[hard,pullup:always]
| | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | ora.gns[weak:global]
| | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | ora.gns[weak:global]
--------------------------------------------------------------------------------
-----------------------------------ora.FRA.dg-----------------------------------
ora.FRA.dg(ora.diskgroup.type)->
| ora.asm(ora.asm.type)[hard,pullup]
| | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | ora.gns[weak:global]
| | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | ora.gns[weak:global]
--------------------------------------------------------------------------------
-------------------------------ora.LISTENER.lsnr--------------------------------
ora.LISTENER.lsnr(ora.listener.type)->
| type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | ora.net1.network(ora.network.type)[hard,pullup]
| | ora.gns[weak:global]
--------------------------------------------------------------------------------
----------------------------ora.LISTENER_SCAN1.lsnr-----------------------------
ora.LISTENER_SCAN1.lsnr(ora.scan_listener.type)->
| ora.scan1.vip(ora.scan_vip.type)[hard,pullup]
| | ora.net1.network(ora.network.type)[hard,pullup:global]
| | ora.gns[weak:global]
| | type:ora.scan_vip.type[dispersion:type:active]
| type:ora.scan_listener.type[dispersion:type:active]
--------------------------------------------------------------------------------
----------------------------ora.LISTENER_SCAN2.lsnr-----------------------------
ora.LISTENER_SCAN2.lsnr(ora.scan_listener.type)->
| ora.scan2.vip(ora.scan_vip.type)[hard,pullup]
| | ora.net1.network(ora.network.type)[hard,pullup:global]
| | ora.gns[weak:global]
| | type:ora.scan_vip.type[dispersion:type:active]
| type:ora.scan_listener.type[dispersion:type:active]
--------------------------------------------------------------------------------
----------------------------ora.LISTENER_SCAN3.lsnr-----------------------------
ora.LISTENER_SCAN3.lsnr(ora.scan_listener.type)->
| ora.scan3.vip(ora.scan_vip.type)[hard,pullup]
| | ora.net1.network(ora.network.type)[hard,pullup:global]
| | ora.gns[weak:global]
| | type:ora.scan_vip.type[dispersion:type:active]
| type:ora.scan_listener.type[dispersion:type:active]
--------------------------------------------------------------------------------
-----------------------------------ora.OCR.dg-----------------------------------
ora.OCR.dg(ora.diskgroup.type)->
| ora.asm(ora.asm.type)[hard,pullup]
| | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | ora.gns[weak:global]
| | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | ora.gns[weak:global]
--------------------------------------------------------------------------------
-----------------------------------ora.VD.dg------------------------------------
ora.VD.dg(ora.diskgroup.type)->
| ora.asm(ora.asm.type)[hard,pullup]
| | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | ora.gns[weak:global]
| | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | ora.gns[weak:global]
--------------------------------------------------------------------------------
------------------------------------ora.asm-------------------------------------
ora.asm(ora.asm.type)->
| ora.LISTENER.lsnr(ora.listener.type)[weak]
| | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | ora.net1.network(ora.network.type)[hard,pullup]
| | | ora.gns[weak:global]
| ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | ora.gns[weak:global]
--------------------------------------------------------------------------------
------------------------------------ora.cvu-------------------------------------
ora.cvu(ora.cvu.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
--------------------------------------------------------------------------------
-----------------------------------ora.mgmtdb-----------------------------------
ora.mgmtdb(ora.mgmtdb.type)->
| ora.MGMTLSNR(ora.mgmtlsnr.type)[hard,pullup]
| ora.CONFIG.dg(ora.diskgroup.type)[hard:uniform,pullup]
| | ora.asm(ora.asm.type)[hard,pullup]
| | | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | | ora.gns[weak:global]
| | | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | | ora.gns[weak:global]
| type:ora.scan_listener.type[weak:type:global]
| | ora.scan1.vip(ora.scan_vip.type)[hard,pullup]
| | | ora.net1.network(ora.network.type)[hard,pullup:global]
| | | ora.gns[weak:global]
| | | type:ora.scan_vip.type[dispersion:type:active]
| | type:ora.scan_listener.type[dispersion:type:active]
| ora.ons(ora.ons.type)[weak]
| | ora.net1.network(ora.network.type)[hard,pullup]
--------------------------------------------------------------------------------
---------------------------------ora.nerv01.vip---------------------------------
ora.nerv01.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv02.vip---------------------------------
ora.nerv02.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv03.vip---------------------------------
ora.nerv03.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv04.vip---------------------------------
ora.nerv04.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv05.vip---------------------------------
ora.nerv05.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv06.vip---------------------------------
ora.nerv06.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv07.vip---------------------------------
ora.nerv07.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
---------------------------------ora.nerv08.vip---------------------------------
ora.nerv08.vip(ora.cluster_vip_net1.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak:global]
--------------------------------------------------------------------------------
------------------------------------ora.ons-------------------------------------
ora.ons(ora.ons.type)->
| ora.net1.network(ora.network.type)[hard,pullup]
--------------------------------------------------------------------------------
----------------------------------ora.orcl.db-----------------------------------
ora.orcl.db(ora.database.type)->
| ora.FRA.dg(ora.diskgroup.type)[hard:global:uniform,pullup:global]
| | ora.asm(ora.asm.type)[hard,pullup]
| | | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | | ora.gns[weak:global]
| | | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | | ora.gns[weak:global]
| ora.DATA.dg(ora.diskgroup.type)[hard:uniform,pullup]
| | ora.asm(ora.asm.type)[hard,pullup:always]
| | | ora.LISTENER.lsnr(ora.listener.type)[weak]
| | | | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | | | ora.net1.network(ora.network.type)[hard,pullup]
| | | | | ora.gns[weak:global]
| | | ora.ASMNET1LSNR_ASM.lsnr(ora.asm_listener.type)[hard,pullup]
| | | | ora.gns[weak:global]
| type:ora.listener.type[weak:type]
| | type:ora.cluster_vip_net1.type[hard:type,pullup:type]
| | | ora.net1.network(ora.network.type)[hard,pullup]
| | | ora.gns[weak:global]
| type:ora.scan_listener.type[weak:type]
| | ora.scan1.vip(ora.scan_vip.type)[hard,pullup]
| | | ora.net1.network(ora.network.type)[hard,pullup:global]
| | | ora.gns[weak:global]
| | | type:ora.scan_vip.type[dispersion:type:active]
| | type:ora.scan_listener.type[dispersion:type:active]
| ora.ons(ora.ons.type)[weak]
| | ora.net1.network(ora.network.type)[hard,pullup]
| ora.gns[weak]
--------------------------------------------------------------------------------
---------------------------------ora.scan1.vip----------------------------------
ora.scan1.vip(ora.scan_vip.type)->
| ora.net1.network(ora.network.type)[hard,pullup:global]
| ora.gns[weak:global]
| type:ora.scan_vip.type[dispersion:type:active]
--------------------------------------------------------------------------------
---------------------------------ora.scan2.vip----------------------------------
ora.scan2.vip(ora.scan_vip.type)->
| ora.net1.network(ora.network.type)[hard,pullup:global]
| ora.gns[weak:global]
| type:ora.scan_vip.type[dispersion:type:active]
--------------------------------------------------------------------------------
---------------------------------ora.scan3.vip----------------------------------
ora.scan3.vip(ora.scan_vip.type)->
| ora.net1.network(ora.network.type)[hard,pullup:global]
| ora.gns[weak:global]
| type:ora.scan_vip.type[dispersion:type:active]
--------------------------------------------------------------------------------
[oracle@nerv02 ~]$

4 comments

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.