/ home / ibre5041 / ibre5041.ansible_oracle_modules / 3.2.0 / module / oracle_redo

ibre5041.ansible_oracle_modules.oracle_redo (3.2.0) — module

Manage Oracle redo related things

| "added in version" 3.0.0 of ibre5041.ansible_oracle_modules"

Authors: Mikael Sandström, oravirt@gmail.com, @oravirt, Ivan Brezina

Install collection

Install with ansible-galaxy collection install ibre5041.ansible_oracle_modules:==3.2.0

Add to requirements.yml

  collections:
    - name: ibre5041.ansible_oracle_modules
      version: 3.2.0

Description

Manage redogroups

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

See connection parameters for oracle_ping

Requirements

cx_Oracle

Usage examples

Scanned by Steampunk Spotter

- name: Manage online redologs
  oracle_redo:
    mode: sysdba
    log_type: redo
    size: 200M
    groups: 4

Scanned by Steampunk Spotter

- name: Manage standby redologs
  oracle_redo:
    mode: sysdba
    log_type: standby
    size: 200M
    groups: 5

Scanned by Steampunk Spotter

- 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:

Scanned by Steampunk Spotter

- 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

    
size:
    default: 50MB
    description: size of redologs
    required: true

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

log_type:
    choices:
    - redo
    - standby
    default: redo
    description: Redolog type, redo or standby