Problem with online split backup, database oracle

[Former Member]

Hello,

we use for backup our SAP system online split backup, our database is almost 3TB big. Backup is functional but sometimes (4x-5x per month) backup fail with error bellow. If i understant this problem correctly brbackup lost connection to oracle after split disk system and cant stop backup mode in database and backup failed. How can i solve this problem? Exist some parameter for brbackup for reconnect to db when brbackup lost connection? Thanks for your help!

BR0051I BRBACKUP 7.00 (25)

BR0262I Enter database user name[/password]:

BR0055I Start of database backup: bebnhrzd.anf 2009-09-22 14.52.25

BR0484I BRBACKUP log file: /oracle/BP1/sapbackup/bebnhrzd.anf

BR0351I Restoring /oracle/BP1/sapbackup/cntrlBP1.dbf

BR0355I from /oracle/BP1/sapbackup/cntrlBP1.dbf ...

BR0280I BRBACKUP time stamp: 2009-09-22 14.53.10

BR0319I Control file copy created: /oracle/BP1/sapbackup/cntrlBP1.dbf 21676032

BR0280I BRBACKUP time stamp: 2009-09-22 14.53.13

BR0315I 'Alter database begin backup' successful

BR0280I BRBACKUP time stamp: 2009-09-22 14.53.14

BR0295I Splitting mirror disks...

BR0280I BRBACKUP time stamp: 2009-09-22 16.07.43

BR0296I Split of mirror disks successful

BR0280I BRBACKUP time stamp: 2009-09-22 16.17.44

BR0301E SQL error -3135 at location BrBackAlter-3, SQL statement:

'/* BRBACKUP */ ALTER DATABASE END BACKUP'

ORA-03135: connection lost contact

BR0280I BRBACKUP time stamp: 2009-09-22 16.17.44

BR0318E 'Alter database end backup' failed

BR0280I BRBACKUP time stamp: 2009-09-22 16.17.44

BR0301E SQL error -3114 at location BrBackAlter-3, SQL statement:

'/* BRBACKUP */ ALTER DATABASE END BACKUP'

ORA-03114: not connected to ORACLE

BR0280I BRBACKUP time stamp: 2009-09-22 16.17.44

BR0318E 'Alter database end backup' failed

BR0280I BRBACKUP time stamp: 2009-09-22 16.17.44

BR0301W SQL error -3114 at location BrbDbLogClose-1, SQL statement:

'UPDATE SAP_SDBAH SET RC = '0005', ENDE = '20090922161744', OBJ = ' ', LINE = '# 224 0 0 81358 7817759352 0 0 ALL online_split util_file -

---

7.00 (25)' WHERE BEG = '20090922145225' AND FUNCT = 'anf' AND SYSID = 'BP1''

ORA-03114: not connected to ORACLE

BR0326W Update of database log header failed

BR0056I End of database backup: bebnhrzd.anf 2009-09-22 16.17.44

BR0280I BRBACKUP time stamp: 2009-09-22 16.17.44

BR0054I BRBACKUP terminated with errors

Backup utility finished with returncode 5

Backup FAILED

[sunny_pahuja2]

Hi Karel,

Check SAP Note 534729 - Oracle errors due to network problems

Thanks

Sunny

[Former Member]

Hello,

in note 534729 is nothing about ORA-03135: connection lost contact only error ORA-03114 which refer to the note 335199 and in this note in nothing about ORA-03114 I want to say two things: this two oracle errors (ORA-03135 and ORA-03114) are not in alertSID.log on db server or in syslog on backup server. This error are only reported from brbackup which is running on backup server which is "client side". We don't have problem with connection from work processes on all instances to db server, we have only problem with brbackup which lost connection after split disk system. How i say this problem occurs only sometimes. I was tested network connection from backup server to db server via niping a this is result:

(root@hytti) #./niping -c -H kiuru -B 30000

Sat Sep 26 14:10:58 2009

connect to server o.k.

send and receive 10 messages (len 30000)

-

---

times -

---

avg 7305 usecs

max 46234 usecs

min 2168 usecs

bw 8020.50 kb/sec

excluding max and min:

av2 3081 usecs

bw2 19013.91 kb/sec

do you have any idea?? Thanks!

[Former Member]

Karel,

ORA-03114 occurs when the database client process, here BRBACKUP, loses its connection to the DBMS. ORA-03135 is an error code that came in with Oracle 10, and it often appears in conjunction with ORA-03114. These errors are not logged in the alertSID.log, but there should be dumps in $ORACLE_HOME/saptrace/usertrace or possibly $ORACLE_HOME/saptrace/background (usertrace is more likely because this was a user process-level error). Check these dumps first and let us know.

Regards,

Mark

[Former Member]

I found only these errors in sqlnet.log:

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

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for HPUX: Version 10.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for HPUX: Version 10.2.0.2.0 - Production

TCP/IP NT Protocol Adapter for HPUX: Version 10.2.0.2.0 - Production

Time: 22-SEP-2009 17:04:22

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505

TNS-00505: Operation timed out

nt secondary err code: 238

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.152.170)(PORT=64305))

[Former Member]

Can you check/set following parameters in sqlnet.ora:

SQLNET.EXPIRE_TIME = 5

SQLNET.INBOUND_CONNECT_TIMEOUT = 120

Rgds,

Mark