Home » Server Options » RAC & Failsafe » Sap Backups On rac Environment (Linux scrbdefrmr207 2.6.18-164.10.1.el5 / Oracle 10.2.0.5 )
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
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat May 03 03:26:51 CDT 2025
|