Execution of BRBACKUP finished with return code 5

[Former Member]

I am trying take off line DB backup ( Oracle 11G ) with BRBACKUP, at the end after all the data files are backed up, it ends up with the error message as below :

BR0280I BRBACKUP time stamp: 2011-10-29 13.18.05

BR0063I 44 of 44 files processed - 149792.322 MB of 149792.322 MB done

BR0204I Percentage done: 100.00%, estimated end time: 13:18

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2011-10-29 13.18.07

BR0304I Starting and opening database instance HRD ...

BR0278E Command output of '/oracle/HRD/112_64/bin/sqlplus /nolog < /oracle/HRD/sapbackup/.behcjbzj.spi':

SQL*Plus: Release 11.2.0.2.0 Production on Sat Oct 29 13:18:07 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> Connected to an idle instance.

SQL>

SQL> ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Database mounted.

Database opened.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

BR0280I BRBACKUP time stamp: 2011-10-29 13.18.28

BR0279E Return code from '/oracle/HRD/112_64/bin/sqlplus /nolog < /oracle/HRD/sapbackup/.behcjbzj.spi': 0

BR0302E SQLPLUS call for database instance HRD failed

BR0306E Start and open of database instance HRD failed

BR0056I End of database backup: behcjbzj.afd 2011-10-29 13.18.28

BR0280I BRBACKUP time stamp: 2011-10-29 13.18.29

BR0054I BRBACKUP terminated with errors

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 5

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRTOOLS time stamp: 2011-10-29 13.18.29

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

[Former Member · Accepted solution]

Hi,

>> SQL> ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

There must be an obsolute parameter in your SPFILE. So, check the note 1431798 - Oracle 11.2.0: Database Parameter Settings and 1171650 - Automated Oracle DB parameter check to fix your values.

One possible reason is REMOTE_OS_AUTHENT parameter might be left in the profiles. So you should apply the parameters in the notes.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Thanks for your reply,

In my system it is set to

SQL> show parameter REMOTE_OS_AUTHENT;

NAME TYPE VALUE

-

---

-

---

-

---

remote_os_authent boolean TRUE

that's why we are getting ORA-32004 which is as expected. I have briefly checked both the notes you have provided, donot see any problem yet.

datafiles are backed up 100% at the last after opening the database , SQLPLUS call to DB failed,

My question is if datafiles and control files are backed up successfully even with the error , can i use those to restore the DB ?

I thnik problem is coming while SQL is trying connect DB

BR0279E Return code from '/oracle/HRD/112_64/bin/sqlplus /nolog < /oracle/HRD/sapbackup/.behcjbzj.spi': 0

BR0302E SQLPLUS call for database instance HRD failed

BR0306E Start and open of database instance HRD failed

BR0056I End of database backup: behcjbzj.afd 2011-10-29 13.18.28

BR0280I BRBACKUP time stamp: 2011-10-29 13.18.29

BR0054I BRBACKUP terminated with errors

[Former Member · Accepted solution]

Hi,

To be sure, are you able to connect to the database by the command, below?

SQLplus "/as sysdba"

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun,

Yes I can connect via SQLPLUS and R3trans -d with 0 return code with user sidadm.

Thanks again for your replies

-Al Mamun

[Former Member · Accepted solution]

What is the brtools release? It should be 7.20 for 11g. Try to download and path lastest Brtoosl 7.20 on SAP Marketplace

Check the note 12741 - Current versions of BR*Tools and SAPDBA

Best regards,

Orkun Gedik

[former_member188883 · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Thanks , Orkun

It worked like charm! It was a good guess, yes, I forgot to upgrade BRTOOLS to 7.2 for Oracle 11G.