Re: [Bacula-users] Issue backing up Oracle database using Bacula

nagaraj mogaroy wrote:
> Hello,
>
> I've been trying to set up a backup of our Oracle database using
> Bacula,
> following the steps in the below link:
>
> http://wiki.bacula.org/doku.php?id=application_specific_backups:oracle_rdbms
>
> However, I encounter the following errors during the backup process:
>
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: SP2-0734:
> unknown
> command beginning "/var/oracl..." - rest of line ignored.
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: -rw-rw----
> 16785408 2010/06/25 08:55:03 RBL_CORE.dbf
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob:
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: sent 63
> bytes
> received 20 bytes 23.71 bytes/sec
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: total size
> is
> 16785408 speedup is 202233.83
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob:
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: SP2-0734:
> unknown
> command beginning "/var/oracl..." - rest of line ignored.
> 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: -rw-rw----
> 16785408 2010/06/25 08:55:07 suncata.dbf
> 25-Jun 09:25 tapti18522-fd JobId 20: ClientRunBeforeJob: SP2-0734:
> unknown
> command beginning "/var/oracl..." - rest of line ignored.
> 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: alter
> system
> archive log all
> 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: *
> 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: ERROR at
> line 1:
> 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: ORA-00271:
> there
> are no logs that need archiving
>
> The control file and the archive redo logs get backedup alright.It's
> only
> the data files that I am facing the issue.
> Being new to Oracle/sqlplus, I am stuck here, and no amount of
> googling has
> helped.I have also tried setting sqlblanklines to ON in the script,
> as
> suggested in one of the forums, but that didn't help.
> Would greatly appreciate if someone can guide me here.
>
> Note: I have not added the scripts here as I just copied them from
> the
> mentioned link and pasted them in my server, changing only the paths
> where
> necessary.

Have you downloaded and installed the various scripts mentioned on
that wiki (namely runbeforebackup.sh, runafterbackup.sh etc - there
are 5 named)?

If so, what path have you saved them at, and have you made the *.sh
scripts executable after downloading them (using the chmod command)?

If you have saved them to a different location, have you also
changed the sudoers file and any other scripts that refer to them?
--
Mike Holden

http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts

Hi,

Thanks for the reply, I have double checked all the points highlighted by you, and they all seem OK.All the scripts are in place with 775 permissions, and their paths mentioned correctly in sudoers file.Proper permissions have also been assigned to the bacula and oracle users.

Any other suggestions, please?

Thanks,
NK Mogaroy

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users