on 06-26-2013 1:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kiran,
I agree with Deepak Kori 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kiran,
Can you please check if
and reply back.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.