failed to execute pre-job script

[Fegume]

Hello,

I have one problem, I make the manual script rman. I'm using that plugin Rman with Veeam. When I run any backup job with pre-job script configure, that failed.

I find this log:

Code: Select all

[26.10.2020 18:45:46.758] <139792042215168>        | Thread started. Thread id: 139792042215168, parent id: 139792075499392, role: Managed volume backup job execution
[26.10.2020 18:45:46.761] <139792042215168> lpbcore| ManagedBackupJobPerformer: Creating backup.
[26.10.2020 18:45:46.768] <139792075499392> lpbcore|   LpbManSession: Starting managed backup job. ok.
[26.10.2020 18:45:46.768] <139792042215168> lpbcore|   BObject ID: [{60f2dbb3-fdaf-4da7-a435-9a45505b3b10}].
[26.10.2020 18:45:46.768] <139792033822464>        | Thread started. Thread id: 139792033822464, parent id: 139792042215168, role: Session checker for Job: {c2381cb7-fb2c-4ec8-aafb-96fa98738856}.
[26.10.2020 18:45:46.769] <139792042215168> vmb    |   [SessionLog][info] Executing pre-job script.
[26.10.2020 18:45:46.803] <139792042215168> lpbcomm|   Executing custom script: [/var/lib/veeam/scripts/0f74ba5c-5d9d-4866-b0e1-ff8f3d1680a9/pre/full_backup_rman.sh]. Arguments: []
[26.10.2020 18:45:46.804] <139792025429760>        | Thread started. Thread id: 139792025429760, parent id: 139792042215168, role: script output redirector to log
[26.10.2020 18:45:46.804] <139792017037056>        | Thread started. Thread id: 139792017037056, parent id: 139792042215168, role: script output redirector to buffer
[26.10.2020 18:45:46.804] <139792008644352>        | Thread started. Thread id: 139792008644352, parent id: 139792042215168, role: Pid waiter. timeout: 2400
[26.10.2020 18:45:46.805] <139792017037056>        | Thread finished. Role: 'script output redirector to buffer'.
[26.10.2020 18:45:46.805] <139792025429760>        | Thread finished. Role: 'script output redirector to log'.
[26.10.2020 18:45:46.805] <139792008644352>        | Thread finished. Role: 'Pid waiter. timeout: 2400'.
[26.10.2020 18:45:46.805] <139792042215168> lpbcomm|   Executing custom script: [/var/lib/veeam/scripts/0f74ba5c-5d9d-4866-b0e1-ff8f3d1680a9/pre/full_backup_rman.sh]. Arguments: [] ok.
[26.10.2020 18:45:46.805] <139792042215168> vmb    |   [SessionLog][warn] Failed to execute pre-job script.
[26.10.2020 18:45:46.832] <139792042215168> lpbcore| ERR |Failed to execute pre-job script.
[b][26.10.2020 18:45:46.832] <139792042215168> lpbcore| >>  |/var/lib/veeam/scripts/0f74ba5c-5d9d-4866-b0e1-ff8f3d1680a9/pre/full_backup_rman.sh[39]: rman: not found[/b]
[26.10.2020 18:45:46.832] <139792042215168> lpbcore| >>  |
[26.10.2020 18:45:46.832] <139792042215168> lpbcore| >>  |Exit code: [127]
[26.10.2020 18:45:46.832] <139792042215168> lpbcore| >>  |Failed to execute script command /var/lib/veeam/scripts/0f74ba5c-5d9d-4866-b0e1-ff8f3d1680a9/pre/full_backup_rman.sh
[26.10.2020 18:45:46.832] <139792042215168> lpbcore| >>  |Failed to execute script [/var/lib/veeam/scripts/0f74ba5c-5d9d-4866-b0e1-ff8f3d1680a9/pre/full_backup_rman.sh].
[26.10.2020 18:45:46.832] <139792042215168> lpbcore| >>  |An exception was thrown from thread [139792042215168].
[26.10.2020 18:45:46.935] <139792025429760>        | Thread started. Thread id: 139792025429760, parent id: 139792042215168, role: lease keeper
[26.10.2020 18:45:46.949] <139792042215168> vmb    |   [SessionLog][info] Preparing to backup.
[26.10.2020 18:45:46.969] <139792042215168> lpbcore|   Prepare DB model for backup
[26.10.2020 18:45:46.969] <139792042215168> lpbcore|     Prepare db model for backup via oib: {933163f8-1be3-4bc9-989d-d629a4636cbd}
[26.10.2020 18:45:47.028] <139792042215168> lpbcore|   Prepare DB model for backup ok.
[26.10.2020 18:45:47.028] <139792042215168> lpbcore|   Update data for oib: {933163f8-1be3-4bc9-989d-d629a4636cbd}
[26.10.2020 18:45:47.028] <139792042215168> lpbcore|     Add network adapters info

I use this user configured: https://1drv.ms/u/s!AhEgG4C2IYtVg9Z9Plc ... w?e=D4aRIa

The script is this:

Code: Select all

#!/bin/ksh


rman target / <<EOF


run
{
backup database TAG=FULL_TAG;
}


sql 'alter system archive log current';
run
{
backup filesperset 500 archivelog all TAG=ARCH_TAG;
}


list archivelog all backed up 1 times to device type sbt;
run
{
crosscheck backupset;
crosscheck archivelog;
delete noprompt archivelog all backed up 1 times to device type sbt;
}

EOF

This error is the same if I try run the script with user root and not oracle.

any idea?

thanks!

[Natalia Lupacheva]

Hi,

Just a suggestion, I see you get

Code: Select all

rman: not found

here. Did you check ORACLE_SID,ORACLE_HOME in PATH variable?
If yes and you suppose it's VBR issue, please open a support ticket.

Thanks!

[PetrM]

Hello,

@Fegume could you please clarify:
1) What is the purpose to trigger RMAN script on VBR side via pre-job script?
2) Are you talking about pre-job scripts or pre-freeze scripts?

If the RMAN plug-in is configured on the source server, you can run RMAN script directly on Oracle server and database backups will be streamed to Veeam repository.
Alternatively, you can use image-level approach to backup the entire server but I wouldn't recommend to leverage both of these approaches simultaneously.

Thanks!