Hey guys.
I'm passing commands to rman through a variable created by the shell module.
Where am I going wrong?
...
- name: Creates purge script from the original script
shell: egrep -i 'connect|delete' "{{ script_path }}" | sed
'/^#/d;/delete/I s/[0-9]\{1,\}/1/'
register: script_path_tmp
- name: Print var
debug:
msg: "{{ script_path_tmp.stdout_lines }}"
- name: Runs RMAN archivelog purge script
shell:
cmd: |
{{ env_orahome }}/bin/rman << EOF
"{{ script_path_tmp.stdout_lines }}"
EOF
environment:
ORACLE_HOME: "{{ env_orahome }}"
register: rman_out
# Result of execution:
TASK [Print var]
******************************************************************************************************************
ok: [hostname] => {
"msg": [
"CONNECT TARGET \"USER/pass@service as sysbackup\"",
"DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE
sbt;"
]
}
TASK [Runs RMAN archivelog purge script]
***********************************************************************************************
fatal: [hostname]: FAILED! => {"changed": true, "cmd":
"/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/rman << EOF\n \"[u'CONNECT
TARGET \"USER/pass@service as sysbackup\"', u'DELETE NOPROMPT ARCHIVELOG
ALL BACKED UP 1 TIMES TO DEVICE TYPE sbt;']\"\nEOF\n", "delta":
"0:00:00.552187", "end": "2023-08-11 10:22:21.657952", "msg": "non-zero
return code", "rc": 1, "start": "2023-08-11 10:22:21.105765", "stderr": "",
"stderr_lines": [], "stdout": "\nRecovery Manager: Release 19.0.0.0.0 -
Production on Fri Aug 11 10:22:21 2023\nVersion 19.16.0.0.0\n\nCopyright
(c) 1982, 2019, Oracle and/or its affiliates. All rights
reserved.\n\nRMAN> \nRMAN-00571:
===========================================================\nRMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571:
===========================================================\nRMAN-00558:
error encountered while parsing input commands\nRMAN-01009: syntax error:
found \"double-quoted-string\": expecting one of: \"advise, allocate,
alter, analyze, associate statistics, audit, backup, begin, @, call,
catalog, change, comment, commit, configure, connect, convert, copy,
create, create catalog, create global, create or replace global, create or
replace script, create script, crosscheck, declare, delete, delete from,
describe, describe catalog, disassociate statistics, drop, drop catalog,
drop database, duplicate, exit, explain plan, flashback, flashback table,
grant, grant catalog, grant register, host, import, insert, list, lock,
merge, mount, noaudit, open, print, purge, quit, recover, register,
release\"\nRMAN-01007: at line 1 column 3 file: standard input\n\nRMAN>
\n\nRecovery Manager complete.", "stdout_lines": ["", "Recovery Manager:
Release 19.0.0.0.0 - Production on Fri Aug 11 10:22:21 2023", "Version
19.16.0.0.0", "", "Copyright (c) 1982, 2019, Oracle and/or its affiliates.
All rights reserved.", "", "RMAN> ", "RMAN-00571:
===========================================================", "RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============", "RMAN-00571:
===========================================================", "RMAN-00558:
error encountered while parsing input commands", "RMAN-01009: syntax error:
found \"double-quoted-string\": expecting one of: \"advise, allocate,
alter, analyze, associate statistics, audit, backup, begin, @, call,
catalog, change, comment, commit, configure, connect, convert, copy,
create, create catalog, create global, create or replace global, create or
replace script, create script, crosscheck, declare, delete, delete from,
describe, describe catalog, disassociate statistics, drop, drop catalog,
drop database, duplicate, exit, explain plan, flashback, flashback table,
grant, grant catalog, grant register, host, import, insert, list, lock,
merge, mount, noaudit, open, print, purge, quit, recover, register,
release\"", "RMAN-01007: at line 1 column 3 file: standard input", "",
"RMAN> ", "", "Recovery Manager complete."]}
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/CAL-Q%3DKsHu5EJjwsdejwEEz9AwEFOefgPe7%3DkqD2RqWTUumeu_Q%40mail.gmail.com.
