Oracle under linux VM Backup

[jereis]

Greetings,

I have an issue running a pre-backup script in Veeam Backup & Replication, I need to run a small script to put an oracle database in backup mode to have a consistent backup. I installed the oracle client on the same server hosting the Veeam software. The script is running perfectly from the command line but not through Veeam. The script also resides in the veeam server side.
Error message
Pre-job script terminated with exit code 1

The bat file is very simple:

Code: Select all

(
echo alter database begin backup;
echo ALTER SYSTEM ARCHIVE LOG CURRENT;
) | sqlplus user/backup@SID as sysdba 

Always giving me an error on pre-script, if that script did not run properly the restore is corrupted and I tested that.

I Appreciate your assistance in this regard

Thank you

[PTide]

Hi,

The script is running perfectly from the command line but not through Veeam

Did you mean Linux machine command line or Windows? If the latter, I'd suggest you to try specifying a full path to your sqlplus utility, for example:

Code: Select all

(
echo alter database begin backup;
echo ALTER SYSTEM ARCHIVE LOG CURRENT;
) | C:/Program Files/whatever/sqlplus user/backup@SID as sysdba

If the former, then I'd test your script from Windows command line.

Thank you.