[Bacula-users] Issue backing up Oracle database using Bacula
Mike Holden wrote: Mogaroy wrote: Got it working finally !! Thanks Mike, for the detailed explanation, and also for updating the wiki. It will definitely save a lot of trouble for anyone intending to backup oracle with bacula using the steps mentioned in the earlier version of the wiki. Thanks to the original author too ! Regards, NK Mogaroy No problem. Glad you got it working ok. I'm happy to give back to the bacula project, as I use the product, but am not expert enough to give good assistance to most users. Oracle, however is another matter, as I am very much an Oracle expert, as that is what I get paid for in my day job :-) -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts -- 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.net https://lists.sourceforge.net/lists/listinfo/bacula-users Good to know that you are an Oracle expert, Mike! If I am not bothering you too much, could you please elaborate on the recovery part? I've also added a warning that the recovery script quoted on that page should not be used directly, even with modified paths, as it simply won't work without heavy changes. You should instead use the scripts that the backup process generates for you using the alter database backup controlfile commands. It's myu opinion that the paragraph is too dangerous to include there in it's current form! What are the 'heavy changes' that you refer to? I have no prior experience with Oracle backup and recovery (though I'm trying to educate myself through online docs). However, your help in this particular context would be much appreciated ! Thanks, NK Mogaroy +-- |This was sent by moga...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Issue backing up Oracle database using Bacula
Mike Holden wrote:
Mogaroy wrote:
Thanks Mike, for clearing up a few things.Appreciate your patience !
I finally managed to identify the cause of the errors.The problem,
as I see it, is with the way in which the hotbackupscript.sql is
being created.
The host rsync command inside that file is being split into 2 lines
instead of appearing in a single line.Just to be sure, I edited
the file to make the first couple of commands appear in a single
line and tested by running it manually from SQL prompt, and the
script executes successfully!
This is how the commands appear in the hotbackupscript.sql file:
host rm -f /var/oracle/backup/*
ALTER TABLESPACE ATGINT BEGIN BACKUP;
host rsync -vcW
/home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/ATGINT.dbf
/var/oracle/backup/
ALTER TABLESPACE ATGINT END BACKUP;
ALTER TABLESPACE ATL_CONTENT_DATA BEGIN BACKUP;
host rsync -vcW /home/dbusr/app/dbusr/oradata/orcl/ATL_CONTENT_DATA
/var/oracle/backup/
ALTER TABLESPACE ATL_CONTENT_DATA END BACKUP;
ALTER TABLESPACE ATL_CONTROL_DATA BEGIN BACKUP;
host rsync -vcW /home/dbusr/app/dbusr/oradata/orcl/ATL_CONTROL_DATA
/var/oracle/backup/
ALTER TABLESPACE ATL_CONTROL_DATA END BACKUP;
ALTER TABLESPACE AT_CATA BEGIN BACKUP;
host rsync -vcW
/home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/atcata.dbf
/var/oracle/backup/
ALTER TABLESPACE AT_CATA END BACKUP;
ALTER TABLESPACE AT_CATB BEGIN BACKUP;
host rsync -vcW
/home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/atcatb.dbf
/var/oracle/backup/
I tried different combinations of placing the quotes in the relevant
line of runhotbackup.sql(with spaces, without space etc), but no
matter
how I try, am not able to have the hotbackupscript.sql file
generated in the right format(i,e having the rsync command in a
single line).Any
help here would be greatly appreciated.
Thanks again for guiding me thus far !!
NK Mogaroy
Sqlplus works with a linelength that, by default, is 80 characters.
This looks like the reason for the text being split.
Try adding the following line to the top of the hotbackup sql script#058;
set linesize 500
If 500 is not wide enough, you can increase the value still further,
up to several thousand if necessary.
As you can see from the following code snippet (prints a line of 90
stars, both with a line size of 80 and then 500), this will resolve
your issue:
Code:
set linesize 80
begin
dbms_output.put_line(LPAD('*', 90, '*'));
end;
/
set linesize 500
begin
dbms_output.put_line(LPAD('*', 90, '*'));
end;
/
Output:
SQL set linesize 80
SQL begin
SQL dbms_output.put_line(LPAD('*', 90, '*'));
SQL end;
SQL /
**
PL/SQL procedure successfully completed.
SQL set linesize 500
SQL begin
SQL dbms_output.put_line(LPAD('*', 90, '*'));
SQL end;
SQL /
**
PL/SQL procedure successfully completed.
Note that email line wrapping may bork that output a bit in
transmission, but you should also be able to see that the second set
of stars is on fewer lines than the first. Try it in your own
sqlplus session to see the difference for yourself!
I would add an extra couple of points of interest here:
1. You may wish to consider adding:
set trimspool on
at the top as, by default, each line is padded to the line width,
making for a much bigger file.
2. If you have a lot of files and tablespaces to process, it is
possible that the buffer size of 2 set up at the top (in the
call to dbms_output.enable(2)) is not big enough. I would
suggest increasing this value to 2 million, which is the maximum
value allowed. I've also go no idea why this is run as a separate
exec call at the top, rather than as the first line of the pl/sql
script!
If I can find how to register as a wiki contributor, I'll update the
page, otherwise somebody else may wish to take on these minor
modifications?
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
--
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Got it working finally !! Thanks Mike, for the detailed explanation, and also
for updating the wiki. It will definitely save a lot of trouble for anyone
intending to backup oracle with bacula using the steps mentioned in the earlier
version of the wiki.
Thanks to the original author too !
Regards,
NK
Re: [Bacula-users] Issue backing up Oracle database using Bacula
Mogaroy wrote: Got it working finally !! Thanks Mike, for the detailed explanation, and also for updating the wiki. It will definitely save a lot of trouble for anyone intending to backup oracle with bacula using the steps mentioned in the earlier version of the wiki. Thanks to the original author too ! Regards, NK Mogaroy No problem. Glad you got it working ok. I'm happy to give back to the bacula project, as I use the product, but am not expert enough to give good assistance to most users. Oracle, however is another matter, as I am very much an Oracle expert, as that is what I get paid for in my day job :-) -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Issue backing up Oracle database using Bacula
Mike Holden wrote: Mogaroy wrote: Thanks Mike, No problem!! Will recheck the points you mentioned.Meanwhile, some searching has led me to feel that it has something to do with the PL/SQL script (runhotbackup.sql) which does the actual backup to local disk (/var/oracle/backup) in my case. The 'host' command which is used in the script to rsync the datafiles is not recognized by PL/SQL, and maybe that's causing it to throw the errors. http://www.orafaq.com/wiki/PL/SQL_FAQ To verify, I tried copying a single file, running the command manually from SQL prompt, and the file got copied successfully. But, since the author of the script has tested the whole thing successfully, I'm wondering if it indeed is the cause. I came upon an earlier thread where the author mentions about his article, and I'm following it up there as well hoping to find a solution: http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/oracle-database-backup-question-79798/#33 The hotbackup script doesn't use pl/sql to execute a host command. What is does is create a text file containing a list of commands, several of which are host statements. It then uses that generated script as input into an sqlplus session to do the actual backup commands. Like I said earlier, if your commands and database files are stored in different directories to where the original authore placed them, you will need to modify the runhotbackup.sql script to put the correct locations, as well as any of the other files that you copied from that wiki entry at http://wiki.bacula.org/doku.php?id=application_specific_backups:oracle_rdbms In detail, the hotbackup script does the following steps: creates a file called /app/oracle/oradata/db1/scripts/hotbackupscript.sql, as defined in the spool statement. This path must exist and be writeable to the user. This script file will be written to incluse a number of sqlplus statements, which are later executed using the line beginning with at right at the bottom. It then adds commands to do the following: does an rm of /app/oracle/backup/*, so again this directory must exist and be writeable. Create a list of ALTER DATABASE statements to enter and exit hot backup mode for the tablespace. For each tablespace, it also adds an host rsync command into the file to do the backup copy to /app/oracle/backup for each datafile in the current tablespace (a tablespace may have several datafiles). Finally, once this loop for tablespaces has completed, it adds various other commands to backup controlfiles, handle archived redologs etc. So you see, pl/sql ISN'T running a host statement at all, sqlplus is! Maybe if you told us exactly what changes tou made to the locations from the original wiki, and what changes you made to the scripts we may be able to spot what is wrong! Can you run the hotbackup script directly in sqlplus using at runhotbackup.sql from within sqlplus? If so, then the problem is elsewhere, if not then error message sill help us diagnose the problem further. -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts -- 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.net https://lists.sourceforge.net/lists/listinfo/bacula-users Thanks Mike, for clearing up a few things.Appreciate your patience ! I finally managed to identify the cause of the errors.The problem, as I see it, is with the way in which the hotbackupscript.sql is being created. The host rsync command inside that file is being split into 2 lines instead of appearing in a single line.Just to be sure, I edited the file to make the first couple of commands appear in a single line and tested by running it manually from SQL prompt, and the script executes successfully! This is how the commands appear in the hotbackupscript.sql file: host rm -f /var/oracle/backup/* ALTER TABLESPACE ATGINT BEGIN BACKUP; host rsync -vcW /home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/ATGINT.dbf /var/oracle/backup/ ALTER TABLESPACE ATGINT END BACKUP; ALTER TABLESPACE ATL_CONTENT_DATA BEGIN BACKUP; host rsync -vcW /home/dbusr/app/dbusr/oradata/orcl/ATL_CONTENT_DATA /var/oracle/backup/ ALTER TABLESPACE ATL_CONTENT_DATA END BACKUP; ALTER TABLESPACE ATL_CONTROL_DATA BEGIN BACKUP; host rsync -vcW /home/dbusr/app/dbusr/oradata/orcl/ATL_CONTROL_DATA /var/oracle/backup/ ALTER TABLESPACE ATL_CONTROL_DATA END BACKUP; ALTER TABLESPACE AT_CATA BEGIN BACKUP; host rsync -vcW /home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/atcata.dbf
Re: [Bacula-users] Issue backing up Oracle database using Bacula
Mogaroy wrote:
Thanks Mike, for clearing up a few things.Appreciate your patience !
I finally managed to identify the cause of the errors.The problem,
as I see it, is with the way in which the hotbackupscript.sql is
being created.
The host rsync command inside that file is being split into 2 lines
instead of appearing in a single line.Just to be sure, I edited
the file to make the first couple of commands appear in a single
line and tested by running it manually from SQL prompt, and the
script executes successfully!
This is how the commands appear in the hotbackupscript.sql file:
host rm -f /var/oracle/backup/*
ALTER TABLESPACE ATGINT BEGIN BACKUP;
host rsync -vcW
/home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/ATGINT.dbf
/var/oracle/backup/
ALTER TABLESPACE ATGINT END BACKUP;
ALTER TABLESPACE ATL_CONTENT_DATA BEGIN BACKUP;
host rsync -vcW /home/dbusr/app/dbusr/oradata/orcl/ATL_CONTENT_DATA
/var/oracle/backup/
ALTER TABLESPACE ATL_CONTENT_DATA END BACKUP;
ALTER TABLESPACE ATL_CONTROL_DATA BEGIN BACKUP;
host rsync -vcW /home/dbusr/app/dbusr/oradata/orcl/ATL_CONTROL_DATA
/var/oracle/backup/
ALTER TABLESPACE ATL_CONTROL_DATA END BACKUP;
ALTER TABLESPACE AT_CATA BEGIN BACKUP;
host rsync -vcW
/home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/atcata.dbf
/var/oracle/backup/
ALTER TABLESPACE AT_CATA END BACKUP;
ALTER TABLESPACE AT_CATB BEGIN BACKUP;
host rsync -vcW
/home/dbusr/app/dbusr/product/11.1.0/db_1/dbs/atcatb.dbf
/var/oracle/backup/
I tried different combinations of placing the quotes in the relevant
line of runhotbackup.sql(with spaces, without space etc), but no
matter
how I try, am not able to have the hotbackupscript.sql file
generated in the right format(i,e having the rsync command in a
single line).Any
help here would be greatly appreciated.
Thanks again for guiding me thus far !!
NK Mogaroy
Sqlplus works with a linelength that, by default, is 80 characters.
This looks like the reason for the text being split.
Try adding the following line to the top of the hotbackup sql script:
set linesize 500
If 500 is not wide enough, you can increase the value still further,
up to several thousand if necessary.
As you can see from the following code snippet (prints a line of 90
stars, both with a line size of 80 and then 500), this will resolve
your issue:
Code:
set linesize 80
begin
dbms_output.put_line(LPAD('*', 90, '*'));
end;
/
set linesize 500
begin
dbms_output.put_line(LPAD('*', 90, '*'));
end;
/
Output:
SQL set linesize 80
SQL begin
SQL dbms_output.put_line(LPAD('*', 90, '*'));
SQL end;
SQL /
**
PL/SQL procedure successfully completed.
SQL set linesize 500
SQL begin
SQL dbms_output.put_line(LPAD('*', 90, '*'));
SQL end;
SQL /
**
PL/SQL procedure successfully completed.
Note that email line wrapping may bork that output a bit in
transmission, but you should also be able to see that the second set
of stars is on fewer lines than the first. Try it in your own
sqlplus session to see the difference for yourself!
I would add an extra couple of points of interest here:
1. You may wish to consider adding:
set trimspool on
at the top as, by default, each line is padded to the line width,
making for a much bigger file.
2. If you have a lot of files and tablespaces to process, it is
possible that the buffer size of 2 set up at the top (in the
call to dbms_output.enable(2)) is not big enough. I would
suggest increasing this value to 2 million, which is the maximum
value allowed. I've also go no idea why this is run as a separate
exec call at the top, rather than as the first line of the pl/sql
script!
If I can find how to register as a wiki contributor, I'll update the
page, otherwise somebody else may wish to take on these minor
modifications?
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Issue backing up Oracle database using Bacula
Mike Holden wrote: If I can find how to register as a wiki contributor, I'll update the page, otherwise somebody else may wish to take on these minor modifications? I've registered and updated the wiki page at http://wiki.bacula.org/doku.php?id=application_specific_backups:oracle_rdbms with the suggested changes. I've also added a warning that the recovery script quoted on that page should not be used directly, even with modified paths, as it simply won't work without heavy changes. You should instead use the scripts that the backup process generates for you using the alter database backup controlfile commands. It's myu opinion that the paragraph is too dangerous to include there in it's current form! -- Mike Holden -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Issue backing up Oracle database using Bacula
nagaraj mogaroy wrote: 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? The multiple error messages unknown command beginning /var/oracl... - rest of line ignored imply that it is having trouble executing the shell commands. This could be for one (or more) of several reasons, including any of the following: 1. The file name does not exist 2. The file exists, but it does not have execute permission for the current user. 3. The file exists and has correct permissions, but the user doesn't have permissions to descend into the higher directories (missing read and/or execute permissions on /var, /var/oracle etc). 4. The script is ok, but it includes a line at the top which looks like #!/bin/sh or similar (without the quotes) (often called a shebang line), but the file /bin/sh doesn't exist. You will need to correct the location of the appropriate sh or bash or ksh executable file in this case. 5. sudo or some other security mechanism (SELinux etc) is blocking execution. You may be able to check the logs for these applications to see if this is the case. -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Issue backing up Oracle database using Bacula
Mike Holden wrote: nagaraj mogaroy wrote: 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? The multiple error messages unknown command beginning /var/oracl... - rest of line ignored imply that it is having trouble executing the shell commands. This could be for one (or more) of several reasons, including any of the following: 1. The file name does not exist 2. The file exists, but it does not have execute permission for the current user. 3. The file exists and has correct permissions, but the user doesn't have permissions to descend into the higher directories (missing read and/or execute permissions on /var, /var/oracle etc). 4. The script is ok, but it includes a line at the top which looks like #!/bin/sh or similar (without the quotes) (often called a shebang line), but the file /bin/sh doesn't exist. You will need to correct the location of the appropriate sh or bash or ksh executable file in this case. 5. sudo or some other security mechanism (SELinux etc) is blocking execution. You may be able to check the logs for these applications to see if this is the case. -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts -- 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.net https://lists.sourceforge.net/lists/listinfo/bacula-users Thanks Mike, Will recheck the points you mentioned.Meanwhile, some searching has led me to feel that it has something to do with the PL/SQL script (runhotbackup.sql) which does the actual backup to local disk (/var/oracle/backup) in my case. The 'host' command which is used in the script to rsync the datafiles is not recognized by PL/SQL, and maybe that's causing it to throw the errors. http://www.orafaq.com/wiki/PL/SQL_FAQ To verify, I tried copying a single file, running the command manually from SQL prompt, and the file got copied successfully. But, since the author of the script has tested the whole thing successfully, I'm wondering if it indeed is the cause. I came upon an earlier thread where the author mentions about his article, and I'm following it up there as well hoping to find a solution: http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/oracle-database-backup-question-79798/#33 Thanks, NK Mogaroy +-- |This was sent by moga...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Issue backing up Oracle database using Bacula
Mogaroy wrote: Thanks Mike, No problem!! Will recheck the points you mentioned.Meanwhile, some searching has led me to feel that it has something to do with the PL/SQL script (runhotbackup.sql) which does the actual backup to local disk (/var/oracle/backup) in my case. The 'host' command which is used in the script to rsync the datafiles is not recognized by PL/SQL, and maybe that's causing it to throw the errors. http://www.orafaq.com/wiki/PL/SQL_FAQ To verify, I tried copying a single file, running the command manually from SQL prompt, and the file got copied successfully. But, since the author of the script has tested the whole thing successfully, I'm wondering if it indeed is the cause. I came upon an earlier thread where the author mentions about his article, and I'm following it up there as well hoping to find a solution: http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/oracle-database-backup-question-79798/#33 The hotbackup script doesn't use pl/sql to execute a host command. What is does is create a text file containing a list of commands, several of which are host statements. It then uses that generated script as input into an sqlplus session to do the actual backup commands. Like I said earlier, if your commands and database files are stored in different directories to where the original authore placed them, you will need to modify the runhotbackup.sql script to put the correct locations, as well as any of the other files that you copied from that wiki entry at http://wiki.bacula.org/doku.php?id=application_specific_backups:oracle_rdbms In detail, the hotbackup script does the following steps: creates a file called /app/oracle/oradata/db1/scripts/hotbackupscript.sql, as defined in the spool statement. This path must exist and be writeable to the user. This script file will be written to incluse a number of sqlplus statements, which are later executed using the line beginning with @ right at the bottom. It then adds commands to do the following: does an rm of /app/oracle/backup/*, so again this directory must exist and be writeable. Create a list of ALTER DATABASE statements to enter and exit hot backup mode for the tablespace. For each tablespace, it also adds an host rsync command into the file to do the backup copy to /app/oracle/backup for each datafile in the current tablespace (a tablespace may have several datafiles). Finally, once this loop for tablespaces has completed, it adds various other commands to backup controlfiles, handle archived redologs etc. So you see, pl/sql ISN'T running a host statement at all, sqlplus is! Maybe if you told us exactly what changes tou made to the locations from the original wiki, and what changes you made to the scripts we may be able to spot what is wrong! Can you run the hotbackup script directly in sqlplus using @ runhotbackup.sql from within sqlplus? If so, then the problem is elsewhere, if not then error message sill help us diagnose the problem further. -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Issue backing up Oracle database using Bacula
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. Thanks, NK Mogaroy -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
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 -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
