ari_stark.ansible_oracle_modules.oracle_redo (1.2.1) — module

Install collection

Install with ansible-galaxy collection install ari_stark.ansible_oracle_modules:==1.2.1

Add to requirements.yml

  collections:
    - name: ari_stark.ansible_oracle_modules
      version: 1.2.1

Description

Manage redogroups

Can be run locally on the controlmachine or on a remote host

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- 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

Inputs

    
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

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