cancel
Showing results for 
Search instead for 
Did you mean: 

BACKUP Getting Failed in DB13

Former Member
0 Kudos

Hi Experts,

Backup is getting failed from last 2 days  and find the below DB13log.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000387, user ID SANPAL)

Execute logical command BRBACKUP On host darwin

Parameters:-u / -jid ALLOG20130625141321 -c force -t online -m all -p initERD.sap -a -c force -p initERD.sap -c

ds

BR0051I BRBACKUP 7.20 (30)

BR0055I Start of database backup: belmtmag.anf 2013-06-25 14.13.34

BR0484I BRBACKUP log file: /oracle/ERD/sapbackup/belmtmag.anf

BR0280I BRBACKUP time stamp: 2013-06-25 14.13.34

BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310E Connect to database instance ERD failed

BR0280I BRBACKUP time stamp: 2013-06-25 14.13.34

BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310E Connect to database instance ERD failed

BR0056I End of database backup: belmtmag.anf 2013-06-25 14.13.34

BR0280I BRBACKUP time stamp: 2013-06-25 14.13.34

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2013-06-25 14.13.34

BR0291I BRARCHIVE will be started with options '+belmtmag.anf -U -jid ALLOG20130625141321  -c force-p initERD.sap -cds'

BR0002I BRARCHIVE 7.20 (30)

BR0169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored for 'brarchive' -'util_file' assumed

BR0006I Start of offline redolog processing: aelmtmag.cds 2013-06-25 14.13.34

BR0484I BRARCHIVE log file: /oracle/ERD/saparch/aelmtmag.cds

BR0280I BRARCHIVE time stamp: 2013-06-25 14.13.34

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0280I BRARCHIVE time stamp: 2013-06-25 14.13.34

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0280I BRARCHIVE time stamp: 2013-06-25 14.13.34

BR0008I Offline redolog processing for database instance: ERD

BR0009I BRARCHIVE action ID: aelmtmag

BR0010I BRARCHIVE function ID: cds

BR0048I Archive function: copy_delete_save

BR0011I 16 offline redolog files found for processing, total size 721.667 MB

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility at file level

BR0290I This run was started by BRBACKUP

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRARCHIVE time stamp: 2013-06-25 14.13.34

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/ERD/SYS/exe/run/backint -u ERD -f backup -i /oracle/ERD/saparch/.aelmtmag.lst -t file -p /or

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.03

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2717_795216575.dbf

#SAVED.... 1372184018

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.03

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2715_795216575.dbf

#SAVED.... 1372184015

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.08

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2720_795216575.dbf

#SAVED.... 1372184103

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.08

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2716_795216575.dbf

#SAVED.... 1372184106

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.14

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2724_795216575.dbf

#SAVED.... 1372184109

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.17

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2729_795216575.dbf

#SAVED.... 1372184112

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.22

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2728_795216575.dbf

#SAVED.... 1372184115

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.22

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2718_795216575.dbf

#SAVED.... 1372184118

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.25

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2723_795216575.dbf

#SAVED.... 1372184122

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.27

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2714_795216575.dbf

#SAVED.... 1372184125

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.27

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2714_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.27

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2715_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.27

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2716_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.27

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2717_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.27

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2718_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.33

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2722_795216575.dbf

#SAVED.... 1372184128

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.37

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2725_795216575.dbf

#SAVED.... 1372184131

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.37

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2721_795216575.dbf

#SAVED.... 1372184134

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.42

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2726_795216575.dbf

#SAVED.... 1372184138

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2719_795216575.dbf

#SAVED.... 1372184141

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2719_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2720_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2721_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2722_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2723_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2724_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2725_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.45

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2726_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.47

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2727_795216575.dbf

#SAVED.... 1372184144

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.47

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2727_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.47

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2728_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.47

BR0015I Offline redolog file /oracle/ERD/oraarch/ERDarch1_2729_795216575.dbf deleted

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.47

BR0232I 16 of 16 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.48

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.48

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0278W Command output of '/oracle/ERD/112_64/bin/sqlplus /nolog < /oracle/ERD/saparch/.aelmtmag.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 25 14:15:48 2013

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

SQL> Connected to an idle instance.

SQL>

SQL> SQL> SQL> SQL> ORA-01012: not logged on

SQL> Disconnected

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.49

BR0279W Return code from '/oracle/ERD/112_64/bin/sqlplus /nolog < /oracle/ERD/saparch/.aelmtmag.spi': 0

BR0302W SQLPLUS call for database instance ERD failed

BR0323W 'Archive log list' for database instance ERD failed

BR0039I Last offline redolog file /oracle/ERD/oraarch/ERDarch1_2734_795216575.dbf will not be backed due to connect error to dat

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.49

BR0012I 4 next offline redolog files found for processing, total size 179.456 MB

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.49

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/ERD/SYS/exe/run/backint -u ERD -f backup -i /oracle/ERD/saparch/.aelmtmag.lst -t file -p /or

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.53

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2732_795216575.dbf

#SAVED.... 1372184149

BR0280I BRARCHIVE time stamp: 2013-06-25 14.15.55

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2733_795216575.dbf

