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 ~]$
Ficou bem interessante! Obrigada Portilho 😉
Obrigado pelo comentário Róli!
Gostei!!!
Obrigado Jamil!