pillar data:

database:
  test2:
    sid: test2
    totalMemory: "3000"
  
  beta2:
    sid: beta2
    totalMemory: "3000"

state file:

{% for name, db in pillar.get('database', {}).items()  %}
{{ name }}_gridfo:
  file.managed:
    - name: /srv/grid/{{ name }}_failover.sh
    - source: salt://oracle/blade/grid/failover.sh
    - user: oracle
    - template: jinja
    - mode: 755
{% endfor%}

failover.sh: 

#!/bin/bash

export ORACLE_HOME=/srv/oracle/db/product/12.1.0/dbhome_1
export ORACLE_TOTALMEMORY={{ totalMemory }}