#SAVED.... 1372184152

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.00

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2730_795216575.dbf

#SAVED.... 1372184155

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.04

#ARCHIVE.. /oracle/ERD/oraarch/ERDarch1_2731_795216575.dbf

#SAVED.... 1372184158

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.04

BR0232I 4 of 4 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.04

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.04

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0278W Command output of '/oracle/ERD/112_64/bin/sqlplus /nolog < /oracle/ERD/saparch/.aelmtmag.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 25 14:16:04 2013

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

SQL> Connected to an idle instance.

SQL>

SQL> SQL> SQL> SQL> ORA-01012: not logged on

SQL> Disconnected

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.04

BR0279W Return code from '/oracle/ERD/112_64/bin/sqlplus /nolog < /oracle/ERD/saparch/.aelmtmag.spi': 0

BR0302W SQLPLUS call for database instance ERD failed

BR0323W 'Archive log list' for database instance ERD failed

BR0039I Last offline redolog file /oracle/ERD/oraarch/ERDarch1_2734_795216575.dbf will not be backed due to connect error to dat

BR0016I 20 offline redolog files processed, totalsize 901.122 MB

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.04

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/ERD/SYS/exe/run/backint -u ERD -f backup -i /oracle/ERD/saparch/.aelmtmag.lst -t file -p /or

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.08

#PFLOG.... /oracle/ERD/saparch/archERD.log

#SAVED.... 1372184165

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.10

#PFLOG.... /oracle/ERD/sapreorg/strucERD.log

#SAVED.... 1372184168

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.14

#PFLOG.... /oracle/ERD/112_64/dbs/initERD.sap

#SAVED.... 1372184171

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.16

#PFLOG.... /oracle/ERD/112_64/dbs/initERD.utl

#SAVED.... 1372184174

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.21

#PFLOG.... /oracle/ERD/saparch/aelmtmag.cds

#SAVED.... 1372184177

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.23

#PFLOG.... /oracle/ERD/sapreorg/spaceERD.log

#SAVED.... 1372184180

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.25

#PFLOG.... /oracle/ERD/112_64/dbs/spfileERD.ora

#SAVED.... 1372184183

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.28

#PFLOG.... /oracle/ERD/112_64/dbs/initERD.ora

#SAVED.... 1372184186

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.28

BR0232I 8 of 8 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.28

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid =1000 (dba), current egid = 1001 (sapsys)

BR0310W Connect to database instance ERD failed

BR0007I End of offline redolog processing: aelmtmag.cds 2013-06-25 14.16.28

BR0280I BRARCHIVE time stamp: 2013-06-25 14.16.28

BR0004I BRARCHIVE completed successfully with warnings

BR0280I BRBACKUP time stamp: 2013-06-25 14.16.28

BR0292I Execution of BRARCHIVE finished with return code 0

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Thanks

Kiran.GVL

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Kiran,

Refer SAP note

583861 UNIX: Errors due to Oracle executable

Check whether $ORACLE_HOME/bin/oracle has the right permissions.

Hope this helps.

Regards,

Deepak Kori

Answers (7)

Answers (7)

Former Member
0 Kudos

Hi All,

This issue has been resolved after chnaging the permissiona and chnaged to user ORASID.

Thanks

Kiran.GVL

former_member182034
Active Contributor
0 Kudos

hi Kiran,

Please follow the instruction of below link

ORA-27140, ORA-27303

Regards,

Former Member
0 Kudos

Hi kiran,

I think u must check user is there in DBA_USERS table, if not create it again.

Also grant the user connect, resource access for the database.

Second, also check if SAPSR3 user is in LOCKED status. If it is locked just unlock it.

and last change the password of SAPSR3 user using "brconnect".

Then run the backup again

Regards

Gokul

Former Member
0 Kudos

Dear Kiran,

It is due to bin/oracle privilege problem. First grant 7521 to oracle in both GI_HOME/bin and ORACLE_HOME/bin, then execute:

$GRID_HOME/bin/setasmgidwrap o=$ORACLE_HOME/bin/oracle

Regards

Gokul

former_member206552
Active Contributor
0 Kudos

Hi Kiran,

I agree with please verify that the file permissions of /$ORACLE_HOME/bin/oracle is correct, if this is not the problem please update the tread

Best Regards

Marius

Former Member
0 Kudos

I Have alreday checked the permisiosn and all are fine even i have replied to Deepike with screenshots.

Thanks

Kiran.GVL

former_member206552
Active Contributor
0 Kudos

the files in $ORACLE_HOME should not be owned by root the owner should be

oraSID:dba

Former Member
0 Kudos

Hi Deepak/Siddique,

I have alreday checked permisions & Permission are find and it's happening from last 2 days and 4 days back we have done oralce upgrde to 11.2

Thnaks

Kiran.GVL

Former Member
0 Kudos

Check oracle executable permissions in $ORACLE_HOME/bin directory. What OS you use?

Former Member
0 Kudos

Hi Kiran,

Can you please check if 

  • brtools utility is of latest version. If not please upgrade it.
  • proper permission are set for executable of brtools . refer to snote 113747

and reply back.