opitzconsulting / opitzconsulting.ansible_oracle / 4.7.0 / module / oracle_redo Manage Oracle redo related things | "added in version" 2.4 of opitzconsulting.ansible_oracle" Authors: Mikael Sandström, oravirt@gmail.com, @oravirt preview | supported by communityopitzconsulting.ansible_oracle.oracle_redo (4.7.0) — module
Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0
collections: - name: opitzconsulting.ansible_oracle version: 4.7.0
Manage redogroups
Can be run locally on the controlmachine or on a remote host
- hosts: all gather_facts: true vars: oracle_home: /u01/app/oracle/12.2.0.1/db1 hostname: "{{ ansible_hostname }}" service_name: orclcdb user: system password: Oracle_123 oracle_env: ORACLE_HOME: "{{ oracle_home }}" LD_LIBRARY_PATH: "{{ oracle_home }}/lib" redosize: 15M numgroups: 3 tasks: - name: Manage redologs oracle_redo: service_name={{ service_name }} hostname={{ hostname}} user={{ user }} password={{ password }} groups={{ numgroups |default(omit) }} size={{ redosize |default(omit)}} environment: "{{ oracle_env }}" run_once: True
mode: choices: - normal - sysdba default: normal description: 'The mode with which to connect to the database ' required: true port: default: 1521 description: 'The listener port number on the host ' required: false size: default: 50MB description: size of redologs required: true user: description: 'The Oracle user name to connect to the database, must have DBA privilege ' required: false groups: description: The number of redolog groups required: false type: int members: default: 1 description: 'Either to set the preference (present) or reset it to default (absent) ' required: true hostname: default: localhost description: The Oracle database host required: false password: description: The Oracle user password for 'user' required: false service_name: description: 'The database service name to connect to ' required: true