Home » Server Options » RAC & Failsafe » Sap Backups On rac Environment (Linux scrbdefrmr207 2.6.18-164.10.1.el5 / Oracle 10.2.0.5 )
icon11.gif  Sap Backups On rac Environment [message #519403] Thu, 11 August 2011 16:39 Go to next message
Morgs
Messages: 21
Registered: October 2010
Location: South AFrica
Junior Member

Hi Guys

I am having an issue when trying to run a backup from node 207..

Initially When trying to run the backup I got this error.

scrbdefrmr207:orarer 54> brbackup -u / -c force -t online -m all -p initRER_online.sap
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: begnlswy.anf 2011-08-11 21.29.08
BR0484I BRBACKUP log file: /oracle/RER/sapbackup/begnlswy.anf
BR0477I Oracle pfile /oracle/RER/102_64/dbs/initRER001.ora created from spfile /oracle/RER/102_64/dbs/spfileRER001.ora

BR0280I BRBACKUP time stamp: 2011-08-11 21.29.13
BR1351I Configuration of database services:
RER001 PREF: RER001 AVAIL:
RER002 PREF: RER002 AVAIL:
DVEBMGS50_scrbdefrmr207 PREF: RER001 AVAIL: RER002
DVEBMGS50_scrbdefrmr208 PREF: RER002 AVAIL: RER001

BR0280I BRBACKUP time stamp: 2011-08-11 21.29.14
BR1352I Status of database services:
Service RER001 is running on instance(s) RER001
Service RER002 is running on instance(s) RER002
Service DVEBMGS50_scrbdefrmr207 is running on instance(s) RER001
Service DVEBMGS50_scrbdefrmr208 is running on instance(s) RER002
BR0278E Command output of '/usr/sap/RER/SYS/exe/run/brtools -f printcmd -U /oracle/RER/sapbackup/.begnlswy.003 'archive log list;' 'exit;' | /oracle/RER/102_64/bin/sqlplus /nolog':

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Aug 11 21:29:16 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL>
BR0280I BRBACKUP time stamp: 2011-08-11 21.29.16
BR0279E Return code from '/usr/sap/RER/SYS/exe/run/brtools -f printcmd -U /oracle/RER/sapbackup/.begnlswy.003 'archive log list;' 'exit;' | /oracle/RER/102_64/bin/sqlplus /nolog': 0
BR0302E SQLPLUS call for database instance RER002 failed

BR0056I End of database backup: begnlswy.anf 2011-08-11 21.29.16
BR0280I BRBACKUP time stamp: 2011-08-11 21.29.16
BR0054I BRBACKUP terminated with errors

**********************

I then relealised that my dbenv profile i.e .dbenv_scrbdefrmr207.csh was missing the rac parametrs to connect to the other node i.e

setenv BR_NNP 1
setenv BR_NTS 1
setenv BR_RSC 1
setenv BR_RSH_CMD /usr/bin/ssh

I then changed my dbenv profile and now i am getting this erroe message ...

scrbdefrmr207:orarer 53> brbackup -u / -c force -t online -m all -p initRER_online.sap
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: begnlthd.anf 2011-08-11 21.33.33
BR0484I BRBACKUP log file: /oracle/RER/sapbackup/begnlthd.anf

BR0280I BRBACKUP time stamp: 2011-08-11 21.33.37
BR1351I Configuration of database services:
RER001 PREF: RER001 AVAIL:
RER002 PREF: RER002 AVAIL:
DVEBMGS50_scrbdefrmr207 PREF: RER001 AVAIL: RER002
DVEBMGS50_scrbdefrmr208 PREF: RER002 AVAIL: RER001

BR0280I BRBACKUP time stamp: 2011-08-11 21.33.38
BR1352I Status of database services:
Service RER001 is running on instance(s) RER001
Service RER002 is running on instance(s) RER002
Service DVEBMGS50_scrbdefrmr207 is running on instance(s) RER001
Service DVEBMGS50_scrbdefrmr208 is running on instance(s) RER002
BR0278E Command output of '/usr/sap/RER/SYS/exe/run/brtools -f printcmd -U /oracle/RER/sapbackup/.begnlthd.003 'archive log list;' 'exit;' | /usr/bin/ssh scrbdefrmr208 /bin/sh -c "'LANG=C /oracle/RER/102_64/bin/sqlplus /nolog || echo ERR_RC: \$?'"':
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-08-11 21.33.39
BR0279E Return code from '/usr/sap/RER/SYS/exe/run/brtools -f printcmd -U /oracle/RER/sapbackup/.begnlthd.003 'archive log list;' 'exit;' | /usr/bin/ssh scrbdefrmr208 /bin/sh -c "'LANG=C /oracle/RER/102_64/bin/sqlplus /nolog || echo ERR_RC: \$?'"': 0
BR0302E SQLPLUS call for database instance RER002 failed

BR0056I End of database backup: begnlthd.anf 2011-08-11 21.33.39
BR0280I BRBACKUP time stamp: 2011-08-11 21.33.39
BR0054I BRBACKUP terminated with errors

*****

I have many other rac servers and sids setup this way and they all work,,

I can login to sqlplus and do any changes .. no issues going into sqlplus in node 207 and node 208..

I have checked the directory i.e mesg and teh files are there ..

scrbdefrmr207:orarer 56> pwd
/oracle/RER/102_64/sqlplus/mesg
scrbdefrmr207:orarer 57> ls
cpyus.msb cpyus.msg sp1us.msb sp1us.msg sp2us.msb sp2us.msg

AppreciaTE any help guys and girls as I am rather stuck now.. I think the message is decieving as it complains about oracle home and sp1<lang>.msb not found ,, when i tis there.

I have also checked my env variables .. they all there i.e
scrbdefrmr207:orarer 58> env |grep ORA
dbms_type=ORA
ORACLE_SID=RER001
ORACLE_HOME=/oracle/RER/102_64
ORACLE_BASE=/oracle

scrbdefrmr207:orarer 59> env | grep LD_
LD_LIBRARY_PATH=/usr/sap/RER/SYS/exe/run:/oracle/RER/102_64/lib

Hi One other thing.. I an run archives log bckups perfectly.. So its only when its trying to connect into the db i Think

Thanks in advance
Morga Moodaley


[Updated on: Thu, 11 August 2011 16:43]

Report message to a moderator

Re: Sap Backups On rac Environment [message #519404 is a reply to message #519403] Thu, 11 August 2011 17:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no Idea about SAP backups.
But this
Message file sp1<lang>.msb not found

generally means an issue with your PATH.


I would always set
PATH=$PATH:$ORACLE_HOME/bin:restOfPaths

along with ORACLE_SID,ORACLE_HOME and ORACLE_BASE

[Updated on: Thu, 11 August 2011 17:11]

Report message to a moderator

Re: Sap Backups On rac Environment [message #519438 is a reply to message #519403] Fri, 12 August 2011 03:05 Go to previous messageGo to next message
enderx
Messages: 1
Registered: August 2011
Junior Member
Ensure that the environment variables are being loaded correctly on the alternate RAC node when ssh commands are being executed.

You can test this by doing the following:

host1:orasid> ssh <host2> env

Compare this with running 'env' after logging in to <host2> directly with the ora<sid> user that will be running the backups.

Running ssh commands remotely uses a non-login shell as opposed to logging in directly to the host, so if there a difference in environment variables when running the above test this could mean that the .cshrc or .bashrc file is missing (depending on which shell is being used) on the other host.
Re: Sap Backups On rac Environment [message #529585 is a reply to message #519403] Wed, 02 November 2011 01:49 Go to previous messageGo to next message
tzyy
Messages: 1
Registered: November 2011
Junior Member
Hi Morgs,

I am facing similar issue. Did you manage to find a resolution?

Regards,
TM
Re: Sap Backups On rac Environment [message #529610 is a reply to message #529585] Wed, 02 November 2011 03:09 Go to previous message
Morgs
Messages: 21
Registered: October 2010
Location: South AFrica
Junior Member

Hi

This worked


Ensure that the environment variables are being loaded correctly on the alternate RAC node when ssh commands are being executed.

You can test this by doing the following:

host1:orasid> ssh <host2> env

Compare this with running 'env' after logging in to <host2> directly with the ora<sid> user that will be running the backups.

Running ssh commands remotely uses a non-login shell as opposed to logging in directly to the host, so if there a difference in environment variables when running the above test this could mean that the .cshrc or .bashrc file is missing (depending on which shell is being used) on the other host.

Thanks
Morga Moodaley
Previous Topic: oracle 10g TAF fails for TOAD
Next Topic: cannot change owner of cifs mount on linux
Goto Forum:
  


Current Time: Thu Sep 24 09:44:39 CDT 2020