Backup offline error

[Former Member]

Hello,

I’m trying to perform an offline backup using brtools and it works fine (100% files are copied) but the backup fails starting the database and finish with the following messages:

R0280I BRBACKUP time stamp: 2008-04-22 00.51.26

BR0063I 32 of 32 files processed - 71986.768 MB of 71986.768 MB done

BR0204I Percentage done: 100.00%, estimated end time: 0:51

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

BR0280I BRBACKUP time stamp: 2008-04-22 00.51.30

BR0304I Starting and opening database instance RNP ...

BR0278E Command output of 'D:\oracle\ora92\bin\SQLPLUS':

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Apr 22 00:51:30 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> ERROR:

ORA-12560: TNS:protocol adapter error

SQL>

SQL> ORA-12560: TNS:protocol adapter error

SQL>

BR0280I BRBACKUP time stamp: 2008-04-22 00.51.31

BR0279E Return code from 'D:\oracle\ora92\bin\SQLPLUS': 0

BR0302E SQLPLUS call for database instance RNP failed

BR0306E Start and open of database instance RNP failed

BR0280I BRBACKUP time stamp: 2008-04-22 00.51.31

BR0301E SQL error -12560 at location BrDbConnect-2

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance RNP failed

BR0056I End of database backup: bdxtgnnp.afd 2008-04-22 00.51.31

BR0280I BRBACKUP time stamp: 2008-04-22 00.51.31

BR0054I BRBACKUP terminated with errors

We perform daily online backups which work fine and end without errors.

We are running SAP basis 6.40, Oracle 9.2.0.6 in a MS Cluster Windows 2003, brtools 6.40 (48)

Thanks in advance and regards,

Marta

[Former Member]

Hi,

I’ve re-read the note 441518 and I’ve checked the brbackup and the database are running on the same node (in fact, the database files are copied). I’ve also read the note 112266 and the recommended parameters are ok.

I run the offline backup in the same way I run the online backup: using a windows schedule task, which runs as domain\SIDadm:

cluster /cluster:SAPSERVER55 resource "SAP-R/3 RNP" /off

brbackup -p initRNP.sap -c -d disk -r c:\windows\sapcluster\biparam.ini -t offline -m all -k no -l E

I also checked the event log and I found the following entry at backup start time:

IsAlive poll of resource RNP.WORLD failed on the first attempt to query the database with the following error: ORA-12152: TNS:unable to send break message

Any ideas?

Thanks.

Marta

[former_member185954]

I think the backup process gets delayed and the PMON then breaks the connection.

I googled this out and found the following:

http://oraclequirks.blogspot.com/2007/04/ora-12152-tnsunable-to-send-break.html

Regards,

Siddhesh

[Former Member]

Hi. First read the Note 441518 - ORA-12560 composite SAP Note,especcialy 12 (as you use the cluster). Have in view of on windows BRTOOLS works under SAPServiceSID user , chek the enviroment variables for this user.

P.S. Also chek the Event log on your WIN server. Regards.

Edited by: Sergo Beradze on Apr 22, 2008 4:42 PM