A documentación de Oracle é clara no referente ás restricións para dispoñer de Flex Asm cunha base de datos 11.2.0.4 (que é o noso caso):
Table 4-4 Oracle ASM features enabled by disk group compatibility attribute settings
| Disk Group Features Enabled | COMPATIBLE.ASM | COMPATIBLE.RDBMS | COMPATIBLE.ADVM |
|---|---|---|---|
| Oracle ASM flex and extended disk groups | >= 12.2 | >= 12.2 | n/a |
Pois ben, imos explicar como saltar eta restrición
O matiz é… tela montada sobre acfs. 🙂
A nosa base de datos:
SYS@test11g1> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production [oracle@node1 ~]$ srvctl config database -d test11g Database unique name: test11g Database name: test11g Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_1 Oracle user: oracle Spfile: /acfs/prodata/TEST11G/spfiletest11g.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: test11g Database instances: test11g3,test11g1,test11g2 Disk Groups: Mount point paths: /acfs/proctlrdo,/acfs/prodata,/acfs/profra Services: pruebas Type: RAC Database is administrator managed
O noso clúster:
[grid@node1 ~]$ crsctl get cluster mode status Cluster is running in "flex" mode [grid@node1 ~]$ asmcmd showclustermode ASM cluster : Flex mode enabled [grid@node1 ~]$ srvctl config asm ASM home: <CRS home> Password file: +PROVOTOCR/orapwASM Backup of Password file: ASM listener: LISTENER ASM instance count: ALL Cluster ASM listener: ASMNET1LSNR_ASM,ASMNET2LSNR_ASM
Lanzamos unha carga de máis de 300.000TPMs coa ferramenta swingbench sobre a máquina.
Tiramos a instancia ASM no nodo 1 matando o proceso pmon dende o SO:
[grid@node1 ~]$ ps -ef |grep pmon grid 14164 1 0 13:16 ? 00:00:00 apx_pmon_+APX1 oracle 106603 1 0 15:57 ? 00:00:01 ora_pmon_test11g1 grid 157454 1 0 17:20 ? 00:00:00 asm_pmon_+ASM1 grid 189193 135315 0 18:13 pts/0 00:00:00 grep --color=auto pmon [grid@node1 ~]$ date; kill -9 157454 Wed Jul 12 18:14:19 CEST 2017 [grid@node1 ~]$ ps -ef |grep pmon grid 14164 1 0 13:16 ? 00:00:00 apx_pmon_+APX1 oracle 106603 1 0 15:57 ? 00:00:01 ora_pmon_test11g1 grid 189529 1 0 18:14 ? 00:00:00 asm_pmon_+ASM1 grid 189595 135315 0 18:14 pts/0 00:00:00 grep --color=auto pmon
O alert da instancia sobre ACFS nin se inmuta:
[baleiro]
e o alert do CRS o único que amosa é:
2017-07-12 18:14:20.030 [ORAAGENT(12204)]CRS-5011: Fallo al comprobar el recurso "ora.asm": Detalles en "(:CLSN00006:)" en "/u01/app/grid/diag/crs/ctbl109/crs/trace/crsd_oraagent_grid.trc" 2017-07-12 18:14:20.107 [ORAAGENT(12204)]CRS-5011: Fallo al comprobar el recurso "ora.asm": Detalles en "(:CLSN00006:)" en "/u01/app/grid/diag/crs/ctbl109/crs/trace/crsd_oraagent_grid.trc"
Pero para os nosos servizos e base de datos, todo segue igual:
ora.test11g.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1,STABLE
3 ONLINE ONLINE node3 Open,HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1,STABLE
ora.test11g.pruebas.svc
1 ONLINE ONLINE node1 STABLE
2 ONLINE ONLINE node2 STABLE
3 ONLINE ONLINE node3 STABLE
Incluso parando cun abort, e force, a instancia ASM do nodo, e todo segue a funcionar:
[grid@node1 ~]$ srvctl stop asm -n node1 -stopoption ABORT -force
[grid@node3 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.ASMNET2LSNR_ASM.lsnr
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.MGMTDB.dg
ONLINE ONLINE node3 STABLE
OFFLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROADMIN.VPROADMIN.advm
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROADMIN.VPROADMINXP.advm
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROADMIN.dg
ONLINE ONLINE node3 STABLE
OFFLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROCTLRDO.VPROCTLRDO.advm
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROCTLRDO.dg
ONLINE ONLINE node3 STABLE
OFFLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PRODATA.VPRODATA.advm
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PRODATA.dg
ONLINE ONLINE node3 STABLE
OFFLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROFRA.VPROFRA.advm
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROFRA.dg
ONLINE ONLINE node3 STABLE
OFFLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.PROVOTOCR.dg
ONLINE ONLINE node3 STABLE
OFFLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.chad
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.net1.network
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.ons
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.proadmin.vproadmin.acfs
ONLINE ONLINE node3 mounted on /acfs/proadmin,STABLE
ONLINE ONLINE node1 mounted on /acfs/proadmin,STABLE
ONLINE ONLINE node2 mounted on /acfs/proadmin,STABLE
ora.proadmin.vproadminxp.acfs
ONLINE ONLINE node3 mounted on /acfs/proexpdp,STABLE
ONLINE ONLINE node1 mounted on /acfs/proexpdp,STABLE
ONLINE ONLINE node2 mounted on /acfs/proexpdp,STABLE
ora.proctlrdo.vproctlrdo.acfs
ONLINE ONLINE node3 mounted on /acfs/proctlrdo,STABLE
ONLINE ONLINE node1 mounted on /acfs/proctlrdo,STABLE
ONLINE ONLINE node2 mounted on /acfs/proctlrdo,STABLE
ora.prodata.vprodata.acfs
ONLINE ONLINE node3 mounted on /acfs/prodata,STABLE
ONLINE ONLINE node1 mounted on /acfs/prodata,STABLE
ONLINE ONLINE node2 mounted on /acfs/prodata,STABLE
ora.profra.vprofra.acfs
ONLINE ONLINE node3 mounted on /acfs/profra,STABLE
ONLINE ONLINE node1 mounted on /acfs/profra,STABLE
ONLINE ONLINE node2 mounted on /acfs/profra,STABLE
ora.proxy_advm
ONLINE ONLINE node3 STABLE
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node3 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE node2 169.254.15.171 10.2.7.123 10.2.8.123,STABLE
ora.asm
1 OFFLINE OFFLINE Instance Shutdown,STABLE
2 ONLINE ONLINE node2 Started,STABLE
3 ONLINE ONLINE node3 Started,STABLE
ora.node3.vip
1 ONLINE ONLINE node3 STABLE
ora.node1.vip
1 ONLINE ONLINE node1 STABLE
ora.node2.vip
1 ONLINE ONLINE node2 STABLE
ora.cvu
1 ONLINE ONLINE node2 STABLE
ora.mgmtdb
1 ONLINE ONLINE node2 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE node2 STABLE
ora.scan1.vip
1 ONLINE ONLINE node3 STABLE
ora.scan2.vip
1 ONLINE ONLINE node1 STABLE
ora.scan3.vip
1 ONLINE ONLINE node2 STABLE
ora.test11g.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1,STABLE
3 ONLINE ONLINE node3 Open,HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1,STABLE
ora.test11g.pruebas.svc
1 ONLINE ONLINE node1 STABLE
2 ONLINE ONLINE node2 STABLE
3 ONLINE ONLINE node3 STABLE
-------------------------------------------------------------------------------
Agora xa tes unha razón máis para migrar a ACFS 😉
Non olvidedes outra razón de igual peso… “snapshots” das nosas bases de datos en quente para backups e para montar contornos de test/desenvolvemento en minutos!!
Recomendamos o emprego da ferramenta gDBClone.
Sumando con Arumel!!