 Sap Backups On rac Environment [message #519403] |
Thu, 11 August 2011 16:39  |
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 #529610 is a reply to message #529585] |
Wed, 02 November 2011 03:09  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
